How to Calculate Discount Percentages in Excel (Easy)

Who doesn’t like discounts? Getting a thing for only a certain percentage of its actual price is always a win-win situation.

While we see sign boards all around 20%, 30%, 50%, and other discounts. Applying a discount percentage to a price to find out the discounted price is easy 😎

But if you’re given the original and the discounted price, how do you calculate the discount percentage on it? To your good, calculating the discount percentage is not difficult either.

Follow me till the end of this guide after you’ve downloaded your free practice workbook here and learn how to do it in Microsoft Excel in minutes.

Calculating Discount Percentage in Excel

This is a section I can vouch for you to enjoy until the end.

Let’s begin with a list of some items, their retail prices, and their discounted prices (let’s assume we have a great grand black Friday sale going on) 🛒

Original and discounted prices

To calculate the discount percentage offered on these items, let’s first find out the discount of each item in absolute terms.

Step 1) Deduct the discounted price from the retail price to see what discount is offered on each item.

Click to copy
Cell B2 (Column B) minus Cell C2 (Column C)

You get $200 off on a laptop that’s worth $1000 – sounds like a good deal 💻

Step 2) Drag the above formula down the whole list of prices to calculate the discount for each item.

Discount on the whole list

After we have calculated the amount of discount on each item, calculating the discount percentage is super simple.

Step 3) Divide the amount of discount by the original price to see what proportion the discount is of the original price.

Click to copy
Discount as a proportion of price

So, you get a 20% discount on laptops 🤩

Pro tip

To know what percentage discount is offered on an item, we need to see what proportion the discount amount is of the original price.

For example, if you’re offered a $100 sale price item for $80 only, you get a discount of $20.

See the discount as a proportion of the original price:

Click to copy

You are only paying 80% price while 20% price is waived off 🚩

If your results look like a decimal number instead of a percentage, you need to format them as a percentage.

Result as a decimal places

Step 4) Go to the Home tab > Number Group > Click on the Percentage Icon

format cells as percentage

Step 5) Drag this formula down to the whole list.

Discount formula for the whole list

We have varying discount percentages for all the items. From 20% to 50%.

This is how easy it is to calculate discount percentages in Excel ✌

We have calculated the discount percentage in two steps.

However, if you want to bring it down to one step and one formula, write the following formula to calculate the discount percentage in Excel:

Click to copy
Click to copy
Discount rate excel formulas


Playing around with percentages in MS Excel is fun 🚀

Discounts and discount percentages are something we see around us all the time. Just like calculating discount percentages, there are a couple of other Excel tutorials of mine that explain working around with percentages in Excel.

Hop on to the following links to check them out.

Find Percentage Difference Between Numbers in Excel worksheet

How to Calculate Percent in Excel (Percentage Formula)