Excel Nested IF function
HTML-код
- Опубликовано: 17 янв 2012
- In this tutorial we learn when it is appropriate to use a nested IF function and how to execute one. If you are not familiar with regular IF function check out my introduction to IF function video linked here • Excel IF function
For SQL practice, you can go to www.stratascratch.com. They have over 500 SQL exercises and interview questions from real companies.
Their platform is free but you can use discount code jalayer for 15% off their premium features at platform.stratascratch.com/
Your video was published 5 years ago, and I want you to know that its still being helpful to this very day.
after 5 year i saw your comment
It will be helpful for the next billion years of while there nor major changes in excel.
It's 2024, and it just saved me a lot of headache.
Now I am watching
I will look into your inquiry and put it on my list of tutorials to come. thanks for the comment.
DUUUUUDEE!! You are God-sent. I have spent the last 12 hours trying to create a nested IF function for an assignment I have. I have watched numerous vids here on RUclips & still couldn't figure it out so you can imagine how dumb I felt. Thank you, thank you, thank you - so well explained & so easy to understand.
This is a nice straightforward explaination that I've ever have. Thank you man, it helps me on my excel online class very much
Awesome video. Very easy to follow, straight to the point.I appreciate it man!
This is super helpful. You have a very easy to follow and thorough teaching style!
Thanks for the video. I've selftaught my way already to this point, but it really is important to grasp the small and important details by following videos like these.
In practice, i probably wouldve tripped after making the second last parenthesis (6:46) and closing the nested function. The program would then ask you to enter a value when it's "WRONG" (for the first if-function, outside the nested one) and i'd probably think of entering "space available" again, before ending the whole formula with another parenthesis.
I make my formulas unnecessarily too long because of this :)
Perfect and very clear . you helped me solved my nested if issues. Thank you!!!
You are very good at explaining things and you always give me confidence to carry on learning. Thank you
I went through various other videos but delighted I found this one coz its the best one to fully explain a nested If function. Will check out other vids on the channel. :-)
Amazing - I've just started a new job and these things are used every day and this has helped me so much - Thank you x
Thank you, this is exactly what I needed to help me with an "if" function I was working on.
Thanks for this video! I understand the nested IF function so much better than my text book was explaining.
I found this to be a very thorough and good lesson on If nested functions. Thank you!
Fantastically explained, this was so confusing during online class, thanks, man!
Thank you so much for making this video. I have a test tomorrow and my professor doesn't explain things well. Your explanation is clear and straight to the point. I learn more from you than my professor. Thank you again
oh my gosh, you are my god. I had no idea for tmr's ICT assessment and you just helped me. you explained easier than my ict teacher.
glad I could help, thanks for the comment
Hi Jalayer!
Thank you very much! you resolved my confusion in nested IF function. PROPS!
Still helpful to us in the trenches. Thank you.
You are appreciated by us that benefit from your knowledge.
I used to always mess up the syntax buh you cleared my confusion. Thank you very much.
I have interview with PG&E tomorrow morning for finance analyst positino looks very useful thanks for logic.
Great tutorial! Thanks a million.
With more practice, I have arrived at this fomula to specify how many seats available.
=IF(M16=N16,"Flight Full",IF(M16
Danice Queabeah hey mate! i know this is sooo long ago but can you help me get the SUM of the available seats? i mean by not using the common + sign.. it gets zero if use the SUM command. thanks
use count
Møñît Thåkûr I've tried it before as well but the count result is equal to zero. can you help me on this problem? thanks
I am not comitting YOU solved my problem, but you were a great help with this function "=SUM(IF(J5="YES",I5),IF(J6="YES",I6),IF(J7="YES",I7),IF(J8="YES",I8),IF(J9="YES",I9))" What this does is, it sums every value which is called YES in another field (Like when a payment has been received) Thanks for the little step you gave me, it came in handy to remind me to this. Any ways, i might say you did help me ;). Good video keep it up!
Hey dude! This really helped me with my Computing HWK! Thanks ;-)
I'm a retired teacher.
Great job! Great presentation.
Thanks
+Patrick Manders Thank you very much for your kind words. It means a lot coming from a teacher.
+Jalayer Academy i need some help with a simple formula
+Jalayer Academy thanks alot this helped alot i finaly understand nested if
Same here!!! Super clear and simple explanation :-)
Praise God! I've watched dozens of videos and yours was the one that clicked. thanks!
Thnks alot bro !! .. U really helped me very much !.. U r the best teacher of ICT practicals in youtube ... your explanation is awesome , easy to understand , not fast , not slow .. perfect !... tommrow is my IGCSE exam ...
Great video, really helped me with my IGCSE revision, Thanks a lot.
I’ve been stuck on figuring this out for almost an hour I love you
So helpful. I'm gaining on excel in large part thanks to you. Thank you.
WOO-HOO!!! that's brought all back really quick. Thank you!!
You have a very good methodology. This is how they should explain. Great video!
Great tutorials! I'm going to try to watch all of yours
Thank You so much!! i had been struggling, but you explained it so well. thank you
I really appreciate how concise and easy-to-follow you make your instruction. Thank you for keeping it simple.
Please I need excel note
though i am straight but i love you man. i ve been struggling with an excel prob for days just your video and its done. thanx man
Very well explained!
Practice, practice, practice..So inspiring❤
Great presentation thank you. I would like to know how to use the if function for a column of data with certain values and blanks. Example; if I have dates and no dates in a column, how could I use the if function to show the blanks?
Thank you ... this helped me to figure out nesting my text functions!
Helped me a lot in biostats class. Thank you!
Thank you so much for explaining this the way you do. It makes it able to understand.
Explained great. Really helped me with my computing for college and careers high school course.
I LOVED THE WAY YOU ARE TEACHING.
Thank you Ross Geller. That helped me greatly!
Excellent video. Plain language and to the point
This video has been very helpful for me. Makes me not be so afraid of Nested IF's.
I just wanna say thank you i realised the mistake ive been facing for 2 hours now
Completely understood and thanks for the great lesson.
Thanks a lot boss it's amazing, it helped me in a typical case.
Thank you ! You Explained it very simply.
Another great tutorial, really helpful - thank you :-)
Excellent example - as usual. Thank you.
Thank you so much for this great explanation.
Sir, Thanks a tot. The tutorial is easily understandable.
Love this site! Great tutorial videos.
Great video on if nesting.
thank you very much for the example and the help
Freaking awesome just what I was looking for .THanks A LOT !!!!!
Thank you so much. You explain this very great!
You are very thorough and straight forward. Thanks, Please, can you do one for a holiday, payment, to show payment, balance, due amount, and fully paid.
Thanks Jalayer I finally understand nested functions
Thank you for your video. Is there a way to use "isblank" function with the sumifs function? My goal is to only display a value with the sumifs function if the value is greater than zero, if not then the cell would be blank.
Bang on, just what I needed.
Crazy how this was 10 years ago thank you for the great vid
This was helpful. Good clear example, thanks!
great explanation really well done found it very helpful as a refresher.
thumbs up!! to the point, precise and nice voice - congrats
Great. I think this is just what I'm looking for. Many thanks.
Interesting tutorial! Thanks
Thanks i needed this for school, you saved me!!
will consider, thanks
Very easy to follow and only say whats needed to know. Your a natural mate and thank you!
Thank you so much for the video!
Great tutorial, easily understood, thanks
this video is very helpful, but in some new Versions of Excel, mein is 365, you have to write a semi colon instead of just a colon.
Very good tutorial, thanks for sharing the knowledge
You did an awesome tutorial!
Great lesson, very useful, Thank you!
Is it possible to introduce another function which will then tell you how many +/- seats are overbooked/available? (this being in addition to providing the information through the nestedif function you used above)
Would be extremely helpful!
Thank you!
Really Good !! Appreciate the efforts !
Thank you, this is help me understand a lot.
Our Professor assigned you for our pandemic distance learning. You are amazingly clear and very well thought out example with clear easy to follow step by step explanations.
Thank you so very much. I am very grateful to you.Best wishes always.
I found this to be true too.
Great stuff! Please cover present and future value functions.
Thank you for a good presentation.
Perfect and very clear. Thank you
"Stati" is a new one lol, but thanks for the helpful and easy to follow video!
Hey Jalayer. I have a question.. For example i use the function "IF" like this: =IF(A2=B2; B4; C4)… If its true, then it will appear the content of the cell B4.. However, when i want to appear the content of the cell with its special formatting, what can i do for this??
For example, if there is a thick outline out of the cell, i want to appear the content of the cell with the thick outline...
You will help me a lot!
Exceptional! Thank you!
May God bless you man.
This really helped, thanks!
Good presentation, Thank you from UNDP Engineers.
Thanks dude, you made my life easy!!!!!!!!!!!!!!!!!!!
Thanks dude, this saved me today. :)
great job and very nicely explained
Thank you clearly taught :)
Can you do a presentationon ranking employees with different criterias as a full-time employee and part-time employee and a difference of them being hired on the same date. I greatly appreciate it.
thanks for your tutorial.
I have a question, i want to find out the flight number form your given sheet. For example, "space available" in number "08" flight. Give the answer. In which "08" flight ?
This is so beneficial, could you please include nested if fxns in a bills checklist, thanks.
2012 video helping in 2022 - thank you!!