dollar sign

B

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.
 
P

Phil Wales

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
 
Top