Forum Discussion
Find price "X" from a discounted and marked up Total Cost
Task: cataloging receipts from expenditures.
Have receipts with multiple items listed. The subtotal has been discounted from the original retail price by 10%. That discounted subtotal is then marke...
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.