Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# How to Calculate Discount Percentage with Formula in Excel

Microsoft Excel is a powerful tool for basic and complicated calculations. With the help of it, you can easily calculate the percentage value, like a discount percentage. In today’s session, I’m going to show you how to calculate the discount percentage with formula in Excel. The formula, I’m going to use, will work on all versions of Microsoft Excel.

You may download the following Excel workbook for better understanding and practice it by yourself.

## 2 Easy Ways to Calculate Discount Percentage with Formula in Excel

One of the formulae that are regularly used in Excel is the discount calculation formula. Calculations involving discounts are made easier and faster using Excel. We are aware that Microsoft Excel is a useful tool for both straightforward and complicated calculations. Calculating percentage numbers, such as discount percentages, is made simple by this. Let’s suppose we have a sample data set. ### 1. Calculate Discount Percentages from Price Difference

The discount percentage can be calculated using this method, which is the simplest. Simply compute the price difference and divide it by the Fall Price (Original Price) from the data set.

Step 1:

• Firstly, select the E5 cell.
• Secondly, write down the following formula here.
`=(C5-D5)/C5`
• Thirdly, press ENTER. Step 2:

• As a result, you will see the discount percentage of the first product in the E5 cell.
• Then, use the Fill Handle tool and drag it down from the E5 cell to the E10 cell. Step 3:

• Finally, you will see all the discount percentages for all the products in the data set below. Read More: Percentage Formula in Excel (6 Examples)

### 2. Get Discount Percentages from Price Ratio

Here we will demonstrate another method to calculate the discount percentage with formula in Excel by using the price of the discount and the original price and then subtracting it from the 1.

Step 1:

• Firstly, choose the E5 cell.
• Then, type the following formula here.
`=1-(D5/C5)`
• After that, hit ENTER. Step 2:

• Therefore, the given image displays the discount percentage of the first product in the E5 cell.
• Besides, use the Fill Handle tool and drag it down from the E5 cell to the E10 cell. Step 3:

• Lastly, the given image shows all the discount percentages for all the products available on the date set here. ## Conclusion

In this article, I’ve covered 2 ways to calculate discount percentages in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

## Related Articles #### Shakil Ahmed

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

We will be happy to hear your thoughts 