Discount Calculator
Calculate the sale price, the amount you save, and the original price from any discount.
Last updated:
Calculation Examples
📋Steps to Calculate
-
Enter the original price of the product.
-
Enter the discount percentage or fixed discount amount.
-
Click "Calculate" to see the final sale price, amount saved, and effective discount percentage.
Mistakes to Avoid ⚠️
- Adding consecutive discounts. 20% followed by 10% saves 28%, not 30%, because the second percentage applies to the reduced price.
- Comparing fixed and percentage offers without a price. A $15 coupon is 25% off a $60 item and 7.5% off a $200 item.
- Adding the discount back to the sale price to find the original. A $75 sale price after 25% off does not return to $93.75, it returns to $100, because $75 is 75% of the original.
Practical Applications📊
Check a sale price: an $80 item at 25% off costs $60, which saves $20.
Test a stacked offer: 40% off plus 10% off is 46% off in total, not 50%.
Compare coupons: $15 off is 25% on a $60 item but only 7.5% on a $200 item.
Price a markdown: if an item costs you $70 and sells for $100 (a 30% margin), 20% off leaves $10 profit instead of $30, so you need 3 times the unit sales to break even.
Questions and Answers
How do I calculate a discount in Microsoft Excel?
Put the original price in A1 and the discount in B1 as a plain number such as 25, then use =A1*(1-B1/100) for the sale price and =A1-C1 for the saving, with the sale price in C1. For stacked discounts, chain the factors: =A1*(1-B1/100)*(1-C1/100). For the original price from a sale price in A1, use =A1/(1-B1/100). If B1 is formatted as a percentage, such as 25%, drop the /100.
How do retailers calculate markdowns for clearance pricing?
Retailers usually express markdowns as a percentage of the original price, such as 25%, then 40%, then 60% off if the item does not sell. Each step is measured from the original price unless the store says "extra X% off the sale price". The difference is large: 25% off followed by an extra 40% off the sale price is \(1 - 0.75 \times 0.60 = 55\%\) in total, while a 40% markdown of the original price is simply 40%. Check which base the second step uses.
How do stacked or sequential discounts work?
Each stacked discount applies to the price left after the previous one. A 20% discount takes $100 to $80, and an extra 10% takes $80 to $72, so the total saving is $28, or 28%. For two discounts \(d_1\) and \(d_2\) as decimals, the effective discount is \(1 - (1 - d_1)(1 - d_2)\). For any number of steps, \(\text{Final price} = P \times (1 - d_1)(1 - d_2) \cdots (1 - d_n)\). Example: 40% then 10% gives \(1 - 0.6 \times 0.9 = 46\%\).
How do you calculate a discount percentage manually?
Divide the amount saved by the original price and multiply by 100: \(\text{Discount \%} = \dfrac{\text{Original} - \text{Sale}}{\text{Original}} \times 100\). Example: an $80 item selling for $60 saves $20, and \(\dfrac{20}{80} \times 100 = 25\%\). Use this to compare offers worded differently, such as "$20 off" and "25% off", at the price you will actually pay.
How do you find the original price after a discount?
Divide the sale price by 1 minus the discount rate as a decimal. If an item sells for $75 after 25% off, the original price is $75 ÷ 0.75 = $100. Adding 25% to $75 gives $93.75, which is wrong because the 25% was taken from the original price and not from the sale price. Use this method when a store shows only the sale price and the percent off, or to test whether a stated original price matches the claimed discount.
What is a discount calculator and how does it work?
A discount calculator finds the sale price and the amount saved after a percentage or fixed reduction. For a percentage, use \(\text{Sale price} = \text{Original} \times (1 - d/100)\). For a fixed coupon, subtract it from the price. Reversed, \(\text{Original} = \text{Sale price} \div (1 - d/100)\). Example: 25% off $80 is $60, and $60 ÷ 0.75 returns $80. The reverse direction is useful for checking whether a stated original price is genuine or inflated.
What is the difference between a percentage discount and a fixed discount?
A percentage discount scales with the price, while a fixed discount is the same amount at any price. A 20% discount saves $10 on a $50 item and $40 on a $200 item. A $15 coupon is 30% off a $50 item but 7.5% off a $200 item. To compare, convert both to dollars saved at your price. Fixed coupons favor smaller purchases, and percentage discounts favor larger ones.
Disclaimer: This calculator is designed to provide helpful estimates for informational purposes. While we strive for accuracy, financial (or medical) results can vary based on local laws and individual circumstances. We recommend consulting with a professional advisor for critical decisions.