what does the use of the $ sign in formulas do ??
D Dennis Jun 12, 2008 #3 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.
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.
L Lamb Chop Jun 13, 2008 #4 A good way to remember it is: Only when you give $, it does not move. Otherwise, it just runs away.
B Bob I Jun 13, 2008 #5 Pay to Stay? ;-) Lamb said: A good way to remember it is: Only when you give $, it does not move. Otherwise, it just runs away. Click to expand...
Pay to Stay? ;-) Lamb said: A good way to remember it is: Only when you give $, it does not move. Otherwise, it just runs away. Click to expand...