Excel Nested IF function

  Рет қаралды 691,385

Jalayer Academy

Jalayer Academy

12 жыл бұрын

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/

Пікірлер: 250
@caiomiranda5055
@caiomiranda5055 6 жыл бұрын
Your video was published 5 years ago, and I want you to know that its still being helpful to this very day.
@mohdrozaimiesarani4165
@mohdrozaimiesarani4165 Жыл бұрын
after 5 year i saw your comment
@skhumbuzocele1330
@skhumbuzocele1330 Жыл бұрын
It will be helpful for the next billion years of while there nor major changes in excel.
@ejerejane
@ejerejane 3 ай бұрын
It's 2024, and it just saved me a lot of headache.
@subharthipradhan5987
@subharthipradhan5987 10 күн бұрын
Now I am watching
@childpleaz85
@childpleaz85 7 жыл бұрын
Awesome video. Very easy to follow, straight to the point.I appreciate it man!
@msPee1983
@msPee1983 10 жыл бұрын
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 KZfaq & 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.
@gamingcarnage2700
@gamingcarnage2700 4 жыл бұрын
This is a nice straightforward explaination that I've ever have. Thank you man, it helps me on my excel online class very much
@deanalan23
@deanalan23 4 жыл бұрын
This is super helpful. You have a very easy to follow and thorough teaching style!
@TheJanicetunes
@TheJanicetunes 8 жыл бұрын
Perfect and very clear . you helped me solved my nested if issues. Thank you!!!
@multigenerator5256
@multigenerator5256 3 жыл бұрын
Fantastically explained, this was so confusing during online class, thanks, man!
@maureenlymer9797
@maureenlymer9797 7 жыл бұрын
You are very good at explaining things and you always give me confidence to carry on learning. Thank you
@DSmith-kn9hu
@DSmith-kn9hu 7 жыл бұрын
Thank you, this is exactly what I needed to help me with an "if" function I was working on.
@theresasutherland2380
@theresasutherland2380 8 жыл бұрын
I found this to be a very thorough and good lesson on If nested functions. Thank you!
@unchainedwarriortv
@unchainedwarriortv 10 жыл бұрын
WOO-HOO!!! that's brought all back really quick. Thank you!!
@wimbo6606
@wimbo6606 10 жыл бұрын
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
@beans197
@beans197 5 жыл бұрын
Hey dude! This really helped me with my Computing HWK! Thanks ;-)
@Crrysstal86
@Crrysstal86 10 жыл бұрын
Thanks for this video! I understand the nested IF function so much better than my text book was explaining.
@JayGMoto
@JayGMoto 6 жыл бұрын
Hi Jalayer! Thank you very much! you resolved my confusion in nested IF function. PROPS!
@MollyiXXX
@MollyiXXX 3 жыл бұрын
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. :-)
@traceskimill9584
@traceskimill9584 7 жыл бұрын
Great tutorials! I'm going to try to watch all of yours
@robr9905
@robr9905 4 жыл бұрын
Still helpful to us in the trenches. Thank you. You are appreciated by us that benefit from your knowledge.
@rileyneumann8692
@rileyneumann8692 Жыл бұрын
I’ve been stuck on figuring this out for almost an hour I love you
@angelicanarboneta4462
@angelicanarboneta4462 Жыл бұрын
Very well explained! Practice, practice, practice..So inspiring❤
@user-dv7mx8bo4v
@user-dv7mx8bo4v 5 жыл бұрын
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.
@rdjalayer
@rdjalayer 11 жыл бұрын
I will look into your inquiry and put it on my list of tutorials to come. thanks for the comment.
@nicklj3025
@nicklj3025 8 жыл бұрын
Thank You so much!! i had been struggling, but you explained it so well. thank you
@johnq3543
@johnq3543 6 жыл бұрын
So helpful. I'm gaining on excel in large part thanks to you. Thank you.
@Akholicist
@Akholicist 8 жыл бұрын
Great video, really helped me with my IGCSE revision, Thanks a lot.
@venkatcgvenkat
@venkatcgvenkat 8 жыл бұрын
I LOVED THE WAY YOU ARE TEACHING.
@MichaelHamlin76
@MichaelHamlin76 8 жыл бұрын
Thank you Ross Geller. That helped me greatly!
@Veroniqueme
@Veroniqueme 8 жыл бұрын
You have a very good methodology. This is how they should explain. Great video!
@PatsUnmadeBed
@PatsUnmadeBed 8 жыл бұрын
I'm a retired teacher. Great job! Great presentation. Thanks
@rdjalayer
@rdjalayer 8 жыл бұрын
+Patrick Manders Thank you very much for your kind words. It means a lot coming from a teacher.
@cammigoldberg4910
@cammigoldberg4910 8 жыл бұрын
+Jalayer Academy i need some help with a simple formula
@shaunphagoo1715
@shaunphagoo1715 8 жыл бұрын
+Jalayer Academy thanks alot this helped alot i finaly understand nested if
@thaisferreira9168
@thaisferreira9168 7 жыл бұрын
Same here!!! Super clear and simple explanation :-)
@julistar90
@julistar90 9 жыл бұрын
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
@MichaelOnRockyTop
@MichaelOnRockyTop Жыл бұрын
Thank you so much for explaining this the way you do. It makes it able to understand.
@AlmightyRice
@AlmightyRice 6 жыл бұрын
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 (<a href="#" class="seekto" data-time="406">6:46</a>) 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 :)
@kefyalewf
@kefyalewf 8 жыл бұрын
Love this site! Great tutorial videos.
@albundyinc2
@albundyinc2 8 жыл бұрын
Thank you ... this helped me to figure out nesting my text functions!
@oa1197
@oa1197 5 жыл бұрын
I used to always mess up the syntax buh you cleared my confusion. Thank you very much.
@zainababbasi5607
@zainababbasi5607 2 жыл бұрын
Thank you so much for this great explanation.
@terinabingham778
@terinabingham778 5 жыл бұрын
You did an awesome tutorial!
@pauls7056
@pauls7056 10 жыл бұрын
Great. I think this is just what I'm looking for. Many thanks.
@JaceCheong1119
@JaceCheong1119 9 жыл бұрын
Completely understood and thanks for the great lesson.
@rabiuharuna9604
@rabiuharuna9604 3 жыл бұрын
Very good tutorial, thanks for sharing the knowledge
@banjobanjington2344
@banjobanjington2344 3 жыл бұрын
Helped me a lot in biostats class. Thank you!
@pholderholder5196
@pholderholder5196 5 жыл бұрын
Excellent video. Plain language and to the point
@tanzaniteboonewzealand2188
@tanzaniteboonewzealand2188 7 жыл бұрын
Thanks Jalayer I finally understand nested functions
@BigHappyMonkey
@BigHappyMonkey 7 жыл бұрын
Praise God! I've watched dozens of videos and yours was the one that clicked. thanks!
@faisalbalouch1980
@faisalbalouch1980 Жыл бұрын
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
@darthzane2156
@darthzane2156 5 жыл бұрын
Freaking awesome just what I was looking for .THanks A LOT !!!!!
@yulbravo1676
@yulbravo1676 2 жыл бұрын
Crazy how this was 10 years ago thank you for the great vid
@Pinza7
@Pinza7 6 жыл бұрын
Bang on, just what I needed.
@alisond7395
@alisond7395 9 жыл бұрын
Another great tutorial, really helpful - thank you :-)
@walkeyboy1
@walkeyboy1 6 жыл бұрын
Great tutorial, easily understood, thanks
@karthiknarayananravi
@karthiknarayananravi 7 жыл бұрын
Thank you ! You Explained it very simply.
@evertphillipbruwer4219
@evertphillipbruwer4219 6 жыл бұрын
thank you very much for the example and the help
@cosmic-fortytwo
@cosmic-fortytwo 4 жыл бұрын
This was helpful. Good clear example, thanks!
@avyas150
@avyas150 6 жыл бұрын
Really Good !! Appreciate the efforts !
@rdjalayer
@rdjalayer 10 жыл бұрын
glad I could help, thanks for the comment
@deaklundlee
@deaklundlee 6 жыл бұрын
I really appreciate how concise and easy-to-follow you make your instruction. Thank you for keeping it simple.
@soibiboalalibo
@soibiboalalibo 11 ай бұрын
Please I need excel note
@ddp2049
@ddp2049 10 жыл бұрын
Great video on if nesting.
@ndubuisimachebe764
@ndubuisimachebe764 9 жыл бұрын
Interesting tutorial! Thanks
@wordsstrokes1667
@wordsstrokes1667 6 жыл бұрын
Thanks a lot boss it's amazing, it helped me in a typical case.
@maureenlymer9797
@maureenlymer9797 9 жыл бұрын
Excellent example - as usual. Thank you.
@bribbri3697
@bribbri3697 4 жыл бұрын
This really helped, thanks!
@LarsCarre
@LarsCarre 9 жыл бұрын
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!
@ChuyenNenLam
@ChuyenNenLam 2 жыл бұрын
Thank you, this is help me understand a lot.
@mehulmittal01
@mehulmittal01 7 жыл бұрын
great job and very nicely explained
@AgesOfAgony
@AgesOfAgony Жыл бұрын
Thank you so much for the video!
@bennysebastian5316
@bennysebastian5316 8 жыл бұрын
Sir, Thanks a tot. The tutorial is easily understandable.
@qpham
@qpham 10 жыл бұрын
Thank you so much. You explain this very great!
@carlosalfonso7504
@carlosalfonso7504 6 жыл бұрын
Great lesson, very useful, Thank you!
@hammadyounus8720
@hammadyounus8720 8 жыл бұрын
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 ...
@rookiesuy9254
@rookiesuy9254 7 жыл бұрын
Thanks i needed this for school, you saved me!!
@sajanlal9397
@sajanlal9397 9 жыл бұрын
Thanks dude, you made my life easy!!!!!!!!!!!!!!!!!!!
@sjt4976
@sjt4976 4 ай бұрын
Thanks dude, this saved me today. :)
@roywit7836
@roywit7836 3 жыл бұрын
Thank you clearly taught :)
@ilyas3816
@ilyas3816 5 жыл бұрын
Very well explained, thanks
@dylanchacon3740
@dylanchacon3740 4 жыл бұрын
Explained great. Really helped me with my computing for college and careers high school course.
@sunandamaggo2900
@sunandamaggo2900 7 жыл бұрын
great explanation !
@tiawaite2920
@tiawaite2920 7 жыл бұрын
thumbs up!! to the point, precise and nice voice - congrats
@danicequeabeah7856
@danicequeabeah7856 9 жыл бұрын
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
@mrbean4982
@mrbean4982 7 жыл бұрын
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
@monit2354
@monit2354 7 жыл бұрын
use count
@mrbean4982
@mrbean4982 7 жыл бұрын
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
@jamestorres2815
@jamestorres2815 8 жыл бұрын
Perfect and very clear. Thank you
@bilkishvazifdar1706
@bilkishvazifdar1706 8 жыл бұрын
Thank you for a good presentation.
@josemartinruiz1956
@josemartinruiz1956 8 жыл бұрын
I have interview with PG&E tomorrow morning for finance analyst positino looks very useful thanks for logic.
@janoos24
@janoos24 3 жыл бұрын
great explanation really well done found it very helpful as a refresher.
@johnpanik7511
@johnpanik7511 Жыл бұрын
Excellent tutorial
@mohammedal-ammari3884
@mohammedal-ammari3884 10 жыл бұрын
thanks man i had a test yesterday and i understood it thanks
@asantephilip6014
@asantephilip6014 6 жыл бұрын
May God bless you man.
@vijayaf
@vijayaf 7 жыл бұрын
This video has been very helpful for me. Makes me not be so afraid of Nested IF's.
@Liberty-Grunt
@Liberty-Grunt 8 жыл бұрын
Exceptional! Thank you!
@lizzy135
@lizzy135 10 жыл бұрын
Great video
@suviunelma
@suviunelma 4 жыл бұрын
Very easy to follow and only say whats needed to know. Your a natural mate and thank you!
@trustyhvh
@trustyhvh 11 жыл бұрын
Great stuff! Please cover present and future value functions.
@uuput
@uuput 12 жыл бұрын
thank you so much.. and the explanation was great!! ^^,
@leika601
@leika601 3 жыл бұрын
I just wanna say thank you i realised the mistake ive been facing for 2 hours now
@Rixspawn1106
@Rixspawn1106 7 жыл бұрын
FANTASTIC THANK YOU
@mahindesilva4321
@mahindesilva4321 7 жыл бұрын
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?
@briyarbahaddin6988
@briyarbahaddin6988 5 жыл бұрын
Good presentation, Thank you from UNDP Engineers.
@waltersono2742
@waltersono2742 10 жыл бұрын
Thanks...Really helpful
@CecilEtienne
@CecilEtienne 8 жыл бұрын
Excellent presentation
@prasadprasad-lf5ee
@prasadprasad-lf5ee 7 жыл бұрын
Thank u give such a good teach
@icecream6680
@icecream6680 2 жыл бұрын
thank u so much u saved my life
@rajendrankv2481
@rajendrankv2481 4 жыл бұрын
THANK YOU SO MUCH!!!!
Excel Pivot Table
9:07
Jalayer Academy
Рет қаралды 14 М.
MS Excel | Nested IF Statements
9:07
Mr Long Education - IT & CAT
Рет қаралды 62 М.
I CAN’T BELIEVE I LOST 😱
00:46
Topper Guild
Рет қаралды 108 МЛН
DO YOU HAVE FRIENDS LIKE THIS?
00:17
dednahype
Рет қаралды 93 МЛН
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
00:17
OKUNJATA
Рет қаралды 21 МЛН
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 388 М.
Excel Nested AND function
8:06
Jalayer Academy
Рет қаралды 33 М.
Excel Logical Functions - IF, AND, OR
8:05
Yoda Learning Academy
Рет қаралды 159 М.
4 Fantastic Alternatives to Nested IF Formulas
12:33
Computergaga
Рет қаралды 81 М.
How to Use the IFS Function in Excel
11:01
Leila Gharani
Рет қаралды 340 М.
MS Excel - Nested IF
2:39
Tutorialspoint
Рет қаралды 614 М.
Excel If Formula - Nested If AND OR Functions
20:30
The Organic Chemistry Tutor
Рет қаралды 482 М.
I CAN’T BELIEVE I LOST 😱
00:46
Topper Guild
Рет қаралды 108 МЛН