Taking away a percentage from a sum.
Hi,
I would like to subtract 15% from a cell which already has a formula.
for example:
=SUM(3600/H16) This gives me an answer, but I now want to take 15% off that answer without using any other cells.
I thought =SUM(3600/H16)-1.15 would work but of course it just takes away 1.15 from the sum not 15%
H16 will be an amount gathered from another worksheet and will be different each time.
Any help would be appreciated
Carl
|