Taking away a percentage from a sum.

[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

 

[Sandy Mann]

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

 

[Bernard Liengme]

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

 

[Mike H]

Maybe:-

=((3600/H16)/100)*85

Mike