Stop Nesting IFs! Learn the SWITCH Function in Excel

The SWITCH function in Excel is the best for testing multiple conditions and leaves nesting If functions a thing of the distant past. See multiple SWITCH function examples in this video including testing numeric values (which some believe cannot be done) and creating a dynamic chart title from drop-down selection. 📚 Practise file used in video https://computergaga.com/_excel/files... ➡️ Advanced Excel Formulas - Master more than 150 Excel functions https://www.amazon.co.uk/Advanced-Exc... 📺 Related videos    • Why Excel Pros LOVE the AGGREGATE function...   - Use AGGREGATE like an Excel pro    • How to Write an IF Function in Power Query...   - IF functions in Power Query    • SEQUENCE Function in Excel - Introduction ...   - SEQUENCE function in Excel    • LAMBDA Function in Excel (CUSTOM Excel For...   - Create your own Excel functions ⌚ Timestamps 00:00 - SWITCH function in Excel 02:32 - SWITCH versus nested IFs 03:08 - SWITCH for testing numbers 05:18 - Using AND with SWITCH 06:58 - Dynamic chart titles 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 Connect with us! LinkedIn ►   / alanmurray-computergaga   Instagram ►   / computergaga1   Twitter ►   / computergaga1   TikTok ►   / computergaga   #excelformulas #excel #advanceexcel