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?
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?
Hi,
Try:
=A1*10/100
or
=SUM(A1:A10)*10/100
HTH
JG
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks