| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a "Unit" conversion system in EXCEL
I have set up two lists in EXCEL with different units eg, Gallons, Litres,
Degrees Celsius, Degree Fahrenheit, Degrees Kelvin etc. etc. The two lists are identical. I want users to be able to select a "From Unit" from one list and a "To Unit" from the other list then, enter a figure in one cell of the worksheet to convert it from one unit to the other eg. Gallons to Litres. In the column next to the Units I have the requisite symbols eg, "gal" , "L" etc. Any ideas would be appreciated. Regards, -- TonyB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Not enough system resources to display completely" message | Excel Discussion (Misc queries) | |||
| "System" Process eating CPU in Excel 2003 | Excel Discussion (Misc queries) | |||
| Error message "Not enough system resources to display completely." | Excel Discussion (Misc queries) | |||
| What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming | |||
Threaded Mode
