"$" 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.
--
|