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

## 1. Using Excel Percentage Formula to Subtract 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.

## 2. Subtracting a Percentage from a Price Using Excel 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**auto-fill**the formula.

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

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

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

**Download Practice Workbook**

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

- Excel Formula to Add Percentage Markup
- How to Do Sum of Percentages in Excel
- How to Add Percentage to Price with Excel Formula
- How to Add 20 Percent to a Price in Excel
- How to Subtract a Percentage in Excel
- How to Subtract 10 Percent in Excel

- How to Use Excel Formula to Calculate Percentage of Grand Total
- How to Add 10 Percent to a Number in Excel
- How to Add 15 Percent to a Price in Excel

**<<Go Back to Sum or Subtract in Excel | Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel**