4 alternatives to nested IF formulas

Nested IF formulas are extremely useful for complex decision making on a spreadsheet, but they can also be long, messy and convoluted.

This blog post explores 4 alternatives which are easier, faster and cleaner than the classic nested IF:

• The IFS function.
• Using VLOOKUP for an exact match.
• Using VLOOKUP for a range lookup.
• The fantastic CHOOSE function.