USE OF THE $ SIGN
 

what does the use of the $ sign in formulas do ??

USE OF THE $ SIGN
 

Look up absolute and relative addressing in Excel help.
--
David Biddulph

"lorrie" wrote in message
...
what does the use of the $ sign in formulas do ??

USE OF THE $ SIGN
 

It signifies an absolute reference which means that if you insert/delete
rows/columns or drag a formula down the reference to the specific cell will
remain the same.

"lorrie" wrote:

what does the use of the $ sign in formulas do ??

USE OF THE $ SIGN
 

A good way to remember it is: Only when you give $, it does not move.
Otherwise, it just runs away.





"Dennis" wrote in message
...
It signifies an absolute reference which means that if you insert/delete
rows/columns or drag a formula down the reference to the specific cell
will
remain the same.

"lorrie" wrote:

what does the use of the $ sign in formulas do ??

USE OF THE $ SIGN
 

Pay to Stay? ;-)

Lamb Chop wrote:

A good way to remember it is: Only when you give $, it does not move.
Otherwise, it just runs away.





"Dennis" wrote in message
...

It signifies an absolute reference which means that if you insert/delete
rows/columns or drag a formula down the reference to the specific cell
will
remain the same.

"lorrie" wrote:

what does the use of the $ sign in formulas do ??