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

Рет қаралды 11,697

Күн бұрын

In this video, I cover how to use the SWITCH function in Excel, which can be used as a replacement for Nested IF formulas.
The video will show you a detailed introduction to the SWITCH function and some examples of its practical use-cases. I also compare it with other similar functions, such as IF and IFS.
⬇️ Download Example File - www.dropbox.com/scl/fi/94rlv9...
00:00 Intro
00:36 SWITCH Function Explained
03:14 Using SWITCH Function with Dates
06:18 SWITCH vs. IF vs. IFS
10:00 Calculating Commission Using SWITCH Function
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 30

@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!

@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.

@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.

@gulhassan3403 Ай бұрын

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

@WekomVideos Ай бұрын

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

@user-yu7xl6mf3t Ай бұрын

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

@naresh90sharma Ай бұрын

awesome Sir , Thanks for make the example

@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.

@kebincui Ай бұрын

Excellent video clearly explained ❤👍

@andrewtrayna Ай бұрын

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

@brianchisunka4320 Ай бұрын

Well explained🤟

@xeeshanahmad8757 Ай бұрын

Well done ❤

@ExcelWithChris Ай бұрын

Thanks!!

@michaellundsrensen2292 Ай бұрын

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

@mohammadalbizri2013 Ай бұрын

Thank you

@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

@jefffox8991 Ай бұрын

You could use the choose function as well

@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.

@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