Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use a cell's text, "A1", and put it in a formula?
Excel XP; I would like to use the value of a cell, e.g. the value of cell
"F7" is "A1" and represent the "A1" in another cell as part of a formula, so that when I calculate a formula, it will take the contents of cell "F7" Thanks. |
#2
|
|||
|
|||
Use the Indirect function.
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "HighRiser" wrote in message ... Excel XP; I would like to use the value of a cell, e.g. the value of cell "F7" is "A1" and represent the "A1" in another cell as part of a formula, so that when I calculate a formula, it will take the contents of cell "F7" Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|