Excel Nested IF function
ฝัง
- เผยแพร่เมื่อ 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.
Awesome video. Very easy to follow, straight to the point.I appreciate it man!
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 TH-cam & 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
This is super helpful. You have a very easy to follow and thorough teaching style!
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
Fantastically explained, this was so confusing during online class, thanks, man!
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 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. :-)
I found this to be a very thorough and good lesson on If nested functions. Thank you!
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
Still helpful to us in the trenches. Thank you.
You are appreciated by us that benefit from your knowledge.
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
I really appreciate how concise and easy-to-follow you make your instruction. Thank you for keeping it simple.
Please I need excel note
Hi Jalayer!
Thank you very much! you resolved my confusion in nested IF function. PROPS!
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.
Hey dude! This really helped me with my Computing HWK! Thanks ;-)
I’ve been stuck on figuring this out for almost an hour I love you
WOO-HOO!!! that's brought all back really quick. Thank you!!
Praise God! I've watched dozens of videos and yours was the one that clicked. thanks!
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 :)
I LOVED THE WAY YOU ARE TEACHING.
So helpful. I'm gaining on excel in large part thanks to you. Thank you.
I used to always mess up the syntax buh you cleared my confusion. Thank you very much.
You have a very good methodology. This is how they should explain. Great video!
Great video, really helped me with my IGCSE revision, Thanks a lot.
Helped me a lot in biostats class. Thank you!
I have interview with PG&E tomorrow morning for finance analyst positino looks very useful thanks for logic.
Very well explained!
Practice, practice, practice..So inspiring❤
Thank you Ross Geller. That helped me greatly!
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 ...
Thank you so much for explaining this the way you do. It makes it able to understand.
Great tutorials! I'm going to try to watch all of yours
Excellent video. Plain language and to the point
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
Thank You so much!! i had been struggling, but you explained it so well. thank you
This video has been very helpful for me. Makes me not be so afraid of Nested IF's.
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
Excellent example - as usual. Thank you.
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 :-)
Thanks Jalayer I finally understand nested functions
Thank you ... this helped me to figure out nesting my text functions!
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!
glad I could help, thanks for the comment
Explained great. Really helped me with my computing for college and careers high school course.
Thank you ! You Explained it very simply.
Great video on if nesting.
Bang on, just what I needed.
Crazy how this was 10 years ago thank you for the great vid
Completely understood and thanks for the great lesson.
Sir, Thanks a tot. The tutorial is easily understandable.
Love this site! Great tutorial videos.
Great. I think this is just what I'm looking for. Many thanks.
This was helpful. Good clear example, thanks!
You did an awesome tutorial!
I just wanna say thank you i realised the mistake ive been facing for 2 hours now
Freaking awesome just what I was looking for .THanks A LOT !!!!!
Thanks i needed this for school, you saved me!!
Great tutorial, easily understood, thanks
Thank you so much for this great explanation.
Thanks a lot boss it's amazing, it helped me in a typical case.
Another great tutorial, really helpful - thank you :-)
great explanation really well done found it very helpful as a refresher.
Interesting tutorial! Thanks
Thank you so much. You explain this very great!
Very good tutorial, thanks for sharing the knowledge
May God bless you man.
thumbs up!! to the point, precise and nice voice - congrats
Really Good !! Appreciate the efforts !
Thanks dude, you made my life easy!!!!!!!!!!!!!!!!!!!
Great lesson, very useful, Thank you!
This really helped, thanks!
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.
Perfect and very clear. Thank you
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 for a good presentation.
Very easy to follow and only say whats needed to know. Your a natural mate and thank you!
"Stati" is a new one lol, but thanks for the helpful and easy to follow video!
thank you very much for the example and the help
Thank you, this is help me understand a lot.
Good presentation, Thank you from UNDP Engineers.
thanks man i had a test yesterday and i understood it thanks
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.
great job and very nicely explained
Great video
Exceptional! Thank you!
Thanks dude, this saved me today. :)
Thank you so much, you helped me making my college assignment :) Thumbs Up!
You srsly are learning this function in college!!!
I will look into your inquiry and put it on my list of tutorials to come. thanks for the comment.
Great stuff! Please cover present and future value functions.
Very well explained, thanks
Thank you so much for the video!
Excellent tutorial
2012 video helping in 2022 - thank you!!
great explanation !
Thank you clearly taught :)
thank u so much u saved my life
2:08, by far best moment of the video. Epic.
A mans gotta burp when a mans gotta burp lol