Find percentage ???

[JoAnne]

How do I find percentage of a number...

say..

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

Thanks

 

[Bernard Liengme]

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

 

[joeu2004]

How do I find percentage of a number... say..
A1 = 100
A2= 60% of A1 (100)

In A2, put the formula

=A1*60%

Simple as that. If you have such remedial questions,
I highly recommend that you get an intro book on Excel.
Posting every little question like this will be inefficient,
if not ineffective. Generally, I like the "For Dummies"
series of books, despite the unduly demeaning title.

(Note: On the other hand, the quality of the "For
Dummies" books varies greatly. I have not looked
at the Excel For Dummies book.)

 

[wjohnson]

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