Forum Discussion
Find price "X" from a discounted and marked up Total Cost
Hello,
are you struggling with the Excel formulas to use or are you asking about the underlying maths to calculate the result? In Excel you can use the regular operators for addition (+), subtraction (-), multiplication (*) and division (/), so use the same approach you would use when calculating by hand.
I'm not quite clear what that result should be, so it would help if you could post a data sample, fill in the desired result manually and explain in context.
I've put together a data sample and some formulas.
The highlighted cells have the range names "discount", "markup" and "total", respectively.
The formulas are
Net before markup:
=total/(1+markup) Discount amount (where E11 is "Net before markup)"
=(E11/(1-discount))*discount Original markup (where F11 is "Discount amount")
=(E11+F11)*markup let me know if that helps.
- Yes, as I suspected, it looks like I will need to handle the discount and markup total separately. It's a nice challenge. I'll work on it later and reply with my thoughts for a solution. Thanks.
Sorry, I don't understand your last statement.
If you want two numbers, then you will need two formulas. I have split it into three in my reply, so it does not look too confusing, but you can of course have just two self-sufficient formulas that don't rely on other cells. Just replace the reference to E11 or F11 with the actual formula in E11 or F11. The result will not be pretty, which is why it is often easier to create a helper cell with an intermediate step and cascade formulas that reference previous cells.
- I'm looking for a formula... the issue is trying to input only the Total (which has been discounted 10% and the result marked up 7%) and expressing the discount amount of the retail price.
