dollar sign

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" <news@burnsville.freeserveXXX.co.uk> wrote in message
news:d8m4ph$beq$1@newsg4.svr.pol.co.uk...
> 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
>
>
>

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


Jules <news@burnsville.freeserveXXX.co.uk> wrote in message
news:d8m4ph$beq$1@newsg4.svr.pol.co.uk...
> What does the dollar sign mean in a formula, for example what does $B$3
> mean?
> Cheers
>
>