The IFS function in Excel 2016 provides us with an easier and cleaner way of creating nested IFS formulas.
This function is available from Excel 2016 with the Office 365 subscription and is not available on previous versions
Master Excel Formulas with this online course –
In this video tutorial the IFS function is used to assign a grade to
a list of exam scores. This would previously have required 4 or 5 IF functions.
Find more great free tutorials at;