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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billymick - 29 Aug 2007 09:34 GMT

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

Reply to this Message

Mike H - 29 Aug 2007 10:02 GMT

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

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

Reply to this Message

Gord Dibben - 30 Aug 2007 16:48 GMT

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

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

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

Gord Dibben MS Excel MVP

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

Reply to this Message