What does the $ mean in "=B$6" for example
$ indicates an absolute reference so in this case the row remains as 6 if you
copy/drag the formula into other cells but column would change.
$B6 would keep the column B constant, row will change.
$B$6 would keep both fixed
B6 is total relative so both column and row change.
HTH
"Carmon" wrote:
I know that it is referencing cell B6, but I don't know what the $ is for.
|