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

Sorry forgot to say,


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

Is this possible

$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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


" wrote:

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

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

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

Mike

" wrote:

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

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

Fred

Thank you.

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

Thanks Lindsey