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...
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'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.