Get original price from percentage discount
Generic formula
=price/(1-discount)
Related formulas
Increase by percentage
Decrease by percentage
Percent of goal
Calculate percent variance
Explanation
If you have a discounted price and know the discount percentage, you can calculate the original price with a simple formula that pides the discounted price by the result of 1 minus the discount percentage.
How the formula works
In the example, the active cell contains this formula:
=C6/(1-D6)
In this case, Excel first calculates the result of 1 - the value in D6 (.2) to get 0.8. Next the value in C6 (56), which represents the discounted or "sale" price, is pided by 0.8 to get a final result of 70:
=56/(1-0.2)=56/0.8=70