Hello Stefi,

Thanks for your info.

However it does not work as formula $C$1-$B$1 becomes $C$1-$B$2 when cell BI
is moved on row down. Is there any other ways


Kind Regards

Low

--
A36B58K641


"Stefi" wrote:

Try this format:
=$C$1-$B$1

Regards,
Stefi

"Mr. Low" wrote:

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


--
A36B58K641