Indirect Formula Reference
Posted by Dave on April 09, 2001 6:59 PM
I would like to enter a formula into a cell as text, then have that formula calculated in a different cell. I know I can display formulas for the whole sheet, but I don't want to do that.
In A1, I would enter the value 3.
In B1, I would enter the value 'A1 + 5. This would be text, not a formula. Excel would display "A1 + 5"
In B2, I would like to know what I have to enter to have B2 copy the text from B1, evaluate the expression A1 + 5, and display 8.
This way, I could change the "5" in B1 to a 4 and see "7" in B2.
Thanks for your help.