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.
....

The good news is that Microsoft will finally raise this limit (one
which has set Excel appart from other spreadsheets for decades - at the
LOW end of the capability range in this regard) in the next version.