When you calculate $109.25 by adding 15% to $95, then subtract the original $95,
that's the same as taking 15% of $95. So your required formula simplifies to:

=e9*0.15+e10

Where e10 is e8-e9

--
Regards,
Fred


wrote in message
oups.com...
Hi

I am trying to creat a formula which creates the cost price + 15% and
includes the difference if selling at a loss

IE..
Buy £100 (E8)
Sell £95 (E9)
Difference (E10)

The sum I am trying to do is this

£100 - £95 = £5 (difference between selling and buying)
£95 x 15% = £109.25 (Total including 15% of what we sold for)

£109.25 - £95 = £14.25 + £5.00 = £19.25 (15% of selling profit
including the £5.00 loss on list price)

Any suggestions gratefully received :-)