| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function that will evaluate a text string in a cell?
Depending of the data in the spreadsheet, I need to change the formula in a
cell. I'm trying to find an excel function that will evaluate the resulting text in a cell sort of like the INDIRECT() function does but one that will work on formulas. I'm trying to use a formula in a cell to create a text string that I then want evaluated. I.e.; a formula in cell A1 creates a text string with a formula "=B2*C2". I'm looking for a function that will evaluate that string. I thought this function was in excel but I can't find it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to evaluate function as string | Excel Worksheet Functions | |||
| Evaluate text string as a function | Excel Discussion (Misc queries) | |||
| IF function - need to evaluate cell content in 2 separate files-#N | Excel Worksheet Functions | |||
| Evaluate string as a formula | Excel Worksheet Functions | |||
| how to evaluate the content of a string as if it was a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
