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

Рет қаралды 13,438

Күн бұрын

Пікірлер: 32

@dharmmu 3 ай бұрын

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

@skriesten 3 ай бұрын

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

@IvanCortinas_ES 4 ай бұрын

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!

@Satwant2463 3 ай бұрын

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

@trumpexcel 3 ай бұрын

Glad you find the videos helpful 🙂

@tedmoy 3 ай бұрын

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

@WekomVideos 3 ай бұрын

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

@NAVEENSHARMA-k3n 4 ай бұрын

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

@gulhassan3403 4 ай бұрын

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

@Svain5 4 ай бұрын

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.

@andrewtrayna 3 ай бұрын

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

@naresh90sharma 3 ай бұрын

awesome Sir , Thanks for make the example

@kebincui 4 ай бұрын

Excellent video clearly explained ❤👍

@csaaung Ай бұрын

thank you so much!

@brianchisunka4320 4 ай бұрын

Well explained🤟

@ExcelWithChris 3 ай бұрын

Thanks!!

@michaellundsrensen2292 4 ай бұрын

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

@xeeshanahmad8757 4 ай бұрын

Well done ❤

@mohammadalbizri2013 4 ай бұрын

Thank you

@teoxengineer 3 ай бұрын

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

@trumpexcel 3 ай бұрын

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

@jefffox8991 3 ай бұрын

You could use the choose function as well

@tobybarker6808 4 ай бұрын

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