Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# How to Subtract a Percentage from a Price (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(%)”. ## 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”.  Thus, we’ve subtracted a percentage from a price in Excel. 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. In conclusion, we’ve shown you yet another method of subtracting a percentage from a price. ### 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 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. 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!

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