| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Gas Mileage
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Gas Mileage
=(29*15)/24
mpg multiplied by tank size divided by miles per round trip. Gives you about 18 trips. -- ----- Thank you, Liz "Patsy" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Gas Mileage
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 "Patsy" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Gas Mileage
Thank you!
"Ron Coderre" wrote: 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 "Patsy" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Gas Mileage
Liz, thank you!
"Liz Steffen" wrote: =(29*15)/24 mpg multiplied by tank size divided by miles per round trip. Gives you about 18 trips. -- ----- Thank you, Liz "Patsy" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for form to track mileage of trucking company vehicles. | Excel Discussion (Misc queries) | |||
| roundtrip mileage with one name entered in A1 | New Users to Excel | |||
| Mileage calculator in EXCEL | Excel Worksheet Functions | |||
| Mileage Calculation | Excel Worksheet Functions | |||
| record business mileage | New Users to Excel | |||
Linear Mode
