View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mafukufuku Mafukufuku is offline
external usenet poster
 
Posts: 1
Default Why would someone use $-sign?

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