G Guest Jan 15, 2006 #1 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
B Barb Reinhardt Jan 15, 2006 #2 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.
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.
