"$" command will not work in VISTA

[sjwillow]

Hello,

Does anyone know why the "$" command will not work in formulas when running
VISTA? Does anyone have a solution?

A simple version of my problem is:

=$b1+$b2

When you drag down the formula in a column, it will continue to auto fill
with the next number despite the stop function "$" and will look like:

=$b2+$b3
=$b3+$b4
and so on


Any help would be greatly appreciated.

--

 

[John]

Hi
Try it this way =$B$1+$B$2
HTH
John

 

[Tom Hutchins]

There are four variations of absolute/relative cell addresses:

A1 = row & column are both relative
$A1 = column is absolute; row is relative
A$1 = row is absolute; column is relative
$A$1 = row & column are both absolute

=$b1+$b2 will always point to column B, but the row refernce is relative,
so it changes as you copy it up/down. Put a $ in front of the row numbers to
make them absolute:

=b$1+b$2 or =$b$1+$b$2

Hope this helps,

Hutch

 

[Don Guillett]

BTW. Vista is an operating system, not an excel version.. And, look in the
help index for ABSOLUTE

 

[sjwillow]

Thanks a million Tom!
--
Shelly

There are four variations of absolute/relative cell addresses:

A1 = row & column are both relative
$A1 = column is absolute; row is relative
A$1 = row is absolute; column is relative
$A$1 = row & column are both absolute

=$b1+$b2 will always point to column B, but the row refernce is relative,
so it changes as you copy it up/down. Put a $ in front of the row numbers to
make them absolute:

=b$1+b$2 or =$b$1+$b$2

Hope this helps,

Hutch