Thread: function
View Single Post
  #3   Report Post  
RagDyer
 
Posts: n/a
Default

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?