relative reference

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I have a cell formula =SUM(I4,-F4) which is in cell J4. If I insert a
column so that j moves to k, I want the formula to adjust to
=SUM(J4,-G4). Is this possible, and if so how?
thanks...charlie
 
Only if you insert the column to the left of F4 will it do that
btw, no need for a SUM formula, =I4-F4 will do

Regards,

Peo Sjoblom
 
I thought I read somewhere that there was a relative
cell reference, something like R[1]C[1] which would refer to the cell
one column to the right and one row down, or RC[-1] which would refer
to the cell pn the same row and ne column to the left. But I can't get
this to work or an more information on it.
 
Back
Top