IFS() Function Excel - Easy Nested IF Statements in Excel
HTML-код
- Опубликовано: 6 сен 2024
- Easily create nested IF statements using the new IFS() function for Excel!
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
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!
TeachExcel.com
#excel #tutorial #howto
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.
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!
I'm very happy that you found my tutorials helpful :) Now that I'm stuck inside, I'm making some more courses as well and hopefully those will be just as helpful)
Much appreciated. Like how you broke down the logical sequence for building the function. Thank you
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!
You're very welcome Wayne) That's a great tip for the True/False, especially since people will see it in formulas and if you don't know it, it can be confusing. In my own formulas, I don't know how I feel about True/False and 0/1. I tend to almost never use the 0/1 method in my formulas, but it seems like a lot of daily-users-of-Excel tend to prefer that method - for now, I am still part of the resistance haha
Wow....What an excellent way of teaching sir..........A Big THANK YOU...
I really like your voice. It is very clear
Thank you! I try to make it clear for you guys :)
Thank you was stuck on this step on my assignment for my class for hours until I looked for help on RUclips and your video was very clear and straightforward thank you 🙏
I'm very glad to hear it! You are very welcome :)))
GREAT MAN
This is super amazing.. thanks...looking forward to a lot of videos based on functions and formulas with more tough examples...
You're very welcome! I'm glad you liked it) I have a lot of more complex formula tutorials on other topics, what kind are you interested in?
great deal while simple explanation: great!
thank you! I'm glad you liked it :)
Great Stuff..IFS Is One Of My Favourite Functions So Easy To Use,Also Really Nice Formula and Deconstruction Example Thank You Sir :)
Thanks Darryl! I'm glad you liked it) I wasn't sure about doing such 'basic' tutorials compared to ones like the text manipulation formulas that I do, but it seems like people like this, so I'l think I'll do some more :) I'm glad you liked the building-the-formula part as well, I think making a working formula can be a lot more difficult than understanding it sometimes.
Thank u so much this video helped me alot
You mention "index match" in the beginning; why not the new "xlookup"?
Honestly, because Index/Match has been around for so long that it just automatically pops into my head when I think about a robust lookup setup using worksheet functions. Xlookup is also very new and I don't know if it would be useful to too many people just yet but maybe I will make a tutorial on it as it seems like people are interested in these kinds of tutorials) Thanks for the comment:)
@@TeachExcel OK, cool. I'm on the 'insider' program with 365 so I get these new things quickly. Guess I wasn't thinking that a lot of people don't have xlookup yet, but it makes index match obsolete.
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?
You should be able to click the little Fx icon to the left of the formula bar and input it that way - I've never used a Mac though.
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) ??
example: to calculate tax, if amount in cell X is less than 0, equal 0, if amount greater( > ) than 0, Calculate it (25%* positive amount) ..
haha I figure it out by adding a """ IMSUB(CELL#,25%)""" EXAMPLE: =IF(E24
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.
Idk why but it's displaying the wrong thing. I used the first formula.
Gonna have to upload your sample code or file to our forum and let someone take a look. I can't diagnose the issue from your comment :/
www.teachexcel.com/talk/microsoft-office?src=yt_comment
i could not find this IFS() formula in 2010
I think that you need Excel 2016 or later for it - I might have forgotten to mention that in the tutorial, sorry :/