You truly tackle any issue at its core. your simplicity with examples to illustrate functionality is more than amazing. Great lesson and I hope to be able to view more of your excellent lectures in the near future. Thanks a lot.
EXCELLENT !!! I am glad to find you - the GREATEST TEACHER on youtube 👌.Thank you millions for taking time to educate & inspire us learning. I always thumb ups 👍every lessons I watch. Your video is on my daily learning schedule since I first found you♥👏
Very helpful for me coz i am a big fan of IF however i have to ask something about printing. I have a leadger more than 12 pages and i need to have previous balance generated on every page that is printed. Thnx i hope i ll se this toturial soon....
thanks for highlighting this function. wondering why you dont use the wizard instead of typing the function in the cell? I find the wizards much easier to follow for complex functions including vlookup, etc.
In your first example, I think you could use =IFERROR(your IFS formula goes here),"") and that would make the cell blank until a score shows up in the grade column. Right?
Super presentation. But, I need to ask one question here. Suppose, I have dropdown list of all departments and also in dropdown one common dept for those who are reporting for this, can we not link it to the formula with the dropdown list. I mean Is there a short cut for formula creation with dropdown.
This will be valuable tomorrow. I'm grading a vocabulary quiz. But if a student writes a wrong answer, but it's almost correct, or spelled wrong, I can add partial points
I have tried the formula IFS today and put several conditions, as you did in this video, but my formula doesn't work, it recognises only the first and the last condition. I have checked and re-checked the formula, everything seems to be alright but still doesn't work. Would you please let me know if there are any common errors that this formula may give? Thank you very much!
I learned a great deal from you, thank you for the amazing videos you make. I have a question. Regarding the IF function, I want to make a survey table for customers of a specific city. All is going great except for one complicated detail. The survey table consists of 3 drop list that are in relation to each other which are (Region, District, Sector) respectively. I have 8 surviers each of them is responsible for a specific district that consists of 10+ sectors that belong to one of the 2 regions in my table, my question is can I use the IF function to minimise the choices of sectors to a specific survier only to his area of interest? Note 1: Region, District & sectors are names not numbers Note 2: Regions=2, District=12 Sectors=130 Thank you
Is there anyway to force Excel to not interpret text as numerical values? In the second example, is there really no way to make Excel display a customized message if the corresponding value is obviously not a test score?
Is there a way to use the IFS formula to determine the following if less than 2 hours you get paid $0, 2 hours but less than 6 hours you get paid $18, 6 hours but less than 12 hours you get paid $40, and 12 hours or more you get paid $55.
can we do this ? like in = if we assign a cell value. its not working for me . i want to do this becasue my value of = , which i have to print is not a constant value it depend on other values
Instead of typing all the arguments on the formula bar, is it possible if I make an "another" Sheet first and then using the if arguments BASED ON THE SHEET i've make before to determine the value ? ^Sorry for bad english
What if managers change? Is it possible to incorporate cell references to maintain integrity with manager changes? Ps I could have used this just today. Thanks!
Very good info..But I still didn't understand the last one..TRUE ( not within quotes ) & NOT APPLICABLE in quotes...Pls explain...Keep this rolling. God bless you...
The word TRUE is a function that basically says that if all of the previous conditions come up false, then Excel will force whatever comes next to be true. So it's like saying, "If all else fails, then display ____ on the spreadsheet." We put "Not applicable" in quotes because it's text that we want displayed in the spreadsheet for people to see.
Honestly, this is a bad IFS tutorial. Not that it's not well explained, but in all your examples I would have used a VLOOKUP or a XLOOKUP and it would have been much more efficient, flexible, etc.
You truly tackle any issue at its core.
your simplicity with examples to illustrate functionality is more than amazing.
Great lesson and I hope to be able to view more of your excellent lectures in the near future.
Thanks a lot.
I love your videos you make the learning easier and more fun I don’t even feel bored. you’re the best teacher ever thank you for helping us
Thank you, you teaching style is so easy to follow and retain. All the best. Stay well. Appreciative Excel beginner.
I absolutely love your tutorials. You make it look and sound so easy! Thank you!
Yeah. And it really is easy they way he teach is very understandable.
After weeks of searching... YOUR vid finally knocks this out of the park - and clearly! Thank you...
Very cool! Thank you! I used to use the nested IF function but lately hadn't needed to. That may change as my job changes yet again. 😊
EXCELLENT !!! I am glad to find you - the GREATEST TEACHER on youtube 👌.Thank you millions for taking time to educate & inspire us learning. I always thumb ups 👍every lessons I watch. Your video is on my daily learning schedule since I first found you♥👏
Thank you for your kind words. I really appreciate it.
Great tutorial simple and easy to understand. Thanks for sharing! Awesome work!
This is a great new function, so much simpler than a nested IF functions or having to combine IF with OR.
Got me hooked on this from the first second. I am addicted to Excel and vba coding. Subbed.
Thanks, very informative, great presentation, looking forward to more, again thanks.
Finally what I was looking for. Thank you very much.
You are great teacher Sir.
Thanks a lot for your nice tutorial.
Very helpful for me coz i am a big fan of IF however i have to ask something about printing. I have a leadger more than 12 pages and i need to have previous balance generated on every page that is printed. Thnx i hope i ll se this toturial soon....
clear explanation, great. I wish you also have the tutorials for outlook. thank you
thanks for highlighting this function. wondering why you dont use the wizard instead of typing the function in the cell? I find the wizards much easier to follow for complex functions including vlookup, etc.
That's what I've been looking for...Thanks
Excellent example and video tutorial. Thanks
Thanks for the great work, but I think there is a conflict in IFS equation in the place where you put (the cell>58,"D-",the cell57,"D-",the cell
you have really helped me improve my excel skills thanks a lot
Excellent presentation. Smooth stepwise path to the information.
Hi, does microsoft office professional plus 2016 excel have "IFS" function? Is there a way I can add-in the "IFS" function please? thanks.
In your first example, I think you could use =IFERROR(your IFS formula goes here),"") and that would make the cell blank until a score shows up in the grade column. Right?
Thanks!
Thank you for your kind gift. I'm glad you found the video to be helpful.
It seems like there would be a list of supervisors, and then xlookup would be the way to sort the employees.
Essentially a Select Case statement. Like it.
Super presentation. But, I need to ask one question here. Suppose, I have dropdown list of all departments and also in dropdown one common dept for those who are reporting for this, can we not link it to the formula with the dropdown list. I mean Is there a short cut for formula creation with dropdown.
in your big IFS list u should not put B2=0 instead if you follow the logic
wonderful video
Thank you ♥
This will be valuable tomorrow. I'm grading a vocabulary quiz. But if a student writes a wrong answer, but it's almost correct, or spelled wrong, I can add partial points
Thanks for video..
I have a doubt that how i can auto capitalize the first letter in word while typing...
Really clear tutorials, thank you :)
Great explanation!
I have tried the formula IFS today and put several conditions, as you did in this video, but my formula doesn't work, it recognises only the first and the last condition. I have checked and re-checked the formula, everything seems to be alright but still doesn't work. Would you please let me know if there are any common errors that this formula may give? Thank you very much!
that is really helpful , Thanks
RIP Daryl Lopez. F in The chat
You're a star!
Index/Match is probably better suited for the second example for departments and supervisors
Brilliant! Exactly what I was looking for. Thank you! :-)
Hi, does microsoft office professional plus 2016 excel have "IFS" function? Is there a way I can add-in the "IFS" function please? thanks.
I learned a great deal from you, thank you for the amazing videos you make. I have a question. Regarding the IF function, I want to make a survey table for customers of a specific city. All is going great except for one complicated detail. The survey table consists of 3 drop list that are in relation to each other which are (Region, District, Sector) respectively. I have 8 surviers each of them is responsible for a specific district that consists of 10+ sectors that belong to one of the 2 regions in my table, my question is can I use the IF function to minimise the choices of sectors to a specific survier only to his area of interest?
Note 1: Region, District & sectors are names not numbers
Note 2: Regions=2, District=12 Sectors=130
Thank you
Fucking YES. Have been looking for this formula for hours.
very helpful thank you
Is there anyway to force Excel to not interpret text as numerical values? In the second example, is there really no way to make Excel display a customized message if the corresponding value is obviously not a test score?
Something is wrong with the Practice File Link since I can't download it. It just blinks but does not download. Thanks
Can you add word, Excel, and PowerPoint tutorials online? Thanks.
The IFS is not in Excel 2019 why? Is there any way to bring it up? Thanks
Is there a way to use the IFS formula to determine the following if less than 2 hours you get paid $0, 2 hours but less than 6 hours you get paid $18, 6 hours but less than 12 hours you get paid $40, and 12 hours or more you get paid $55.
Hi there, watching your tutorials eagerly already second time. Do u have course for outlook btw? I wish u had..
What if you have tall list of items to type? Do you have to input all in the formula?
The RIGHT() command is not responding inside IF()
For example,
=IF(RIGHT(A2,1)
Ifs(b2="Custodial", "foo" how do I check b2 for case-insensitive?
why in my microsoft office 365 in excel this formula IFS not apply?
I NEED THIS PROJECT FILE BROTHER
Excellent ✔️
The IFS sounds like a great approximation of the CASE or SWITCH statements, something Excel lacked.
can we do this ? like in = if we assign a cell value. its
not working for me . i want to do this becasue my value of = , which i have to print is not a constant value it depend on other values
Nice. Great one.
Thanks for the video. But I have a question, can we e.g. highlight "FAIL" in red and "PASS" in blue for instance?
Yes you can, by using conditional formatting. Here's my video on how to do that: th-cam.com/video/aomParo6vZ0/w-d-xo.html
Instead of typing all the arguments on the formula bar, is it possible if I make an "another" Sheet first and then using the if arguments BASED ON THE SHEET i've make before to determine the value ?
^Sorry for bad english
Yes
very useful I, really impressed
What if managers change? Is it possible to incorporate cell references to maintain integrity with manager changes? Ps I could have used this just today. Thanks!
I'm two years late, but cell references can always be used instead of writing text. It's which ever one you find more convenient or useful.
@skip031890 thanks! I did use cell references on that project, and I'm thinking it will be automated for years to come.
Verry good thank you
Hello can you show me how to link comment cell to other cell ?
Very good info..But I still didn't understand the last one..TRUE ( not within quotes ) & NOT APPLICABLE in quotes...Pls explain...Keep this rolling. God bless you...
The word TRUE is a function that basically says that if all of the previous conditions come up false, then Excel will force whatever comes next to be true. So it's like saying, "If all else fails, then display ____ on the spreadsheet." We put "Not applicable" in quotes because it's text that we want displayed in the spreadsheet for people to see.
@@techteachersandstudents oh...Now i understand...
Hi! I need to name an excell file that works for spaced time repetition. İs that possible?
I want to be able to run .30 to 1 on excel, please how can I do that ?
THANK YOU
Thank you so much! Take care :)
Great, got it. 👍
how can I do this if I only have excel 2016?
Maybe the N/A should be placed in quotation marks.
the formalas you wrote for the grades,its not accepting the formalas
How we can use OR operator with this??
I have a question.
What if I want to highlight the student number red if they received an F?
You could use conditional formatting.
@@techteachersandstudents I've tried and can't get it to highlight.
thanks
Thanks 🌹
"IFS" formula is not in excel 2016?
I am getting Value errors, but all the data is fine. I am using negative number. Any ideas?
Negative numbers, sorry.
ifs function not work in 2016?
ifs function is giving me NAME error in excel 2019
Pretty sure that IFS has been around for a couple of years.
Wow, I used to have a if inside an If inside an if... what a waste
"Lucky people" 🤣😂😂
N/A means not available
its not non applicable
😍😍😍😍
Honestly, this is a bad IFS tutorial. Not that it's not well explained, but in all your examples I would have used a VLOOKUP or a XLOOKUP and it would have been much more efficient, flexible, etc.
Can you add word, Excel, and PowerPoint tutorials online? Thanks.