< Go Back

Get original price from percentage discount

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

Formula

=price/(1-discount)

Explanation

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.

Example

In the above screenshot, you can see that to get the original price from percentage discount, we have used the following formula.

=C4(1-D4)

=100 / (1-0.2)

=100/0.8

=125

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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar