What formula converts mpg to l/100km

G

Guest

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)?
 
I

Ian Taylor

Russ said:
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/
 
T

Tom Ogilvy

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top