How do I find a percentage?

P

PBarton

I'm trying to find a formula that will show 10% of another cell (or group of
cells). If a cell or group of cells adds up to 100, what is the formula that
will tell me that 10% of that is 10?
 
J

joeu2004

PBarton said:
I'm trying to find a formula that will show 10%
of another cell (or group of cells). If a cell or
group of cells adds up to 100, what is the formula
that will tell me that 10% of that is 10?
Click to expand...

If A1 is the cell with 100 (or whatever value),
arguably the most readable formula is:

=A1*10%

Of course, you could also write:

=A1*0.10

I cannot think of a good reason to write it any
differently. "Things should be as simple as possible,
but no simpler" -- Einstein.
 
Top