Ravi Sir's Cards › Excel
Transport and Fleet Management System in Excel (card 2 of 2)
Revision card 2 for Transport and Fleet Management System in Excel: Km from odometer: =F5-E5 gives 373; Km per litre: =IFERROR(G5/H5,0) gives 4.44; Trip ID: ="T-"&TEXT(ROW()-4,"000") gives T-001. Includes an example data table.
Read card text
What this card says
2 for Transport and Fleet Management System in Excel: Km from odometer: =F5-E5 gives 373
Km per litre: =IFERROR(G5/H5,0) gives 4.44
Trip ID: ="T-"&TEXT(ROW()-4,"000") gives T-001. Includes an
Example
data table
Learn this in the lesson: Transport and Fleet Management System in Excel: Trips, Km per Litre, Cost per Km, Document Expiry and Profit