How to☝️ Calculate the Discount Percentage in Excel

Excel is known for its prowess with calculations and data management, allowing you to easily compute information no matter how much data you’re working with. 

A discount percentage is the number that represents how much you are saving on a purchase. If you have the original price and the discount price for a product or service, you can run a simple Excel formula to determine the percentage of the discount. 

Excel is a great tool for calculating percentages and discounts with just a few clicks. In this article, we’ll show you how to calculate the discount percentage. 

Formula for Discount Percentage in Excel

Before calculating the discount percentage, you need to prepare your data, where…

  • A2 is the cell with the original price.
  • B2 is the cell with the discounted price.
Price indicators

1. Click on the cell where you want to calculate the percentage of the price difference (C2).

2. Navigate to the Formula Bar.

3. Write the formula =B2/A2.

How to calculate the discount percentage

4. Then press the Enter key on your keyboard.

The result of calculation

Just like that, you have determined the percentage of the discount price compared to the original price. However, the answer will not display as a percentage automatically. Let’s take a look at how to change that.

5. Right-click the cell with your percentage value.

6. Choose Format Cells.

How to calculate percentage value

7. Select Percentage from the category options.  

8. Click OK.

Format Cells menu

That’s it! Super easy.

Percentage value

Now let’s calculate the percentage of the actual discount.

9. Click on the cell where you want to calculate the discount percentage.

10. Go to the Formula Bar.

11. Write the formula =1-C2, where C2 is the cell with the percentage of the discounted price.

How to calculate the percentage of the discount

12. Press the Enter key on your keyboard.

Discount percentage

And there you have it!

Looking for and taking advantage of discounts are a great way to save money. When you want to know just how much of a deal you’re getting on your purchase, use the method above to determine the discount percentage. For more tutorials covering basic calculations you need in your day-to-day life, read this guide on how to prorate in Excel.

With this simple step-by-step guide, you can easily calculate the percentage of your discount in seconds and organize your data with ease.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X