Hi Harold

One way would be to use a cell say X1 to hold this calculation, then
reference $X$1 in your formula in place of the calculation.

Regards

Roger Govier


Harold Good wrote:
Hi,

I have a long formula that is getting too long. It has 3 embedded IF
statements, with the logical test below having to be calculated each time.
(Planning!X14/365.25)+1900-INT((Planning!X14/365.25)+1900)

For example, when the logical test solves this to 2004, is there some way to
store that "2004" in memory the first time and recall it as "2004" in the
formula for the other two logical tests. Otherwise the formula is getting so
long, and these three embedded IF are just a portion of a longer formula.

In summary, is this possible to, in the middle of a formula, store something
in memory and recall it from memory for use in other places in the formula?

I think you'll say no, that's what VBA is for. That's ok, I just would like
to know for sure.

Thanks,

Harold