Price after a percentage discount is =Price*(1-Discount). Discount percentage from two prices is =(Original-Sale)/Original. For ₹8,999 at 20% off, the sale price is ₹7,199.20. Stacked offers multiply rather than add: 20% off and then 10% off is not 30% off, which is why a small sheet beats mental arithmetic during a sale.
Set up the sheet in two minutes
- A1 Shop name, B1 Offer name, then one row per shop under the headings.
- B3 List price, C3 First discount (as a percentage), D3 Second discount (as a percentage), E3 Cap in rupees.
- F3 Price after first discount: =B3*(1-C3).
- G3 Second saving: =MIN(F3*D3, E3). If there is no cap, leave E3 empty; MIN ignores an empty cell.
- H3 Final price: =F3-G3, and I3 Total discount: =(B3-H3)/B3.
The three formulas you need
- Price after discount: =B2*(1-C2), with price in B2 and the discount as a percentage in C2.
- Discount percentage: =(B2-C2)/B2, with original price in B2 and sale price in C2, formatted as a percentage.
- Amount saved: =B2-C2 for rupees, which is often a better comparison than the percentage.
How do stacked discounts work?
When a second offer applies after the first, it applies to the price that is left. The formula is =Price*(1-D1)*(1-D2). If the second offer is capped, such as a card offer with a maximum saving, use MIN to apply the cap: =Stage1-MIN(Stage1*D2, Cap).
Example with made-up offers. Shop A lists a product at ₹8,999 with 20% off, then a card offer of 10% extra, capped at ₹750. Stage 1 is ₹8,999.00 x 0.80 = ₹7,199.20. The card offer is 10% of that, ₹719.92, which is under the cap, so the final price is ₹6,479.28. The total discount is 28.0%, not 30%.
A two-shop comparison table
Shop B lists the same product at ₹6,799 with a coupon of ₹300 off. Put each shop in a row with columns for list price, first discount, second offer and final price:
| Step | Shop A | Shop B |
|---|---|---|
| List price | ₹8,999.00 | ₹6,799.00 |
| First step | 20% off = ₹7,199.20 | No percentage off |
| Second step | Card offer 10%, capped at ₹750: minus ₹719.92 | Coupon: minus ₹300 |
| Final price | ₹6,479.28 | ₹6,499.00 |
| Total saving versus list | ₹2,519.72 | ₹300.00 |
Shop A comes out ₹19.72 cheaper on these invented numbers. Shop B has the lower list price and still loses, which is the sort of thing that is hard to see in your head.
Is a flat coupon better than a percentage off?
It depends on the price. A flat ₹300 coupon is 3% of a ₹10,000 item but 30% of a ₹1,000 item; a 10% offer is ₹1,000 on the first and ₹100 on the second. Put both versions in the sheet and compare the rupees saved rather than the labels. Where an offer has a cap, the saving stops growing after a certain price, so on a big purchase a flat coupon without a cap can beat a capped percentage.
How do I find the discount percentage from two prices?
In Shop A's case, =(8999-6479.28)/8999 gives 28.0%. Format the cell as a percentage; otherwise you will see 0.28 instead. If you want the percentage rounded for display, use =ROUND((B2-C2)/B2, 3) and format to one decimal.
What to check before buying
- Is the card offer valid on this card and this product, and is there a maximum saving?
- Does the coupon apply before or after the other discount?
- Is the price shown inclusive of tax, delivery and any fee at payment?
- Is the return window the same at both shops?
After the sale, record what you actually paid. Importing the card statement into SpendixAI and reviewing the row shows whether the price charged matched the one in your sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

