Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Charts and Charting in Excel | |||
percentage | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Percentage doesn't add up | Excel Discussion (Misc queries) |