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