How to Calculate Discount Percentage with Formula in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.


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.

 Easy Ways to Calculate Discount Percentage in Excel


1. Using Excel Formula to Calculate Discount Percentages from Value 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.

 Calculate Discount Percentages from Price Difference to Calculate Discount Percentage in Excel

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: How to Calculate Discount Factor in Excel


2. Calculating Discount Percentages from Value Ratio with Excel Formula

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.

Get Discount Percentages from Price Ratio to Calculate Discount Percentage in Excel

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.

Read More: How to Calculate Discount Rate in Excel


Download Practice Workbook

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


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. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shakil Ahmed
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo