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(%)”.
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”.
- 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.
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.
Read More: How to Add Percentage to Price with Excel Formula (2 Ways)
Similar Readings
- How to Calculate Reverse Percentage in Excel (4 Easy Examples)
- How to Calculate Bacterial Growth Rate in Excel (2 Easy Ways)
- Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)
- How to Calculate Percentage Increase from Zero in Excel (4 Methods)
- How to Add 20 Percent to a Price in Excel (2 Quick Methods)
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.
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.
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.
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
- Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)
- How to Calculate Annual Growth Rate in Excel (3 Methods)
- How to Calculate Revenue Growth Rate in Excel (3 Methods)
- Calculate Gross Profit Margin Percentage with Formula in Excel
- How to Calculate Percentage of Month in Excel (4 Ways)
- How to Calculate Minus Percentage in Excel (2 Methods)