Fixed Cell Value

[Gene Hacker]

I have done this in the past but cannot seem to get a handle on how it was done.
What I want to do is to establish a 'fixed' value in a cell and than use that value in
all subsequent formulas.
As an example, set a fixed value for gold in cell C1
as each days gold value is entered in cell b2 thru b999, use the value in c1 to compute the rise or fall of golds value both as a plus or minus rise or fall from the fixed value (c1) and also to compute the percentabe of the rise or fall from the fixed value (c1) on a daily basis represented in golds value in cells b2 thru b999
I know that this can be done but I cannot figure out the prefix for the fixed value in c1 to accomplish this.
As I am now retired and have not written any complex excel worksheets in quite a few years, could I get some help for an old has-been programmer and developer
Thanks

[protonLeah]

$C$1 in all formulas in other cells. The '$' in front of the C will cause it to be constant if you should drag a formula right from column to column.

The '$' in front of the 1 will cause the 1 to remain constant if you should drag a formula down from row to row.

You can also name the cell, say, "FixedPrice", and use that name in the formulas (my choice)

See: http://www.excelforum.com/excel-gene...nt-a-time.html