If I have the text "B2" entered into cell A1 and in cell B2 I have the value 5...is there anyway to construct a formula where I reference A1 but it calculates it as 5?
Essentially I want the formula to look at cell A1 and have it point to the value of B2 when I do my calculation. Is this poppycock?
Essentially I want the formula to look at cell A1 and have it point to the value of B2 when I do my calculation. Is this poppycock?