assigning values to one cell which will change the formula in anot
Does anyone know if it is possible to assign a value to a number, say 1, that
when entered into a cell it will automatically change the formula in
corresponding cells. EG. If 1 = +10days
I enter 1 in b3, then the formual in b5 will change from +20days, to +10days
etc.
I don't even know if this is possible with excel, but would very much
appreciate any feedback possible. Thanks.
|