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
|
|||
|
|||
Constant in Excel Formula
I remember using the $ i think to keep a column constant when doing a
formula. What is it? |
#2
|
|||
|
|||
Constant in Excel Formula
Four choices
$A$1 : both column and row do not change while copying $A1 : row changes while copying down, no change while copying across A$1 : column changes while copying across, no change while copying down A1 : both change while copying across or down "Chele" wrote: I remember using the $ i think to keep a column constant when doing a formula. What is it? |
#3
|
|||
|
|||
Constant in Excel Formula
check out this site
http://news.office-watch.com/t/n.asp...d=613&zoneid=8 "Chele" wrote: I remember using the $ i think to keep a column constant when doing a formula. What is it? |
#4
|
|||
|
|||
Constant in Excel Formula
That is exactly what it does - keeps the row or column constant depending
upon where it is inserted. If before the column, then the column is constant. Please read up on absolute and relative references in Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Chele" wrote in message ... I remember using the $ i think to keep a column constant when doing a formula. What is it? |
Thread Tools | |
Display Modes | |
|
|