What formula converts mpg to l/100km
 

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

What formula converts mpg to l/100km
 

Hi Russ,

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

Thanks,

Simon

Russ wrote:
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).

What formula converts mpg to l/100km
 

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}



"smw226" wrote:

Hi Russ,

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

Thanks,

Simon

Russ wrote:
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).