Forum Discussion
Excel Miles driven using odemeter reading
I'm trying to set up a spreadsheet to track the miles driven and the average miles per gallon. I am not sure what formula to use to calculate the miles driven using the odometer readings. The readi...
If the first odometer reading is in B1 and the last one in V1, the number of miles driven is
=V1-B1
More generally, if the last reading isn't necessarily in V1, you can use
=MAX(1:1)-B1