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/formulas/switch-function.xlsx
➡️ Advanced Excel Formulas - Master more than 150 Excel functions
https://www.amazon.co.uk/Advanced-Excel-Formulas-Unleashing-Brilliance/dp/1484271246
📺 Related videos
https://youtu.be/WyD5OgPh_mY - Use AGGREGATE like an Excel pro
https://youtu.be/ivNtaAl7XNM - IF functions in Power Query
https://youtu.be/DyLfr6ji88s - SEQUENCE function in Excel
https://youtu.be/bq82SKt5fC4 - 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 ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
TikTok ► https://www.tiktok.com/@computergaga
#excelformulas #excel #advanceexcel