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.
Add tax
=A2*(1+B2)Multiply by 1 + the tax rate.
Divide by (1 − discount): =A2/(1-B2).
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.