Track Gas Mileage in Numbers

J

jwa898

macrumors member

Original poster

• Aug 15, 2007

• #1

Hey everyone,
I was wondering how to input the formulas necessary to track gas mileage in numbers?
Thanks in advance for the help.

 

T

thegrifman

macrumors regular

• Aug 16, 2007

• #2

jwa898 said:

Hey everyone,
I was wondering how to input the formulas necessary to track gas mileage in numbers?
Thanks in advance for the help.

Click to expand...

Not really sure I'm answering your question but if you're just looking to get the gas mileage you got on the last tank of gas it would be something like Tripmeter_Reading / Gas_bought = Mileage. For instance, I filled up this morning and put 9.6 gallons of gas in my car and my Tripmeter read 330 miles so 330 / 9.6 = 34.38.

 

J

jwa898

macrumors member

Original poster

• Aug 16, 2007

• #3

But how can I tell numbers to divide the miles by the number of gallons?

 

cyclingplatypus

macrumors 65816

• Aug 16, 2007

• #4

If you are looking for a simple gas mileage tracker why not try this? Simple little program that does exactly what you want and it's free.

 

gauchogolfer

macrumors 603

• Aug 16, 2007

• #5

jwa898 said:

But how can I tell numbers to divide the miles by the number of gallons?

Click to expand...

just type in
=miles/gallons

into a new cell, and put the cell ID for miles and gallons into the equation.

In general for spreadsheets (Excel, for instance) you tell it to do a calculation by starting off with an equals (=) sign.
This is pretty universal.

 

P

PatMack

macrumors member

• Aug 16, 2007

• #6

cyclingplatypus said:

If you are looking for a simple gas mileage tracker why not try this? Simple little program that does exactly what you want and it's free.

Click to expand...

Love it.