Sum and Percentage
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 :-) |
Sum and Percentage
Sorry forgot to say,
If seeling aboive list price i only need to know £95 x 15% Is this possible |
Sum and Percentage
$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 :-) |
Sum and Percentage
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 :-) |
Sum and Percentage
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 :-) |
Sum and Percentage
Fred
Thank you. Sometime it takes someone else to have a look and simplfy thing. Thanks Lindsey |
All times are GMT +1. The time now is 06:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com