Excel Switch Function with 3 examples
In this video, I will show you the SWITCH() function in Excel with three simple but practical examples.
1st example - Using SWITCH() to determine the retail price of a product in a drop down list.
2nd example – Using SWITCH() to provide a remarks of either a weekday or weekend given a specific day of the week in date format. WEEKDAY() function is used to determine the serial number of the date to be used as an expression in the SWITCH().
3rd example – Using SWITCH() together with VLOOKUP() with three table reference incorporated. The SWITCH() function will use the three tables in its syntax and then, it will be inserted to the VLOOKUP() function as the table array.
Visit my channel: https://www.youtube.com/c/LinethDelaC...
Link to download the sample file:
https://www.dropbox.com/s/roz53isnyhg...
Link on a youtube video for Learn Vlookup Function in Excel for Beginners:
• Learn Vlookup function in Excel for B...
Thanks for your time and I hope you learn something from it. 😊
Help me to reach my target audience by sharing my videos with the right people. 😊
Don’t forget to Subscribe! 😊
On this page of the site you can watch the video online Excel Switch Function with 3 examples with a duration of hours minute second in good quality, which was uploaded by the user Lineth Dela Cruz 25 May 2021, share the link with friends and acquaintances, this video has already been watched 457 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
