Hi Harold,

Use a separate cell for the intermediate result. Much easier testing too!

--
Kind regards,

Niek Otten

"Harold Good" wrote in message
...
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