fbpx

IFS function: Goodbye nested IFs

With Excel 2016 and Office 365 Pro plus, a less confusing and powerful function was introduced – IFS function. It eliminates the confusion generated by multiple nested IFs for complex calculations. In any case, if you are using multiple nested IF statements, check whether VLOOKUP can solve the issue or use Pivot Table grouping.

Nested IFs look like this:

image

The same formula using IFS function is much simpler to type and understand :

image

IFS function has just ONE set of brackets, irrespective of the number of conditions used. It also offers the last argument for default return value – in case all other conditions did not produce any output.  Try using it.

The function will return an error if used in versions before Excel 2016. Be careful.

Queries | Comments | Suggestions | Wish list