N
nickname
Is there a way to refer to the formula from (not value of) a non
active cell into a formula in an active cell?
For example,
A1: =A2+A3 [non active cell]
Would like to insert above formula (A2+A3) into active cell's formula
by referring to A1, non active cell.
B1: = ?function?(A1) + B4 + B5 [active cell]
Here are the values of cells:
B2 = 2
B3 = 3
B4 = 4
B5 = 5
So the value of B1 would be 2+3+4+5 or 14.
Thanks in advance for any guidance.
active cell into a formula in an active cell?
For example,
A1: =A2+A3 [non active cell]
Would like to insert above formula (A2+A3) into active cell's formula
by referring to A1, non active cell.
B1: = ?function?(A1) + B4 + B5 [active cell]
Here are the values of cells:
B2 = 2
B3 = 3
B4 = 4
B5 = 5
So the value of B1 would be 2+3+4+5 or 14.
Thanks in advance for any guidance.