# How to Calculate Discount in Excel (2 Easy Methods)

## Method 1 – Creating an Excel Formula to Calculate a Discount Price

Suppose we have a dataset of a Mobile selling shop with their product Selling Price and discount Percentage for various products. Using a formula will calculate the Discount Price in the workbook.

### Case 1.1 – Using the Subtraction Formula

Steps:

• Select a cell. Here we have selected cell (F5) to apply the formula.
• Insert the following formula:
`=D5-(D5*E5)`

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

### Case 1.2 – Applying a Multiplication Formula

Steps:

• Choose a cell (F5) to apply the formula.
• Insert the following formula:
`=D5*(1-E5)`

• Hit Enter.
• Drag the fill handle down to get the full results.

• Here’s the final result.

## Method 2 – Applying a Formula to Calculate a Discount Percentage in Excel

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

### Case 2.1 – Dividing by the Original Price

Steps:

• Choose a cell. Here we have selected cell (F5) to apply the formula.
• Copy the following formula into the cell:
`=(D5-E5)/D5`

• Hit Enter and drag down the fill handle to fill the rest of the cells with the discount percentage.

• We got the discount percentage in our desired column.

### Case 2.2 – Subtracting from One

Steps:

• Choose a cell (F5).
• Apply the following formula:
`=1-(E5/D5)`

• This will calculate the discount easily in Excel.

## Excel Discount Formula: Knowledge Hub

<< Go Back to Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF