Percentage

  • Thread starter Office 2004 Test Drive User
  • 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?
 
Ad

Advertisements

N

Niek Otten

<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?
|
 
Ad

Advertisements

J

joeu2004

Office said:
I need to calculate the percentage of a number in a specified period. Can
excel calculate a percentage of an occurence?
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

Percentages 1
percentages 1
Percentages 3
percentages... 2
Minus Percentage.. 2
Percentage calculation 3
Calculate a Percentage 2
Calculating Percentage? 2

Top