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! 😊
На этой странице сайта вы можете посмотреть видео онлайн Excel Switch Function with 3 examples длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Lineth Dela Cruz 25 Май 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 457 раз и оно понравилось 1 зрителям. Приятного просмотра!
