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


Replace @mailinator.com with @tiscali.co.uk


"the-jackal" wrote in message
...

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




--
the-jackal

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"the-jackal" wrote in message
...

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




--
the-jackal

Maybe:-

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

Mike

"the-jackal" wrote:


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




--
the-jackal