View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.