Discount Calculator
Enter the original price and discount percentage to see the final sale price and how much you save. You can also work backwards from old vs new price.
Tip: discount % is a number like 15 for 15%.
Have the old and new prices? Find the discount %
Copyable Excel & Google Sheets Formulas
Final price from price (A2) and discount % (B2). Example: =120*(1-15/100) → 102.
Savings amount from price (A2) and discount % (B2). Example: =120*(15/100) → 18.
Discount % from old (A2) and new price (B2). Example: =(120-102)/120*100 → 15%.
Cell convention: A2 = price, B2 = discount % (or new price in the last example).
FAQs
How do I calculate a sale price with tax included?
Apply the discount to the pre-tax price, then add tax to the discounted amount. The calculator can show both before- and after-tax totals.
What’s the difference between a percentage off and a fixed amount off?
Percentage off reduces price by a set rate (e.g., 20%). A fixed amount off subtracts a specific dollar value (e.g., $15 off).
How do stacked discounts work?
They apply one after another, not all at once. For example, 20% off followed by another 10% off equals a total discount of 28%, not 30%.