Excel SWITCH Function - Nested IF's Just Got Easier

The SWITCH function provides a cleaner and more concise alternative to nested IF functions.
Learn ALL the important Excel functions - amzn.to/3Rg87Go
The SWITCH function refers to the expression just once, whilst multiple nested IF functions would refer to the expression in each logical test.
It then runs through a list of tests and resulting actions.
It is similar to the CHOOSE function, but CHOOSE is limited to using an index number only as the expression
The SWITCH function can handle text or a number as the expression.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1