Taking away a percentage from a sum.

  • Thread starter Thread starter the-jackal
  • Start date Start date
T

the-jackal

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
 
Try:

=3600/H16*(1-0.15)

No need for the SUM() function in this instance.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Why are you using SUM? You just need =3600/H16
What you want is: (your-answer) - 15% of your answer)
So =3600/H16 -(3600/H16)*15%
Which can be simplified to
=(3600/H16)*(1-15%)
or
=(3600/H16)*0.85
best wishes
 
Back
Top