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