CHOOSE

Avoiding Nested IFs

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 …

Avoiding Nested IFs Read More »