dollar sign

[Jules]

What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers

 

[R.VENKATARAMAN]

this means absolute cell addres. if you use this in any formula etc it will
always be B3 only.

 

[Bob Phillips]

It differentiates between absolute and relative referencing, and becomes
important when using a formula over many cells.

As an example, enter =$B$3 in A1, and enter =$B3 in B1. Then select A1:B1
and copy them, and then paste to A2:B2. In A2, you should see =$B$3, exactly
in A1. But in B2 you should see =$B4, which means that the formula has
changed relative to the cell it is placed in.

 

[Guest]

It means that it "Fixes" a cell location. e.g. if you have a list of numbers
in column E
if you do E3*$B$4 and copy the formula down in column E... it will
always multiply column E's nunbers by by cell B4