How do I find a percentage?

[Guest]

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?

 

[pinmaster]

Hi,

Try:
=A1*10/100

or

=SUM(A1:A10)*10/100

HTH
JG

 

[Guest]

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?

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.