# Percentage

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?

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

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.