7 alternatives to nested IF function

7 alternatives to nested IF function

17 June 2017

The IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel's formulae mastery.

However, it is also one of the most misused functions, especially nested IF. Especially now with Excel 2007 and beyond, you can nest up to 64 IF functions to form complex, slow and hard-to-understand IF THEN ELSE statement.

You don't need to slow or complicate your worksheet anymore, this article describes 7 alternatives to using nested IF functions.