Er,like =A1*A2 ?????

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<JoAnne wrote in message ...
How do I find percentage of a number...

say..

A1 = 100
A2= 60% of A1 (100)

Thanks

Divide 1 Cell by the other and then apply the % format to the cell.

Example (without the format % applied
100 75 0.75
with the format % applied
100 75 75.00%

then in format set how many decimal places you want.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2306229