Excel IFS Function - No More Nested IFS

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 Learn more than 100 Excel formula in the Ultimate Excel course - https://bit.ly/UltimateExcel In this video tutorial, the IFS function in Excel 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; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm