Gas Mileage

P

Patsy

What would be the calculation to find out: How many days can I go on a tank
of gas if: I get 29 mpg / 15 gal tank / 24 miles round trip.
 
L

Liz Steffen

=(29*15)/24

mpg multiplied by tank size divided by miles per round trip. Gives you
about 18 trips.
 
R

Ron Coderre

The tank holds 15 gallons
You get 29 mpg
So the tank holds 435 miles (15 gal per tank*29 mpg)

You travel 24 miles per day
The tank holds 18.125 days (435 miles per tank/24 miles per day)

The entire formula is:
=(15*29)/24
=18.125

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
P

Patsy

Thank you!

Ron Coderre said:
The tank holds 15 gallons
You get 29 mpg
So the tank holds 435 miles (15 gal per tank*29 mpg)

You travel 24 miles per day
The tank holds 18.125 days (435 miles per tank/24 miles per day)

The entire formula is:
=(15*29)/24
=18.125

Does that help?
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel n00b, how to do basic math functions 7
Looking for Mileage / MPG Tracking formula 3
help w indirect and index,match 3
MPG Calculations 8
Collecting data for MPG (miles per gallon) calculation 4
Fueling your car with natural gas from home 0
Fueling your car with natural gas from home 0
How you can save fuel and the environment 0

Top