i want to make a spreadsheet that take my total km and liters and converts
them to gallons and miles then calculates mpg
i want to make a spreadsheet that take my total km and liters and converts
them to gallons and miles then calculates mpg
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" <[email protected]> wrote in message
news:[email protected]...
>i want to make a spreadsheet that take my total km and liters and converts
> them to gallons and miles then calculates mpg
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" <[email protected]> wrote in message
> news:[email protected]...
> >i want to make a spreadsheet that take my total km and liters and converts
> > them to gallons and miles then calculates mpg
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks