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

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

Absolute reference.
--
David Biddulph

"wilson staff" <wilson wrote in message
...

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

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" wrote:

Absolute reference.
--
David Biddulph

"wilson staff" <wilson wrote in message
...