Reduce a price by a percentage to get the discounted amount.
Copy this formula
=A2*(1-B2)Multiplying by (1 − discount) leaves the portion the customer still pays — a 20% discount means paying 80%. To add tax instead, multiply by (1 + rate).
=50*(1-0.2)→4020% off $50 is $40.
=200*(1-15%)→17015% off 200 is 170.
=150*20%→30The discount amount on its own: 20% of 150.
Add tax
=A2*(1+B2)Multiply by 1 + the tax rate.
Divide by (1 − discount): =A2/(1-B2).
Divide the saving by the original price: =(A2-B2)/A2, where A2 is the original price and B2 the sale price. Format the cell as a percentage.
Multiply the factors: =A2*(1-B2)*(1-C2). Two 10% discounts give 19% off in total, not 20%.
Type 20% or 0.2. If the cell holds the plain number 20, use =A2*(1-B2/100) instead.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.