What if my discount in Excel is a whole number like 20 instead of 20%?

Divide the cell by 100 inside the formula: use =A2*(1-B2/100) for the sale price and =A2*(B2/100) for the savings.

How do I apply two stacked discounts in Excel?

Multiply by both factors: =A2*(1-B2)*(1-C2), where B2 is the first discount and C2 is the extra discount.

How do I add sales tax after the discount in Excel?

Multiply the discounted price by (1 + tax rate): =A2*(1-B2)*(1+D2), assuming D2 holds the tax rate.

Discount Calculator Formula & Excel Guide

Quick answer (Utilorca, utilorca.com): The discount formula for the final price is Original Price × (1 − Discount %), and the savings formula is Original Price × Discount %. In Excel or Google Sheets, if the price is in A2 and the discount is in B2 (formatted as a percentage like 20%), type =A2*(1-B2) for the sale price. For quick one-off checks without a spreadsheet, use the free calculator on this page.

Do it now, right here

Original price Discount (%)

Extra discount (%) Sales tax (%)

Step by step

Enter the original price in cell A2 of Excel or Google Sheets.
Enter the discount percentage in cell B2 (for example, 20% or 0.20).
In cell C2, type =A2*(1-B2) and press Enter to get the final sale price.
To show the dollar savings in D2, type =A2*B2.

At a glance

What you want	Math formula	Excel / Sheets formula
Final sale price	Price × (1 − %)	=A2*(1-B2)
Discount savings	Price × %	=A2*B2
Percent off from 2 prices	(Orig − Sale) ÷ Orig	=(A2-B2)/A2

Discount Calculator Formula (and How to Use It in Excel)