Avoiding Nested IFs

We have all done them but there comes a time to find a better way.  In Excel 2003 you were limited to 7 levels of nesting but 2007 onwards the level could be increased to 64. Both these levels are beyond my pain barrier for an overly complex formula fraught with danger. Even if you …

Avoiding Nested IFs Read More »