Constant value

[Dale]

I'm using the wrong term, I know it. I have a simple formula where I am
subtracting an amount from today from a value on 12/31/05. I want to
then copy the formula to the adjoining column without having the value
of 12/31 change. It has something to do with $ signs but it's been
awhile since I needed the function. Anyone help me out? Thanks so much.

Dale

 

[JE McGimpsey]

I'm using the wrong term, I know it. I have a simple formula where I am
subtracting an amount from today from a value on 12/31/05. I want to
then copy the formula to the adjoining column without having the value
of 12/31 change. It has something to do with $ signs but it's been
awhile since I needed the function. Anyone help me out? Thanks so much.

Take a look at the "About cell and range references" topic in XL Help.

 

[Helpful Harry]

I'm using the wrong term, I know it. I have a simple formula where I am
subtracting an amount from today from a value on 12/31/05. I want to
then copy the formula to the adjoining column without having the value
of 12/31 change. It has something to do with $ signs but it's been
awhile since I needed the function. Anyone help me out? Thanks so much.

Using a cell reference in a formula does depend on the "$" as to what
happens when you copy / paste or fill down / right that formula.

A1 the value of both A and 1 are updated.

A$1 the value of only A is updated - the 1 always stays as 1

$A1 the value of only 1 is updated - the A always stays as A

$A$1 the values of both A and 1 always stay the same

Basically the $ symbol tells Excel NOT to change the following row /
column when moving that formula.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)