How do I setup a worksheet to track gas mileage/gallon?

[Guest]

I want to keep track of how much gas I'm using per gallon in my truck.

 

[Guest]

Hi Billymick,

You can get as complicated as you want doing this but in the simplest terms
it can be done with a couple of columns of data:-

start miles end miles Distance Fuel added mpg
1000 3000 2000 100 20

Distance is a formula = B2-A2
mpg is also a formula =C2/D2
Start miles is taken from you odometer
Fuel added is what you put in at the pump

So the next time you fuel up, start miles would be 3000 and end miles would
be you odometer reading and you would drag the formula down.

Mike

 

[Gord Dibben]

Miles in A1..................678

Gallons in B1................32

=A1/B1 in C1................21.1875 mpg


Gord Dibben MS Excel MVP