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

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

2. Subtract a Percentage from a Price Using Generic Formula

3. Subtract a Percentage in Decimal Format from a Price

4. Applying VBA to Subtract a Percentage from a Price

Practice Section

Conclusion

Download Practice Workbook

Subtract Percentage.xlsm

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

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.

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.

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!