How to Calculate Discount in Excel (2 Easy Methods)

Discount is a term used in a pricing system that merges with the selling price to boost sales. This discount calculation system is used worldwide in Microsoft Excel. Today in this article, I am going to show you how to calculate discount in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Simple Methods to Calculate Discount in Excel

In the below article, I have shared 2 methods to calculate discount in excel. Mostly you will need 2 variables to calculate the discount. Stay tuned to learn the whole process of calculation.


1. Use Formula to Calculate Discount Price in Excel

While working in excel you just have to apply a simple formula to get the discount price.

Suppose we have a dataset of a Mobile selling shop with their product Selling Price & Discount Percentage for various products due to the festival. Using formula will calculate Discount Price in the workbook. In the following, I have shared 2 formulas to calculate the discount price.

Calculate Discount in Excel

1.1 Use Subtraction Formula

You can use a simple subtraction formula to get the discount price.

Steps:

  • Select a cell. Here I have selected cell (F5) to apply the formula.
  • Put the formula down-
=D5-(D5*E5)

Use Formula to Calculate Discount Price in Excel

  • Press Enter to continue.
  • Pull the “fill handle” down to fill all the cells.

  • This way we will get the discount price for all products.

Use Formula to Calculate Discount Price in Excel

1.2 Apply Multiplication Formula

We can calculate our discount price by applying the multiplication formula.

Steps:

  • Choose a cell (F5) to apply the formula.
  • Write the formula down-
=D5*(1-E5)

Use Formula to Calculate Discount Price in Excel

  • Hit the Enter
  • Drag the “fill handle” down to get the precious output.

  • Thus you can also calculate discount in excel using the two variables Selling Price and Discount Percentage.

Use Formula to Calculate Discount Price in Excel


2. Apply Formula to Calculate Discount Percentage in Excel

Sometimes you might find that you are provided the discount price in excel. At that time you have to calculate the discount percentage using two variables selling price and discount percentage.

Suppose we have a dataset where we have Selling Price & Discount Price of different products. Now we will calculate the Discount Percentage.

2.1 Divide by Original Price

This method is the simplest method to calculate the discount percentage. You just have to calculate the difference in price and then divide it by the selling price.

Steps:

  • Choose a cell. Here I have selected cell (F5) to apply the formula.
  • Write the formula down in the selected cell-
=(D5-E5)/D5

Calculate Discount Percentage in Excel

  • Click Enter and drag down the “fill handle” to fill the cells with discount percentage.

  • Finally we got our discount percentage in our desired column.

Calculate Discount Percentage in Excel

2.2 Subtract from One

Let’s calculate the discount percentage with a subtracting formula.

Steps:

  • Choose a cell (F5) to write the formula.
  • Apply the formula-
=1-(E5/D5)

Calculate Discount Percentage in Excel

  • Hit the Enter.
  • Pull the “fill handle” down to fill.

  • Thus we can calculate the discount easily in excel.

Calculate Discount Percentage in Excel


Things to Remember

  • While applying formulas don’t forget to use brackets between the formulas. Otherwise, you won’t get the correct output you are looking for.

Conclusion

In this article, I have tried to cover all the simple methods to calculate discount in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo