How do I find a percentage?
 

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?

How do I find a percentage?
 

Hi,

Try:
=A1*10/100

or

=SUM(A1:A10)*10/100

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=488508

How do I find a percentage?
 

"PBarton" wrote:
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.