IFS() Function Excel - Easy Nested IF Statements in Excel

Easily create nested IF statements using the new IFS() function for Excel!

The IFS() function allows you to have multiple conditional checks and output something different for each condition. The structure of this function is more like the IF statement in programming than the IF() worksheet function in Excel.

In addition to the syntax and basic usage of the IFS function, I'll show you a simple process for making much more complex decision structures using this variation of the IF statement.

In this tutorial, I'll walk you through multiple examples, including:
- checking text values and outputing different smiley faces based on food selections
- checking for ranges of values, the standard "school grades" example
- combining multiple logical checks together in order to create a more complex decision structure using the IFS() function in Excel

I hope you enjoy this tutorial!

Stay safe!

#excel #tutorial #howto

[ninaguerra]

this is incredibly helpful. I was searching for how to combine IF and IF(OR statements -- which i could not find -- and I found this which changed my life! lol thanks so much for the info.

[danielkeller]

Stumbled upon your Power Query introduction in a search and it was very easy to follow with great examples. It will change a lot of my financial spreadsheets at work and my workflow. Thanks for the introduction to that add in and I will be coming back for more!

[querrythis]

Much appreciated. Like how you broke down the logical sequence for building the function. Thank you

[wayneedmondson]

Thanks for the video. IFS can come in handy vs. old school nested IF statements. If anyone is interested you can save a little typing and use the numeral 1 in place of TRUE for the last ELSE statement (in functions, EXCEL interprets 1 as TRUE and 0 as FALSE in function arguments). Thanks for all the tips. Thumbs up!

[supamani]

Thank you was stuck on this step on my assignment for my class for hours until I looked for help on YouTube and your video was very clear and straightforward thank you 🙏

[neharajput]

This is super amazing.. thanks...looking forward to a lot of videos based on functions and formulas with more tough examples...

[ramk]

Wow....What an excellent way of teaching Big THANK YOU...

[darrylmorgan]

Great Stuff..IFS Is One Of My Favourite Functions So Easy To Use, Also Really Nice Formula and Deconstruction Example Thank You Sir :)

[amoled]

I really like your voice. It is very clear

[a-m_Bros_Studios]

great deal while simple explanation: great!

[natnoli]

Thank u so much this video helped me alot

[cristinamccracken]

Hi i am working with excel on a macbook. Do you know how to bring up the box to type in IF statements rather than manually putting it all in?

[giltomh]

Thanks for this videos.. I have a question about this (IF) topic. How can I use a condition that if is true will calculate two or more cell, and if is false it will be equal to 0? and if could be also done for ( percent) ??

[vdpeer]

You mention "index match" in the beginning; why not the new "xlookup"?

[hellofrombd]

i could not find this IFS() formula in 2010

[Noelito]

Thanks for the video but might I suggest that you not use smiley faces in examples as the use of the brackets can be confusing in amongst the syntax of the function.

[justahumanwithamask]

Idk why but it's displaying the wrong thing. I used the first formula.