excel question

[Br1an_g]

it is relative to the start or initial formula.

if you copy and paste the formula to another cell, it will update the formula in relation to the start cell.

hope that makes sense.

[vb_student]

thanks for the reply
so this only holds meaning if i do a copy paste operation of cells.
and if i have an absolute reference say $a$1 and i copy paste those cells, i will be referencing the same cell.
correct?

[Br1an_g]

yes, exactly right.

if you have an absolute reference it stays fixed even when you copy / paste or drag the formuula to adjacent cells.

[vb_student]

thanks dude
now i wont beintimidated by those $ signs