| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What formula converts mpg to l/100km
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)? |
| 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 | |||
| What formula converts mpg to l/100km | Excel Programming | |||
| Excel converts formula to number | New Users to Excel | |||
| Convert litres per 100km to miles per gallon easily | Excel Discussion (Misc queries) | |||
Hybrid Mode
