In Excel, you can get the original price from percentage discount, using a formula. But you will have to use a correct formula to do it. There is a simple formula, which you can use in Excel to get the original price from percentage discount. In this article, you will learn how to do it.
Get Original Price from Percentage Discount
Figure 1: Example of How to Get Original Price from Percentage Discount
To get the original price from the percentage discount, you need to know two values. You will need a discounted price and discount percentage.
Wondering what the discounted price is? Well, the discounted price is the price you get after applying the discount percentage on the original price. The other value you need, to get the original price from percentage discount, is the discount percentage. Some of you may already know what the discount percentage is. But for those who don’t know, the discount percentage is actually the discount you have received which you apply on the original price in order to get the final sale price or discounted price, as you can see above in the screenshot.
In the above screenshot, you can see that to get the original price from percentage discount, we have used the following formula.
=100 / (1-0.2)
Using the above formula now you can get the original price from percentage discount. But you must know how the formula actually works in Excel. Once you know how it is actually done, then you don’t have to memorize it. So, below is how it is done.
You know the sale price of your item, which is a shirt in our example above, as you can see in the screenshot. For instance, the sale price of the shirt is $100. Open excel sheet and enter $100 in a cell. For help, take a look below.
Figure 2. Enter the Sale Price
Next, you will enter the discount rate offered to you which is 20% in this case. Remember without entering the discount rate, there is no way you can get the original price from percentage discount.
Figure 3: Enter the Discount Percentage
Now, in the final cell, you will enter excel formula to get the original price from percentage discount. Use the following screenshot for help
Figure 4: Enter the Formula to Get Original Price from Percentage Discount
After entering the formula, as shown in the screenshot above, hit the Enter button from your keyboard. The Excel will give you the original price which is $125 as you can see below
Figure 5: Hit Enter button to Get the Original Price
This is how you can get the original price from percentage discount in Excel. Hope you enjoyed it.