| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can Excel represent formula in textural format with values substi.
In Excel I would like to display the values that go into a formula - in
addition to the answer itself. This is to mimic the way hand calculations would be set out on paper. In other words I'd like a function that takes the maths expression within a cell and returns with a string where the cell references have been replaced with actual values. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
