Sum and Percentage

[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

 

[lindsey1975]

Sorry forgot to say,


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

Is this possible

 

[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

 

[Mike]

I'm not sure I fully understand but try this:-

=(E9*0.15)+(E8-E9)

Mike

 

[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

 

[lindsey1975]

Fred

Thank you.

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

Thanks Lindsey