[lorrie]

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

[David Biddulph[_2_]]

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 ??

[dennis]

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 ??

[Lamb Chop[_2_]]

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 ??

[Bob I]

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 ??