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