Percentage

  • Thread starter Thread starter Office 2004 Test Drive User
  • Start date Start date
O

Office 2004 Test Drive User

I need to calculate the percentage of a number in a specified period. Can
excel calculate a percentage of an occurence?
 
<Can excel calculate a percentage of an occurence?>

Yes.

But I think you need to be more specific to get any helpful answer.

What exactly are you trying to do?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to calculate the percentage of a number in a specified period. Can
| excel calculate a percentage of an occurence?
|
 
Office said:
I need to calculate the percentage of a number in a specified period. Can
excel calculate a percentage of an occurence?
Click to expand...

Not sure what you mean. It would be better to provide a numerical
example.

If you want to compute 10% of a number in A1, then simply:

=A1*10%

If you want to compute what percentage B1 is of A1, then:

=B1 / A1

If you want to compute the percentage difference between A1 and B1,
then:

=B1 / A1 - 1

(Caveat: For the latter two, A1 and B1 must both be positive or both
be negative. And A1 cannot be zero.)

In all cases, format the cell as Percentage with the desired number of
Decimal Places. Click on Format > Cells > Number and select Percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text not always in same cell 2
Formatting and modelling 2
Access Group by precinct, calculate percentage of older voters 0
calculated field for percentage in pivot table 1
Access Test if value is less than percent 0
calculate percentage of numbers <= zero in a given range 1
Excel How to calculate percentage for time 1
Need to separate column data into headers 5

Back
Top