Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nest a referenced formula in excel
Hello,
Does anyone know a way to use a referenced cell (containing text) and have the parent cell use that text in the formula? As an example. In A1 I have "B1+B2" (stored as text, not an equation) Then I want to be able to have A2=A1, and have it actually compute the equation (B1+B2) as if I had typed '=B1+B2' into A2 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nest a referenced formula in excel
You can use evaluate(), but not directly. Here is an example:
http://www.ozgrid.com/News/excel-eva...ormula-VBA.htm " wrote: Hello, Does anyone know a way to use a referenced cell (containing text) and have the parent cell use that text in the formula? As an example. In A1 I have "B1+B2" (stored as text, not an equation) Then I want to be able to have A2=A1, and have it actually compute the equation (B1+B2) as if I had typed '=B1+B2' into A2 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Why not nest more than 7 functions in Excel formula??? | Excel Worksheet Functions |