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.

--
HTH

Bob Phillips

"Jules" wrote in message
...
What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers