How to subtract 20 percent from a price

Calculate: tips, sales price, percent off, discounted price, price with sales tax, etc.

(Enter values into the blue boxes. Answer will appear in the black box.)
Answers are rounded to 7 decimal places.

Examples

Example 1:
Your restaurant bill is $56.47 and you want to leave a 15% tip.
How much is the tip?
How much is the total amount of the bill with the tip?

Example 2:
You have a 25 percent off coupon. The item you want to buy is $129.99
How much money will the coupon save you?
What is the cost of the item after using the coupon?

The amount you will save is: 25% of $129.99 = $32.50 (which will be displayed under the % of Start Value box in the calculator)
The cost of the item after using the coupon is: $129.99 - $32.50 = $97.49
Click to show this example in the calculator above.

Example 3:
The sales tax rate is 8%
An item costs $49.99
What is the amount of sales tax?
What is the total cost of the item with sales tax.

The amount of sales tax is: 8% of $49.99 = $4.00 (which will be displayed under the % of Start Value box in the calculator)
The total cost with tax is: $49.99 + $4.00 = $53.99
Click to show this example in the calculator above.

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

Related Articles

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.

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!

How do you take 20% off a price?

How do you calculate 20% of a number?