Hey All,
Usually, people use cell locations in formulas. Anyone know how to use a formula in a cell location?
For example:
C1 is 5
C2 is 10
C3 is 12
I want D{C2}=C1+C3.
In other words D10=C1+C3.
So I want to use C2 in the location of the D cell. Does this make any sense, and if so, is there a way to do that in Excel?
Thanks.
Henry
Usually, people use cell locations in formulas. Anyone know how to use a formula in a cell location?
For example:
C1 is 5
C2 is 10
C3 is 12
I want D{C2}=C1+C3.
In other words D10=C1+C3.
So I want to use C2 in the location of the D cell. Does this make any sense, and if so, is there a way to do that in Excel?
Thanks.
Henry