To compare prices across stores in a spreadsheet, give each store a row and use six columns: store, price, delivery, coupon or discount, return terms and final cost. Final cost is price plus delivery minus any discount you are definitely eligible for. A MIN formula then points to the lowest, and the return column stops you choosing a cheaper deal with worse terms.
Which columns do you need?
- A: Store, the seller's name or the shop you would visit.
- B: Price, the listed price for the same model and variant.
- C: Delivery, the fee for your pin code, or 0 for a shop pick-up.
- D: Discount, only offers you can really use today, such as a bank offer on a card you own.
- E: Return terms, written in a few words, such as 7 days, seller pays pick-up.
- F: Final cost, which is =B2+C2-D2.
Be strict about D. A new-user coupon that you cannot use is not a discount. Leave it at 0 and add a note rather than letting hope shrink the number.
What does it look like for a made-up mixer grinder?
Say you have decided on one model and found it at three places. All figures are invented.
| Store | Price | Delivery | Discount | Return terms | Final cost |
|---|---|---|---|---|---|
| Online store A | ₹3,299 | ₹0 | ₹200 | 7 days, pick-up arranged | ₹3,099 |
| Online store B | ₹3,149 | ₹99 | ₹0 | 10 days, you ship it back | ₹3,248 |
| Local shop | ₹3,200 | ₹0 | ₹0 | Exchange only, 7 days | ₹3,200 |
Check the arithmetic. Store A: ₹3,299 + ₹0 − ₹200 = ₹3,099. Store B: ₹3,149 + ₹99 − ₹0 = ₹3,248. The shop: ₹3,200. Store B had the lowest sticker price, ₹3,149, but ends up the most expensive once delivery is added, while Store A, which looked dearest, is the cheapest.
How does the sheet find the lowest for you?
In a cell below the table, type =MIN($F$2:$F$4). It returns ₹3,099. To show the winner's name, type =INDEX($A$2:$A$4, MATCH(MIN($F$2:$F$4), $F$2:$F$4, 0)), which looks up the position of the lowest final cost and returns the store beside it. To see how much the winner saves over the next best, use =SMALL($F$2:$F$4, 2)-MIN($F$2:$F$4), which gives ₹3,200 − ₹3,099 = ₹101.
To colour the lowest row automatically, add a conditional formatting rule with a custom formula, applied to $A$2:$F$4: =$F2=MIN($F$2:$F$4). Pick a green fill. This works in both Excel and Google Sheets.
Is the cheapest always the right choice?
No. A saving of ₹101 is small compared with what a bad return can cost. If the model might need to be tried at home, returns matter more than rupees. If it is a heavy appliance, who carries it back, and does the seller collect it, can matter more than a ₹101 difference.
How do you keep the comparison honest?
- Same model number and colour in every row. A similar-looking model is not the same.
- Same date. Prices move, so fill all rows within an hour.
- Same payment method assumption. If a discount needs a specific card, say so in a note.
- Count the cost of getting it there: a petrol trip to the shop is part of the shop's real price.
What do you do after buying?
Record the final amount you paid, not the listed price. If you use SpendixAI, an imported statement carries the debit and you can attach the receipt to that transaction, so the invoice, the price and the date live together if you need to claim warranty later. Then save the sheet as a record of what you compared, and delete the rows next year.
A short checklist
- Three rows at least, same model.
- Final cost by formula, not by mental sums.
- Return terms noted for each row.
- One cell naming the winner.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


