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! 😊
In questa pagina del sito puoi guardare il video online Excel Switch Function with 3 examples della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Lineth Dela Cruz 25 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 457 volte e gli è piaciuto 1 spettatori. Buona visione!
