"$" command will not work in VISTA
 

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.

--

"$" command will not work in VISTA
 

Hi
Try it this way =$B$1+$B$2
HTH
John
"sjwillow" wrote in message
...
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.

--

"$" command will not work in VISTA
 

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

"sjwillow" wrote:

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.

--

"$" command will not work in VISTA
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John" wrote in message
...
Hi
Try it this way =$B$1+$B$2
HTH
John
"sjwillow" wrote in message
...
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.

--

"$" command will not work in VISTA
 

Thanks a million Tom!
--
Shelly


"Tom Hutchins" wrote:

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

"sjwillow" wrote:

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.

--