Discount Calculator (Percentage Off)
Find the sale price, savings, or discount percent from a list price, with the Excel and Google Sheets formulas.
Enter the discount as a percent (25 for 25%). Numbers stay in your browser. The default is 25% off 80, which is a sale price of 60 and savings of 20.
Quick answer: with a list price in B2 and a discount in C2 (as 25% or 0.25), Excel and Google Sheets use:
=B2*(1-C2)
=B2*C2The first is the sale price; the second is the amount saved. This is a markdown off a list price, not a markup or a margin on cost.
25% off $80
The sale price is 80 × (1 − 0.25) = 60, and the savings are 80 × 0.25 = 20. In Google Sheets on 12 November 2026, =80*(1-0.25) と =80*0.25 returned those exact figures. Working backwards from the two prices, =1-60/80 returned 0.25, and =60/(1-0.25) recovered the list price of 80.
A second check, 15% off 120, is =120*(1-0.15), which returned 102. If you type 15 in a plain cell and do not divide by 100, the formula treats the discount as 1,500% and the sale price goes negative. Enter 15% または 0.15, or write =B2*(1-C2/100) when C2 holds a whole number.
You only need two of the three numbers
List and discount give the sale price. List and sale give the discount. Sale and discount give the list you started from, which is useful when a ticket shows only the discounted price and the “% off” banner. A 100% discount makes the sale price 0; you cannot divide by (1 − 100%) to recover a list price, and this calculator will not invent one.
Tax, coupons stacked on top of a percent off, and “up to 25% off” ranges are outside this formula. If two discounts apply one after the other, apply the first sale price as the list of the second — 25% then 10% is not 35%.
Questions that come up
What is the Excel or Google Sheets formula for a percentage off?
With the list price in B2 and the discount as 25% or 0.25 in C2, the sale price is =B2*(1-C2) and the savings are =B2*C2. Typing 25 in C2, rather than 25% or 0.25, treats the discount as 2,500%.
How do I find the discount percent from two prices?
Use =1-C2/B2, where B2 is the list price and C2 is the sale price, then format the result as a percentage. 60 off a list of 80 is 25%.
Is this the same as markup or margin?
No. A discount is taken off a list price. Markup and margin describe profit against cost or selling price. Use the markup vs margin calculator for those.