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.
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
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 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!
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
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 ...
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.
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.
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!
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
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.
Awesome video. Very easy to follow, straight to the point.I appreciate it man!
Fantastically explained, this was so confusing during online class, thanks, man!
This is a nice straightforward explaination that I've ever have. Thank you man, it helps me on my excel online class very much
Praise God! I've watched dozens of videos and yours was the one that clicked. thanks!
This is super helpful. You have a very easy to follow and thorough teaching style!
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'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 :-)
I LOVED THE WAY YOU ARE TEACHING.
You are very good at explaining things and you always give me confidence to carry on learning. Thank you
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!!!
I really appreciate how concise and easy-to-follow you make your instruction. Thank you for keeping it simple.
Please I need excel note
I found this to be a very thorough and good lesson on If nested functions. Thank you!
I’ve been stuck on figuring this out for almost an hour I love you
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!
2012 video helping in 2022 - thank you!!
Thank you, this is exactly what I needed to help me with an "if" function I was working on.
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
Helped me a lot in biostats class. Thank you!
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
Still helpful to us in the trenches. Thank you.
You are appreciated by us that benefit from your knowledge.
Excellent video. Plain language and to the point
Excellent example - as usual. Thank you.
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 ...
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
Thanks for this video! I understand the nested IF function so much better than my text book was explaining.
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
Hey dude! This really helped me with my Computing HWK! Thanks ;-)
Hi Jalayer!
Thank you very much! you resolved my confusion in nested IF function. PROPS!
Thanks Jalayer I finally understand nested functions
Thank you so much for explaining this the way you do. It makes it able to understand.
You have a very good methodology. This is how they should explain. Great video!
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.
This video has been very helpful for me. Makes me not be so afraid of Nested IF's.
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!!
I will look into your inquiry and put it on my list of tutorials to come. thanks for the comment.
THANK YOU SO MUCH!!!!
I have interview with PG&E tomorrow morning for finance analyst positino looks very useful thanks for logic.
Great tutorials! I'm going to try to watch all of yours
I used to always mess up the syntax buh you cleared my confusion. Thank you very much.
I just wanna say thank you i realised the mistake ive been facing for 2 hours now
Very well explained!
Practice, practice, practice..So inspiring❤
Crazy how this was 10 years ago thank you for the great vid
May God bless you man.
Great video on if nesting.
2:08, by far best moment of the video. Epic.
A mans gotta burp when a mans gotta burp lol
Thank you ! You Explained it very simply.
Great. I think this is just what I'm looking for. Many thanks.
Thank you so much for this great explanation.
Very good tutorial, thanks for sharing the knowledge
Thanks dude, you made my life easy!!!!!!!!!!!!!!!!!!!
What if you had more than two conditions?
Love this site! Great tutorial videos.
Great tutorial, easily understood, thanks
Great video, really helped me with my IGCSE revision, Thanks a lot.
Explained great. Really helped me with my computing for college and careers high school course.
Great stuff! Please cover present and future value functions.
thank you, very clear demo.
great job and very nicely explained
Thanks i needed this for school, you saved me!!
great explanation really well done found it very helpful as a refresher.
Interesting tutorial! Thanks
This was helpful. Good clear example, thanks!
thumbs up!! to the point, precise and nice voice - congrats
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.
Thank you so much, you helped me making my college assignment :) Thumbs Up!
You srsly are learning this function in college!!!
Sir, Thanks a tot. The tutorial is easily understandable.
Thank You!
Thanks dude, this saved me today. :)
Completely understood and thanks for the great lesson.
Bang on, just what I needed.
thanks man i had a test yesterday and i understood it thanks
thank you very much for the example and the help
Thank you, this is help me understand a lot.
2:07 my man straight up burped lmao
I love that it was left in, organic AF hah
Perfect and very clear. Thank you
Really Good !! Appreciate the efforts !
Freaking awesome just what I was looking for .THanks A LOT !!!!!
Very well explained, thanks
Excellent tutorial
Great lesson, very useful, Thank you!
Thank You so much!! i had been struggling, but you explained it so well. thank you
Very easy to follow and only say whats needed to know. Your a natural mate and thank you!
thank u so much u saved my life
"Stati" is a new one lol, but thanks for the helpful and easy to follow video!
Thank you so much. You explain this very great!
Thank you for a good presentation.
Thank you ... this helped me to figure out nesting my text functions!
Thank you so much for the video!
This really helped, thanks!
great explanation !
Excellent presentation
Man, thank you i just solved somthing, that i coul not solve for 4 hours :) =IF(G7=F7*14;10;5))
Thank you clearly taught :)
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!