Hi Forrest

You can replace a whole heap of your IF statement with one CHOOSE.
See my earlier posting, and watch out for line wraps as you copy and paste.

Regards

Roger Govier


Forrest wrote:
I think I found it. Since I have two orders nested within the If functions
it can't operate past the 5th If. Why doesn't Microsoft come into the 21st
century and eliminate this silly nesting restriction.

"Ron Rosenfeld" wrote:


On Wed, 26 Oct 2005 11:16:06 -0700, "Forrest"
wrote:


I have a formula in one cell with several functions used multiple times. It
seems though that 25 times is the max for the Round function before it blows
up. Why?

The error has nothing to do with the ROUND function. You have run into the
seven level function nesting limitation of Excel.

What are you trying to do? Perhaps someone can suggest an shorter formula.


--ron