| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why would someone use $-sign?
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. "Mafukufuku" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why would someone use $-sign?
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. "Mafukufuku" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why would someone use $-sign?
Read up on why here
http://www.ozgrid.com/Excel/free-tra...n-16-basic.htm after that; http://www.ozgrid.com/Excel/excel-fill-handle.htm -- Regards Dave Hawley www.ozgrid.com "Mafukufuku" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why put a plus sign after = sign in a formula | Excel Worksheet Functions | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
| -ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions | |||
Linear Mode
