I can't remember why you would put a $ in a function in a spreadsheet. I
removed the $ and it didn't change the number that was there, so why is it
needed?

The $ symbol means absolute cell reference. So when you copy the formula some
where else it will always refer back to that Column, Row or Cell. Ex. $A1,
A$1 or $A$1.

"function" wrote:

I can't remember why you would put a $ in a function in a spreadsheet. I
removed the $ and it didn't change the number that was there, so why is it
needed?

So that the cell references (row and/or column) will not change during
copying.

Check out this link:

http://www.cpearson.com/excel/relative.htm

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"function" wrote in message
...
I can't remember why you would put a $ in a function in a spreadsheet. I
removed the $ and it didn't change the number that was there, so why is it
needed?