M
Mr. Low
Dear Sir,
May I know how to keep the formula in a cell at its stationary position when
the other cell is moved ?
Lets consider the folowing worksheet example:
A B C D
1 = C1-B1
2 = C2-B2
3 = C3-B3
4
Formula =(C1-B1) is entered cell A1, however when cell C1 is cut and moved
to position C2, the formula in cell A1 now becomes = (C2-B1).
Is there a way to keep the formula in column A remain unchanged even if
column C is moved out from its original position (i.e. up, down, lefft or
right) ?
Thanks
Low
May I know how to keep the formula in a cell at its stationary position when
the other cell is moved ?
Lets consider the folowing worksheet example:
A B C D
1 = C1-B1
2 = C2-B2
3 = C3-B3
4
Formula =(C1-B1) is entered cell A1, however when cell C1 is cut and moved
to position C2, the formula in cell A1 now becomes = (C2-B1).
Is there a way to keep the formula in column A remain unchanged even if
column C is moved out from its original position (i.e. up, down, lefft or
right) ?
Thanks
Low