Calculate a discounted price
| Cell | Meaning | Example value |
|---|---|---|
| A2 | Original price | $30 |
| B2 | Discount | 40% |
Formula
=A2*(1-B2)Expected result: $18
Enter B2 as 40% or 0.40, then format the result as currency.
Discount Calculator
Enter an original price and percent off to find both the discount savings and final sale price before tax.
Discount Calculator
%
off$
= $
How it works
Formula and steps
The formula shows how the discount calculator turns your inputs into the result. Use it to check the calculation, then follow the example steps to see each part of the math.
Formula & steps
Discount price formula
F = P - (P x d / 100)
Use this to find the final price after a percentage discount.
F= Final price after discountP= Original price before discountd= Discount percentage- 1$120 x 25 / 100 = $30 savings
- 2$120 - $30 = $90
- 3Final price = $90
Worked examples
Example 1
What is 40% off $30?
- 1
Find the savings
$30 x 0.40 = $12
- 2
Subtract savings from the original price
$30 - $12 = $18
- 3
Answer
Final price = $18; savings = $12
Example 2
What is 25% off $120?
- 1
Find the savings
$120 x 0.25 = $30
- 2
Subtract savings from the original price
$120 - $30 = $90
- 3
Answer
Final price = $90; savings = $30
Spreadsheet formulas
Calculate in Excel or Google Sheets
Enter the example values in the listed cells, then paste the formula into another cell. Excel and Google Sheets use the same formulas shown here.
Common uses
- Shopping discounts and percent-off sales
- Sale pricing
- Coupon checks
- Comparing promotions
Common mistakes
- Applying sales tax before checking whether the discount is pre-tax or post-tax.
- Confusing the savings amount with the final sale price.
- Adding stacked discount rates together. Successive discounts apply one after another, so 20% off followed by 10% off is 28% off overall, not 30%.
Discount guide
How to calculate a discount and sale price
A percent-off discount produces two useful numbers: the amount saved and the final price paid before taxes, fees, or shipping.
Find the discount amount
Convert the percent off to a decimal and multiply by the original price. For 40% off $30, the savings are 0.40 x $30 = $12.
Find the final sale price
Subtract the savings from the original price. In the same example, $30 - $12 = $18. You can also multiply the original price by 1 minus the discount decimal.
Calculate other percentage amounts →Add sales tax separately
This discount result is before tax. Sales tax rules commonly apply to the discounted taxable price, but the applicable rate and rules depend on the location and purchase.
Estimate sales tax after discount →FAQ
Multiply the original price by 25 / 100 to find the savings, then subtract the savings from the original price.
No. It calculates the discounted price before any taxes, fees, or shipping.
The savings are $12 and the final price is $18 before tax. Multiply $30 by 0.40, then subtract $12 from $30.
No. The discount amount is how much you save. The sale price is the original price minus that savings amount.
More Percentage calculators
Browse other categories