How to Use the IFS Function in Excel

The IF function is one of the most popular functions in Excel. But writing nested Excel IF formulas in situations when more than 1 condition has to be checked can become cumbersome. If you have Excel 2019 or Microsoft 365 you can use the Excel IFS function instead.

📈 What You'll Discover:
- Excel's IFS Function: Learn to utilize IFS for various logical tests, replacing the need for nested IF statements.
- Practical Examples: Follow along with two real-world scenarios, including salary comparisons and feedback emoji creation using IFS.
- Custom Formatting: See how custom formatting can transform numerical weekdays into textual representations.

👨‍💻 In This Tutorial:
- Salary Comparison: Compare salaries against a benchmark, categorizing them as higher, lower, or the same.
- Feedback Emoji Creation: Convert employee feedback into emojis and add conditional formatting for a more engaging data presentation.
- Bonus Tip: Explore the potential of VLOOKUP and XLOOKUP as alternatives to complex IFS or IF statements.

In this tutorial I'll show you how easy it is to use this logical function when testing for multiple criteria. Your formulas will be much easier to read.

Since the IFS function only checks for the TRUE condition, how can you include an else condition in IFS? There is a simple way around this. Check it out at minute 02:42.

I'll also show you how you can use conditional formatting in Excel (on emojis) to visualize results better.

As a special bonus tip I'll cover how you could replace the Nested IF formulas with the VLOOKUP function.

00:00 Excel IFS instead of Nested IF formulas
00:37 Testing for 3 conditions with IFS
02:42 How to include "else" statement in IFS
04:40 Excel IFS with conditionally formatted emojis
09:06 Use Excel VLOOKUP instead of Nested IF

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[Chimeratech]

4:00 THANK YOU! I have tried watching several videos trying to understand what the last catch all TRUE means, and you explained it perfectly.

[kickthesky]

I've been using the IFS function for a while now, but when I first found it, it was such a revelation for me; a real game-changer. This is great content that is going to help out a lot of people. I have recommended your videos to so many people as you always have great content that is easy to explain.

[sanjaysinha]

This channel is my “go to” place whenever I think ‘there must be a better way to do this since I learnt excel 32 years ago’ 😀
Also enjoy how you learn or refresh yourself on another function - in this case conditional formatting. Relevant to the solutions well..
Thank you

[RogerClubv]

What a way to start my morning! Though that might sound geeky, but there’s nothing better than starting the day learning something new and short. Thanks! I’m a huge fan.

[Stepford]

Another couple of functions I can definitely see myself using in the future and some great tips too. Thanks again Leila! You're a star :)

[salahdabash]

Every time I watch your lessons I feel the value of time with you increases and each lesson thank you very much for your, truly appreciate

[beteltree]

Leila -- Thank you for clueing me in to the use of F9 to check results within formulas. While the use of F9 function is not the purpose of your video, it is the gift I took away with me. And of course, a refresher on IFS is much appreciated too. Your tutorials are always helpful and enriching in direct and unexpected ways. As a student, I don't always know where to start asking questions but a gifted teacher helps me form my own questions. You are awesome!

[anchoaescastilla]

What a fantastic tutorial. Thank you very much, this video has been the last after advice searching, and thanks to you I understand it much better. The speed, the clarity, the overall quality of your content is outstanding.

[nadeemmalik]

Great Ifs example. I always learn a lot from your excel tutorials. You are really amazing with your explanations. No one else comes close.

[kurtb]

Good instructions ! I learned already quite a bit from your courses. You are my default “go-to” whenever I need a special Excel function ! Thank you !

[mcd]

The IFS() function will be very useful. Thank you for demonstrating its features and touching on a couple of other approaches.

[arfanahmed]

I am new subscriber of your channel. I have been watching all of your videos since March and find all the videos full of new resources.thank you so much Leila Ma'am. I am grateful to be a part of your channel.

[RobertShooter]

I learn pretty much all my excel skills from you brilliant 👍 I just need to upgrade to Microsoft 365 now 😃

[wayneedmondson]

Hi Leila.. thanks for the fun IFS and emoji formulas. In case anyone is interested, when using IFS, you can also terminate the final test with any non-zero numeral such as 1, as in: =IFS(B6>$C$3, "Higher", B6<$C$3, "Lower", 1, "Same"). Even negative numbers will work like -1 or -10. Probably TRUE is the better option for readability and clarity, but always interesting to note other options in terms of how EXCEL interprets the arguments of a function. Thanks for the videos.. always good learning and fun at your channel :)) Thumbs up!!

[wolfmanbfg]

Every video is precious and worths watching and rewatching, thank you Leila.

[AngeloLowrie]

Leila, you are an amazing teacher! Thank you for sharing your knowledge in a way that's understandable and relevant.

[dotflexbooks]

Once again, a well delivered lecture/lesson. 👍. I always look forward to your videos every week with the assurance that you won't disappoint by increasing my knowledge of Excel. Thanks and keep it up.

[hebvitek]

Ms. Leila, EXCELENT VIDEO on IFS and the tip at the end as well. Thank you!! You are awesome!!!

[signalmas]

LOVE IT ! I was shy to use IFS because I didn’t know how to deal with the falses and didn’t bother to research it. I ‘m always looking forward to your Thursday videos. Thank you Leila !

[All_in_one_]

Excellent explanation and outstanding demonstration. Hats off Leila!