Hello Ron,

This is a great formula, It works very well irrespective of the cell
positions (rows ande column)

Many Thanks

Low

--
A36B58K641


"Ron Coderre" wrote:

Try this:

A1: =OFFSET(A1,0,2)-OFFSET(A1,0,1)
Copy down as far as you need

That formula is durable against either the Col_B or the Col_C cells moving
(or both).

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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