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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top