| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i set up a spreadsheet to calculate fuel milage
i want to make a spreadsheet that take my total km and liters and converts
them to gallons and miles then calculates mpg |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i set up a spreadsheet to calculate fuel milage
1 liter = 0.264172051 US gallon
1 miles = 1.609344 kilometers A = Kilometers B = liters =(A1*1.609344*0.264172051)/B1 OK, I've probably overdone it with the significant digits, but there's your equation. "Dmds" wrote in message ... i want to make a spreadsheet that take my total km and liters and converts them to gallons and miles then calculates mpg |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i set up a spreadsheet to calculate fuel milage
1 Imperial gallons = 4.54609188 litres so 0.219969 if you want imp mpg
-- paul remove nospam for email addy! "Barb Reinhardt" wrote: 1 liter = 0.264172051 US gallon 1 miles = 1.609344 kilometers A = Kilometers B = liters =(A1*1.609344*0.264172051)/B1 OK, I've probably overdone it with the significant digits, but there's your equation. "Dmds" wrote in message ... i want to make a spreadsheet that take my total km and liters and converts them to gallons and miles then calculates mpg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Has anyone built an Excel spreadsheet to calculate churn? | Excel Discussion (Misc queries) | |||
| Calculate message | Excel Discussion (Misc queries) | |||
| Setting up a spreadsheet to calculate apportionment of service cha | Excel Worksheet Functions | |||
| #REF error on linked spreadsheet | Links and Linking in Excel | |||
| How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) | |||
Linear Mode
