| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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). |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EOMONTH formula randomly converts to NA | Excel Worksheet Functions | |||
| Formula Disappears, converts to a value | Excel Worksheet Functions | |||
| Excel converts formula to number | New Users to Excel | |||
| Convert litres per 100km to miles per gallon easily | Excel Discussion (Misc queries) | |||
| What formula converts date to month only | Excel Discussion (Misc queries) | |||
Linear Mode
