If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"$" 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. -- |
#2
|
|||
|
|||
"$" 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. -- |
#3
|
|||
|
|||
"$" 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. -- |
#4
|
|||
|
|||
"$" 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. -- |
#5
|
|||
|
|||
"$" 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. -- |
Thread Tools | |
Display Modes | |
|
|