Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter value, convert, read result from same cell
Hi,
I am attempting to build a travelling esxpenses calculator capable of handling several variables; distance travelled, fuel economy (mpg), price per litre of fuel. I would like the option of being able to enter a value eg 120.3 (km) and then convert this figure to miles for the rest of the formula. so I would like a button that says "convert to miles" or similar that when activated returns the contents of the cell as a milage (in this instance approx 75.2). I would also (of course) like the option of entering miles directly in the cell and for the rest of the formula to pick it up. I have worked out that I can achieve this using two cells and a circular function with a single iteration (entering miles gives km and vice versa) but as soon as a result is displayed it overwrites the formula for that cell and can't be undone so any mistakes (for instance entering mileage values in the km cell) mean a complete fresh start. I understand it is possible to write a macro that can deliver results in the same same (input) cell but all my experiments have failed. Can anyone explain to me what I need to do, or what other options there are? Thanks, Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
Function can not read cell value properly without enter | Excel Discussion (Misc queries) | |||
Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
Enter a formula to return a result from a cell | New Users to Excel | |||
How do I convert the result of LARGE to the cell (or column) refe. | Excel Worksheet Functions |