**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.

**Table of Contents**hide

## 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.

#### 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)`

- 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.

#### 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)`

- 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**.

**Read More:** **How to Calculate Discount Rate in Excel (3 Quick Methods)**

### 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`

- 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.

#### 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)`

- Hit the
**Enter.** - Pull the “
**fill****handle**” down to fill.

- Thus we can calculate the discount easily in excel.

**Read More:** **Formula to 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.

**Related Articles**

**How to Calculate 10 Percent Discount in Excel (With Easy Steps)****How to Calculate Discount Factor in Excel (6 Common Ways)****Calculate Discount Rate for NPV in Excel (3 Useful Methods)****How to Use IF Function in Excel for Discounts (4 Suitable Examples)****How to Calculate Multiple Discounts in Excel (4 Easy Methods)**