Get the Original Price from Percentage Increase
What was the original price of the smartphone before the price increase?
Current prices are in column B, price after a 20% increase (column C). What is the formula to get the original smartphone price before the percentage increase?
The Formula
=number/(1+percentage_increase)
How does the formula work
=B2/(1+C2)
The formula is the opposite of how to get the price after percentage increase formula.
How to Add Percentage in Excel (get the price after percentage increase)
The formula to get the price after percentage increase uses multiplication formula, to get the original price, use division formula and the formula in the parentheses remains the same.
=(1+C2) the result is 1.2 because the divisor is greater than 1, the original price will be smaller than the current price in cell B2. The result is $140.99, the original price before the price increase.
Get the Original Price from Percentage Decrease
What is the price of the smartphone before the discount is applied?
To get the original price before the discount is the opposite of getting the price after the discount.
How to Subtract Percentage in Excel (get the price after percentage discount)
To get the price after the discount, use the multiplication formula, while to get the price before the discount, use the division formula. The formula inside the parentheses remains the same.
The Formula
=number/(1-percentage_decrease)
How does the formula work
=B2/(1-C2)
The result of the formula (1-C2) is 0.8, smaller than 1. The original price before the discount will be greater than the current price in B2.
