Ravi Sir's Cards › Excel
Own Car vs Cab Cost in Excel (card 2 of 2)
Revision card 2 for Own Car vs Cab Cost in Excel: Car cost per km: =B15/B3 gives ₹32.31; Cab cost per month: =B3*E6+E7*E8 gives ₹17,200; Cheaper this month: =IF(E9<B15,"Cab","Own car") gives Cab.
Read card text
What this card says
2 for Own Car vs Cab Cost in Excel: Car cost per km: =B15/B3 gives ₹32.31
Cab cost per month: =B3*E6+E7*E8 gives ₹17,200
Cheaper this month: =IF(E9<B15,"Cab","Own car") gives Cab.
Learn this in the lesson: Own Car vs Cab Cost in Excel: Monthly Cost per Km and Break-even Distance