What formula converts mpg to l/100km

[Guest]

How do I program a cell to read a "mpg" value in one cell and display its
conversion to l/100 km in another cell (and vice versa if I would like it to
read a l/100 km value and display mpg in another cell).

 

[smw226]

Hi Russ,

Can you please just confirm whether you are talking British Gallons or US.

Thanks,

Simon

 

[Guest]

US Gallons {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/assistance/HP052090221033.aspx}