Sum and Percentage

L

lindsey1975

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 :)
 
L

lindsey1975

Sorry forgot to say,


If seeling aboive list price i only need to know £95 x 15%

Is this possible
 
D

Dave F

$95 * 15% does not = $109.25.

$95 * 115% DOES equal 109.25.

So there's your first problem. (I don't know how to enter british pound
signs on my keyboard, sorry, but the math is the same whether for dollars or
pounds....)

Dave
 
F

Fred Smith

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


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 :)
 
L

lindsey1975

Fred

Thank you.

Sometime it takes someone else to have a look and simplfy thing.

Thanks Lindsey
 
Top