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