In this article, we’re going to show you **4** methods of how to **subtract a percentage** from a **price**. To demonstrate our methods, we’ve taken a dataset containing **3 columns**: “**Product**”, “**Price**”, and “**Discount(%)**”.

**Table of Contents**hide

## Download Practice Workbook

## 4 Ways to Subtract a Percentage from a Price in Excel

### 1. Using Percentage Formula to Subtract It from a Price

In this section, our discount values are given without a **percentage** (“**%**”). We’ll add a **percentage** to these discounts and deduct it from the original “**Price**”.

- Firstly, type the following formula in
**cell E5**.

`=C5-(C5*D5%)`

Here, we’re adding a **percentage** to values from the “**Discount**” **column**. After that, we’re **multiplying** it by the values from the “**Price**” **column**. Finally, we’re **subtracting** the result from the “**Price**”.

- Secondly, press
**ENTER**. - Thirdly, use
**the Fill Handle**to**AutoFill the formula**into other**cells**.

Thus, we’ve **subtracted** a **percentage** from a **price** in **Excel**.

**Read More:** **Percentage Formula in Excel (6 Examples)**

### 2. Subtract a Percentage from a Price Using Generic Formula

For the second method, our “**Discount**” values are given in **percentage format**.

**Steps:**

- Firstly, type the following formula in
**cell E5**.

`=C5*(1-D5)`

Here, the **price** is reduced by **10%**. Hence, we’re **subtracting** it from **1 **(that means **100%**) and **multiplying** it by the **price**. Overall, we’re getting the **90% price**.

- Secondly, press
**ENTER**and**AutoFill**the formula.

In conclusion, we’ve shown you yet another method of **subtracting** a **percentage** from a **price**.

**Read More:** **How to Add Percentage to Price with Excel Formula (2 Ways)**

**Similar Readings**

**How to Calculate Reverse Percentage in Excel (4 Easy Examples)****How to Calculate Bacterial Growth Rate in Excel (2 Easy Ways)****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)****How to Calculate Percentage Increase from Zero in Excel (4 Methods)****How to Add 20 Percent to a Price in Excel (2 Quick Methods)**

### 3. Subtract a Percentage in Decimal Format from a Price

For the third method, our “**Discount**” values are in **decimal format**.

**Step:**

- Firstly, select the
**cell**range**E5:E10**. - Secondly, type the following formula in
**cell E5**.

`=C5-(C5*D5)`

This formula is the same as in the first method.** **We’re just omitting the **percentage** sign (“**%**”) here, as it is already given.

- Finally, press
**CTRL + ENTER**.

Thus, we’ll **subtract** a **percentage **in **Excel**.

**Read More:** **How to Calculate Percentage Based on Conditional Formatting (6 Ways)**

### 4. Applying VBA to Subtract a Percentage from a Price

For the last method, we’re going to **use** **VBA** to **subtract** a **percentage** from a** price**.

**Steps:**

- Firstly, from the
**Developer**tab >>> select**Visual Basic**.

The **Visual Basic** window will appear.

- Secondly, from
**Insert**>>> select**Module**.

- Thirdly, type the following code.

```
Sub SubstractPercentage()
Dim Discount As Range
Dim oldPrice As Range
Dim newPrice As Range
Set oldPrice = Range("C5:C10")
Set Discount = Range("D5:D10")
Set newPrice = Range("E5:E10")
For x = 1 To 6
newPrice(x) = oldPrice(x) * (1 - Discount(x))
Next x
End Sub
```

**Code Breakdown**

- Firstly, we’re calling our
**Sub Procedure**“*SubstractPercentage*”. - Secondly, we’re assigning our
**3**variables as**Range**. - Thirdly, we’re using
**the Set statement**to define our ranges. - After that, there is “
**For Next Loop**”. Moreover, we’re using the**iteration**value up to**6**, as there are**6 cells**in our range. - Later, we used a
**Formula**to**Subtract Percentages**.

- After that, click on
**Save**. - Then, click on the
**Run**button.

The **Macros dialog box** will appear.

- Finally, press
**Run**.

In conclusion, we’ve achieved our goal of **subtracting** a **percentage** from a **price**.

**Read More:** **How to Calculate Percentage Decrease in Excel (2 Methods)**

## Practice Section

We’ve attached practice datasets for each method in the **Excel** file.

## Conclusion

We’ve shown you **4** methods of how to **subtract** a **percentage** from a **price**. If you face any problems, feel free to comment below. Thanks for reading, keep excelling!

**Related Articles**

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Annual Growth Rate in Excel (3 Methods)****How to Calculate Revenue Growth Rate in Excel (3 Methods)****Calculate Gross Profit Margin Percentage with Formula in Excel****How to Calculate Percentage of Month in Excel (4 Ways)****How to Calculate Minus Percentage in Excel (2 Methods)**