Ravi Sir's Cards › Excel
Shopping Offer Comparison in Excel (card 1 of 2)
Revision card 1 for Shopping Offer Comparison in Excel: Price per pack: =F7/C7 gives ₹166.67; You pay: =$B$3*B6*(1-D6)-E6 gives ₹200.00; Real discount: =1-G7/$B$3 gives 33.3%.
Read card text
What this card says
1 for Shopping Offer Comparison in Excel: Price per pack: =F7/C7 gives ₹166.67
You pay: =$B$3*B6*(1-D6)-E6 gives ₹200.00
Real discount: =1-G7/$B$3 gives 33.3%.
Learn this in the lesson: Shopping Offer Comparison in Excel: Buy 2 Get 1 Free vs % Off vs Flat ₹ Off