How to calculate a discount in Excel and Google Sheets

Excel & Google Sheets

=A2-(A2*B2)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

=A2-(A2*B2)→180

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1Create two columns: Original Price (A) and Discount Rate as a decimal (B, e.g., 0.20 for 20%).
2In the Discount Amount column, enter =A2*B2 to compute how much is taken off.
3In the Final Price column, enter =A2-(A2*B2) or equivalently =A2*(1-B2) to get the price after the discount.

Use =A2*(1-B2) as the shorter equivalent to =A2-A2*B2. Both are correct; the shorter form is easier to read.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Divide the discounted price by (1 - discount rate): =A2/(1-B2).

Multiply sequentially: =A2*(1-B2)*(1-C2) where B2 and C2 are the two discount rates.

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026