Why would someone use $-sign?

  • Thread starter Thread starter Mafukufuku
  • Start date Start date
M

Mafukufuku

Hi, I am working through a long worksheet with data. It is made for me by
someone else. It has about 2300 rows. In Column C are measuring results,
Bottom field of this column(C2300) has the median of this column. Column D
has for every row the function =(C1-C2300) to measure the difference of that
value to the median of the column. But in column D the maker uses this
notation: =(C1-$C$2300)
\
Why the dollar signs? Is it to be able to pull the function down over the
whole column D of 2300 fields without C2300 changing into C2301 C2302 etc?
Thanks
 
It fixes that particular cell so that it you copy it to elsewhere that cell
reference ($C$2300) will remain the same (it will not change as it is moved).

If my comments have helped please hit Yes.

Thanks.
 
It fixes that particular cell so that IF you copy it to elsewhere that cell
reference ($C$2300) will remain the same (it will not change as it is moved).

Sorry for error in earlier posting.
 
Back
Top