dollar sign
 

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

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


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

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

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




"Jules" wrote:

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