4 alternatives to nested IF formulas

4 alternatives to nested IF formulas

24 September 2017

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.