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