How to Subtract a Percentage from a Price in Excel (4 Methods)

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(%)”.

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

Steps:

• Firstly, type the following formula in cell E5.

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.

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.

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

• 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