"$" command will not work in VISTA

  • Thread starter Thread starter sjwillow
  • Start date Start date
S

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.

--
 
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
 
BTW. Vista is an operating system, not an excel version.. And, look in the
help index for ABSOLUTE
 
Thanks a million Tom!
--
Shelly


Tom Hutchins said:
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
 
Back
Top