✋ Stop Using NESTED IF Formulas in Excel, Use SWITCH Function Instead

[@Satwant2463]

Thanks Sumit. Your videos always delight me about Excel as a powerful tool.

[@trumpexcel]

Glad you find the videos helpful 🙂

[@tedmoy]

As usual, great video. I like the way Mr. Bansal explains it, I can understand it better than other videos.

[@andrewtrayna]

I’ve always wanted to use switch but was missing the ability to add conditions. So simple, thanks!

[@naresh90sharma]

awesome Sir , Thanks for make the example

[@dharmmu]

For all your cases, the best and lot easier function is vlookup or xlookup. Switch is way lengthy and error-prone formula.

[@skriesten]

After just watching the video on vlookup & xlookup I was thinking the same thing.

[@kebincui]

Excellent video clearly explained ❤👍

[@csaaung]

thank you so much!

[@michaellundsrensen2292]

Excellent video! Is the Switch function only available in Excel 365 or is it in earlier versions?

[@jefffox8991]

You could use the choose function as well

[@tobybarker6808]

It seems to be an omission to not allow you to throw that table of Grade scores, for example, at the SWITCH function, instead of having to type A1>=90,"A" etc etc

[@sabpebhari]

I would still go for vlook-up with approximate match combination

[@trumpexcel]

If your table is sorted (and you have a table somewhere in Excel), then VLOOKUP could be convenient.

[@arunkumarmadhavan9030]

Give us some example files for the practice method that will be more informative.

[@trumpexcel]

Download file link is in the description of the video

[@naresh90sharma]

Also not work in excel 2016

[@trumpexcel]

This is a new function and is only available in Excel with Microsoft 365

[@WekomVideos]

Oooo, something new for me to play with, thank you, I think this could be really useful.

[@IvanCortinas_ES]

Very well explained. SWITCH is one of the most underused functions in Excel. Many people don't even know it exists. Thanks for the tutorial, Sumit!

[@ExcelWithChris]

Thanks!!

[@teoxengineer]

Thank you for thi good expression.
However, if we write two true values, it returns the firts one, not second.

[@trumpexcel]

Yeah, I mentioned that in the video at 08:10

[@Svain5]

Thanks for the tutorial, Sumit.
I have tried using SWITCH, but your examples have confirmed for me that it doesn't have many uses for data with more than a couple of conditions. Perhaps a little neater than some nested IFs.

[@NAVEENSHARMA-k3n]

Guruji....kya baat hai...I have never seen or heard any video of switch on you tube. Thank you for bringing this to us.

[@xeeshanahmad8757]

Well done ❤

[@gulhassan3403]

Thanks for sharing on how to use the function. Thoroughly enjoyed it 😃

[@brianchisunka4320]

Well explained🤟

[@mohammadalbizri2013]

Thank you