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:
The same formula using IFS function is much simpler to type and understand :
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.
