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