How to Subtract a Percentage from a Price in Excel (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


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


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.

how to subtract a percentage from a price

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.

how to subtract a percentage from a price

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

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


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


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo