Ravi Sir's Cards › Excel
Shopping Offer Comparison in Excel (card 2 of 2)
Revision card 2 for Shopping Offer Comparison in Excel: Rank: =RANK(G6,$G$6:$G$10,1) gives 4; Second pack at half price: =$B$3*B10*(1-D10)-E10 gives ₹375.00; Best offer: =INDEX(A6:A10,MATCH(MIN(G6:G10),G6:G10,0)) gives Buy 2 get 1 free.
Read card text
What this card says
2 for Shopping Offer Comparison in Excel: Rank: =RANK(G6,$G$6:$G$10,1) gives 4
Second pack at half price: =$B$3*B10*(1-D10)-E10 gives ₹375.00
Best offer: =INDEX(A6:A10,MATCH(MIN(G6:G10),G6:G10,0)) gives Buy 2 get 1 free.
Learn this in the lesson: Shopping Offer Comparison in Excel: Buy 2 Get 1 Free vs % Off vs Flat ₹ Off