What is the affect of adding the symbol $ into a excel formula

J

Jim Thomlinson

there are 2 forms of referencing in a formula. Absolute (indicated with a $
symbol) and relative (no symbol). When a relative referenced formula is
copied or dragged the column and/or row numbers will increment. Absolute
referenced cells will not. Hit F1 to bring up the hlep and type in Absolute
reference for further details...
--
HTH...

Jim Thomlinson


David Biddulph said:
Absolute reference.
[/QUOTE]
 
Top