What formula converts mpg to l/100km
 

How do I program excel to read a "mpg" value in one cell and display its
conversion to "l/100 km" in another cell? (ie. how would the conversion
formula be written)?

What formula converts mpg to l/100km
 

Russ wrote:
How do I program excel to read a "mpg" value in one cell and display its
conversion to "l/100 km" in another cell? (ie. how would the conversion
formula be written)?

You need to know if it is an English gallon or a US gallon (they are
different).
1 mile is 1.6 km
1 English (Imperial) gallon is 4.546 litres
1 US gallon is 3.785 litres
(you can get both of these conversions easily from google)
Let's assume we are working in Imperial units
30 miles per gallons works out at 30*1.6 km/4.546 litre = 10.559
km/litre
Therefore if we take the reciprocal of the last result we get 0.0947
litres/km, so to get it in units of litres/100 km we need to multiply
by 100 to get: 9.47 litres/100 km.
(The calculation using US gallons is obviously just as easy)

Hope this helps
Ian Taylor
http://www.iantaylor.org.uk/

What formula converts mpg to l/100km
 

1 Mi = 1609.344 meters

10 mpg = 10 * 1609.344 meters

10 mgp = (10 * 1609.344)/100 for 100ths km / gallon

A1: 10
B1: =(A1*1609.344)/100

--
Regards,
Tom Ogilvy

"Russ" wrote in message
...
How do I program excel to read a "mpg" value in one cell and display its
conversion to "l/100 km" in another cell? (ie. how would the conversion
formula be written)?

What formula converts mpg to l/100km
 

Thanks, what I meant is the actual code that would be enterred in an excel
spreadsheet (something like =CONVERT(cell, "MPG", "LKM")). Such as in
http://office.microsoft.com/en-ca/as...090221033.aspx

Russ.

"Ian Taylor" wrote:


Russ wrote:
How do I program excel to read a "mpg" value in one cell and display its
conversion to "l/100 km" in another cell? (ie. how would the conversion
formula be written)?

You need to know if it is an English gallon or a US gallon (they are
different).
1 mile is 1.6 km
1 English (Imperial) gallon is 4.546 litres
1 US gallon is 3.785 litres
(you can get both of these conversions easily from google)
Let's assume we are working in Imperial units
30 miles per gallons works out at 30*1.6 km/4.546 litre = 10.559
km/litre
Therefore if we take the reciprocal of the last result we get 0.0947
litres/km, so to get it in units of litres/100 km we need to multiply
by 100 to get: 9.47 litres/100 km.
(The calculation using US gallons is obviously just as easy)

Hope this helps
Ian Taylor
http://www.iantaylor.org.uk/

What formula converts mpg to l/100km
 

As far as I know, CONVERT() doesn't know about that type of conversions.

But the equations are easy:

US:
=235.214584327527 / LITRES_PER_100_KM
=235.214584327527 / MPG

Imperial:
=282.481053149606 / LITRES_PER_100_KM
=282.481053149606 / MPG


--
Festina Lente


"Russ" wrote:

How do I program excel to read a "mpg" value in one cell and display its
conversion to "l/100 km" in another cell? (ie. how would the conversion
formula be written)?