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

Get FREE Advanced Excel Exercises with Solutions!

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

how to subtract a percentage from a price


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

Steps:

  • Firstly, type the following formula in cell E5.
=C5-(C5*D5%)

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

how to subtract a percentage from a price

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

how to subtract a percentage from a price

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.

how to subtract a percentage from a price

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


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.

how to subtract a percentage from a price

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

how to subtract a percentage from a price

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

how to subtract a percentage from a price

The Macros dialog box will appear.

  • Finally, press Run.

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

how to subtract 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

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo