Nested If Function in Excel : How to write If Function with multiple conditions

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 พ.ย. 2024

ความคิดเห็น • 229

  • @BL25x
    @BL25x 4 ปีที่แล้ว +16

    This dude literally just saved my grade so hard. I messed this up every week, but on the final exam I got this right, thanks to this guy!

  • @onmigaming
    @onmigaming 2 ปีที่แล้ว +3

    Journey Finished after 3 hours of Research, thank you so much.

  • @zamancvasu9402
    @zamancvasu9402 4 ปีที่แล้ว +2

    Finally your video has solved by problem. Thank you for your great job.

  • @ashutoshomshankar553
    @ashutoshomshankar553 3 ปีที่แล้ว +3

    This is simply brilliant, explained in such a simple manner. I was able to implement this on a multiple choice questions scoring in xls in no time.

  • @superchumaster
    @superchumaster 4 ปีที่แล้ว +2

    The perfect information in less than 5 minutes. Legend!

  • @theFinancialguru0768
    @theFinancialguru0768 4 ปีที่แล้ว +1

    Finally I found this video to help me write multiple if statements. Thanks, it helped me solve my problem!

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi 4 ปีที่แล้ว +2

    There is nice example to teach with multiple condition thanks a lot dear

  • @Jamieishere1
    @Jamieishere1 7 ปีที่แล้ว +66

    Universal rule for all excel tutorials: the audio must always be too quiet for normal speaker volume.

    • @unclespicy3318
      @unclespicy3318 4 ปีที่แล้ว +3

      that and someone with an accent too thick to understand

    • @Lucifer_Summons
      @Lucifer_Summons 3 ปีที่แล้ว +5

      @@unclespicy3318 i can understand him just fine tbh no problems

  • @GrunenTeufel
    @GrunenTeufel 5 ปีที่แล้ว +1

    Thanks for addressing what no one else would!

  • @atiq-ur-rehmanmuhammad3259
    @atiq-ur-rehmanmuhammad3259 4 ปีที่แล้ว +1

    Excellent .............. I am grateful for such a simple and short solution

  • @louisbaileyjr3860
    @louisbaileyjr3860 5 ปีที่แล้ว +1

    This video is well put together. I have viewed others and no results. THANK YOU VERY MUCH!!

  • @TheDjmathe
    @TheDjmathe 8 ปีที่แล้ว +2

    Thank you very much! i needed to help my manager with an excel spreadsheet at work. im new there and my excel skills are a bit laggy since we moved away from the spreadsheet models in my IT course. obviously everyone looked at me for help and i said yes haha (im a newbie at my place of work and i want to seem helpful).
    but thanks again and best of luck!

    • @tayyabcaisslc5893
      @tayyabcaisslc5893 5 ปีที่แล้ว +1

      Taiyyab gmail com email 👨‍💻💼👨‍🎓👔👖👞🕶💴💴💴💶💶💶💵💵💵

  • @TheKt75
    @TheKt75 5 ปีที่แล้ว +2

    Lego or not, thanks for helping me with a problem i was trying to solve on my own for 1 hour!

  • @miriabirunji6273
    @miriabirunji6273 3 ปีที่แล้ว +1

    Thank you so much, this has made work a lot easier for me. Thx again.

  • @MRDABATOS_MRDOVE02
    @MRDABATOS_MRDOVE02 6 ปีที่แล้ว +1

    finally i found this video.. it helped me to solve my problem.... God Bless

  • @enfisya
    @enfisya 5 ปีที่แล้ว +1

    Thank you so much! I've spent about 3 hours searching for the solution you showed in your video. Thank you!

  • @jaycassie
    @jaycassie 4 ปีที่แล้ว +3

    Thank you, finally for the past 12 hourly.

  • @fasilzpv
    @fasilzpv 4 ปีที่แล้ว +2

    😍
    Thanx Bro...
    U Explained All If and, AND Functions within 5 minutes without lagging....
    I've not studied Excel more, so i didn't knew to add Multiple Cells, and multiple functions... This solved all my doubt😊

  • @Really_Brooks
    @Really_Brooks 2 ปีที่แล้ว +1

    Simple and easy to understand. Thank You!

  • @Pv488
    @Pv488 7 ปีที่แล้ว +2

    Great video man. You made me realize where I was going wrong in my three line long formula and will make adjustments thanks to your explanation. Thanks !

    • @ExcelDestination
      @ExcelDestination  7 ปีที่แล้ว +1

      Thanks for your comment! I am glad, I could help you!

  • @22Scrimp
    @22Scrimp 6 ปีที่แล้ว +3

    No other searches mentioned the 'and' command - this is perfect-Thanks!

  • @zhiying8706
    @zhiying8706 3 ปีที่แล้ว +1

    been stuck for a long time but this video SAVED MY ASS THANK YOU SO MUCH!!!

  • @foysalmahmud3975
    @foysalmahmud3975 4 ปีที่แล้ว +1

    Which i was searching for. thanks man.

  • @pamelaremandaban73
    @pamelaremandaban73 4 ปีที่แล้ว

    Thank youuuuuuu so much! I wish I could have seen this before our exam. This is exactly what I'm looking for

  • @abhishekkathawala
    @abhishekkathawala 4 ปีที่แล้ว +1

    Thanks Bro This is exactly what I'm looking for

  • @danscornerofyoutube
    @danscornerofyoutube 5 ปีที่แล้ว +5

    So that's why my nested ifs would work. Really helpful video man! Thanks!
    *side note tho, the sound is kinda annoying with the keyboard tapping and all that, you might wanna bring it down a notch or two.

  • @Revulsion100
    @Revulsion100 5 ปีที่แล้ว +7

    Oh Wow! Thank you sooooo much for posting this. It's EXACTLY what I needed right now. You legend!

  • @elmera.latorre9875
    @elmera.latorre9875 4 ปีที่แล้ว +1

    Thank you so much for this!!!!! Very good practice. 🍾

  • @easify_
    @easify_ 3 ปีที่แล้ว +1

    Waw Finally problem Solved , Thanks you are a Legend !

  • @sanatanimanish
    @sanatanimanish 4 ปีที่แล้ว +1

    Thanks for sharing this tutorial with good example

  • @ihsansaleheen6672
    @ihsansaleheen6672 3 ปีที่แล้ว +1

    This is so helpful. Thank you very much.

  • @patrickivanlopinac7974
    @patrickivanlopinac7974 ปีที่แล้ว +1

    Thank you, this tutorial helps me a lot

  • @SantoshKumar-do9qb
    @SantoshKumar-do9qb 5 ปีที่แล้ว +1

    it's a really nice video & it gives clear information to learners to understand the formula easily. thank you very much ..

  • @Jvedder320
    @Jvedder320 4 ปีที่แล้ว +3

    Exactly what I was looking for! Thank you!

  • @ektasingh3730
    @ektasingh3730 6 ปีที่แล้ว

    I DONT NEED GOOD AUDIO COZ I CAN SEE IT ..AND I GOT IT AND Y PROBLEM SOLVED..THANKU SO MUCH

    • @ExcelDestination
      @ExcelDestination  6 ปีที่แล้ว

      Thanks for your nice comment!

    • @ExcelDestination
      @ExcelDestination  6 ปีที่แล้ว

      for any excel OR vba question write to EXCELDESTINATION@GMAIL.COM...

  • @demise187
    @demise187 4 ปีที่แล้ว +4

    This was very helpful, thank you so much!

  • @Shafiudding
    @Shafiudding 5 ปีที่แล้ว +1

    Thanks brother for your tips, It is really helpful

  • @dmitryandreew8582
    @dmitryandreew8582 3 ปีที่แล้ว +1

    thank you so much. very useful.

  • @sudheendragaonkar6791
    @sudheendragaonkar6791 4 ปีที่แล้ว +1

    Thank you for the tutorial 👍

  • @HAREEFINFO
    @HAREEFINFO ปีที่แล้ว +1

    Thank You. I figured it what was my mistake.

  • @Pro-Tips-Tricks
    @Pro-Tips-Tricks 4 ปีที่แล้ว +1

    Big Thank you for You respected sir...............

  • @undrambolor3020
    @undrambolor3020 2 ปีที่แล้ว +1

    thank you so much, it helped me a lot

  • @karinal.dasilva1462
    @karinal.dasilva1462 4 ปีที่แล้ว +1

    Thanks for sharing! This helped me so much!

  • @dashcharivamaraa4352
    @dashcharivamaraa4352 3 ปีที่แล้ว +1

    Great Job!

  • @andersonm9089
    @andersonm9089 4 ปีที่แล้ว +1

    You are a savior!!!

  • @SanthoshKumar-xy3zm
    @SanthoshKumar-xy3zm 3 ปีที่แล้ว +1

    Well explained bro....Thank you

  • @SunTzuBeanz
    @SunTzuBeanz 2 ปีที่แล้ว +1

    The sounds in the background. Yeeesh. Good content tho 😀

  • @harryporterdigitalservices-r4m
    @harryporterdigitalservices-r4m 3 ปีที่แล้ว +1

    Great one!
    Thank you!

  • @funarmy383
    @funarmy383 3 ปีที่แล้ว +1

    Thanks a lot man!

  • @Miss_smiling_brunette
    @Miss_smiling_brunette 2 ปีที่แล้ว +1

    Very helpful for treatment of data

  • @Teesriflight
    @Teesriflight 2 ปีที่แล้ว +1

    Thank you brother :)

  • @Pankaj-Verma-
    @Pankaj-Verma- 3 ปีที่แล้ว +1

    Thank you, again!

  • @Munnaprasad
    @Munnaprasad 8 ปีที่แล้ว

    straight and simple. very useful, thank you

  • @Georgyxp
    @Georgyxp 3 ปีที่แล้ว +1

    Thank you much for this

  • @wasmodahod1630
    @wasmodahod1630 3 ปีที่แล้ว +1

    very useful ...keep it up....👍👍👍👍👍

  • @GuardianApe
    @GuardianApe 3 ปีที่แล้ว +2

    Tutorial was really good. But I have a question . Is there a way you can add two outputs together to have another output? Like medium + high . How would you write that ?

  • @talatraja8444
    @talatraja8444 4 ปีที่แล้ว +1

    Very much helpful. Thanks

  • @Mr1sammyd21
    @Mr1sammyd21 7 ปีที่แล้ว +63

    is your keyboard made from legos?

    • @3manimaniac
      @3manimaniac 7 ปีที่แล้ว +1

      I also thought of that.

    • @sakewar
      @sakewar 5 ปีที่แล้ว

      :)

    • @AmberAmbwee
      @AmberAmbwee 5 ปีที่แล้ว +1

      Lol. It sounds like he has a mechanical keyboard. I like them. It’s like the difference between weighted and non weighted keys on a piano keyboard.

    • @abbasshah6464
      @abbasshah6464 4 ปีที่แล้ว +1

      what is legos

    • @khalifx_8433
      @khalifx_8433 3 ปีที่แล้ว

      @@abbasshah6464 tf

  • @GAURAVSHRIMALI
    @GAURAVSHRIMALI 5 ปีที่แล้ว +1

    Thanks Love your Work

  • @edgartunon7826
    @edgartunon7826 4 ปีที่แล้ว +1

    thank you so much for this lesson

  • @mrkthmn
    @mrkthmn 7 ปีที่แล้ว +1

    This is exactly what I needed! THANKS!

  • @aishaali6050
    @aishaali6050 3 ปีที่แล้ว +1

    Thank you so much !

  • @anthonylobello5365
    @anthonylobello5365 4 ปีที่แล้ว +1

    This is excellent. Thank you. Do you how I can use vba (without the autofilter) to delete rows that have a cell in column A with a blank OR a date (any date in it)? Thank you.

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว

      you can take help from following tutorial :
      th-cam.com/video/IoPvnbfo1i4/w-d-xo.html

  • @Shang_Chii
    @Shang_Chii 5 ปีที่แล้ว +1

    Thank you so much dear, u made my day. ❤️😊

  • @dmsmemoir4584
    @dmsmemoir4584 7 ปีที่แล้ว

    Thank you very much! it helped me do my assignment!

  • @mycreation8594
    @mycreation8594 5 ปีที่แล้ว

    I forget this formula, thanks for remain again.

  • @shamkhal.abdullayev2452
    @shamkhal.abdullayev2452 6 ปีที่แล้ว

    Perfect, thanks a lot for such helpful video.

  • @sourajitsaha3893
    @sourajitsaha3893 4 ปีที่แล้ว +1

    Thank you very much 🙏

  • @akproduction2294
    @akproduction2294 2 ปีที่แล้ว +1

    Thank you sir 👍🏻👍🏻👍🏻👍🏻

  • @prashanth2776
    @prashanth2776 3 ปีที่แล้ว +1

    Thank you bro 🙂🙂🙂

  • @ismailghofur46
    @ismailghofur46 2 ปีที่แล้ว

    Sorry newbie here, are "AND" really used on those case? I tried with
    =if(C3

  • @GNAPIKASSTEPS
    @GNAPIKASSTEPS 7 ปีที่แล้ว

    Super, Nicely explained ! Thanks

  • @stanboxa
    @stanboxa 5 ปีที่แล้ว +1

    very helpful, thank you sir

  • @Aahaya
    @Aahaya 6 ปีที่แล้ว

    Thank you, this is was sooooo helpful.

  • @spbeinglove
    @spbeinglove 2 ปีที่แล้ว +1

    Thank you dear❤️❤️❤️

  • @Pankaj-Verma-
    @Pankaj-Verma- 5 ปีที่แล้ว

    Thank you so much for your kind help~

  • @stalinm1950
    @stalinm1950 4 ปีที่แล้ว +1

    Thanks..Helpful

  • @maclagor2465
    @maclagor2465 7 ปีที่แล้ว +1

    Great video and very helpful - thanks!

  • @ryanarmstrong845
    @ryanarmstrong845 9 ปีที่แล้ว +1

    Great Video! Thanks for positing.

  • @vishnushashidharan6030
    @vishnushashidharan6030 4 ปีที่แล้ว +1

    if we don't use "and " in the nested if function do we get the same result ? or is it different

  • @daniellapcosta
    @daniellapcosta 7 ปีที่แล้ว

    Your video saved my life HAHAHHA. Thank you.

  • @jeetsingh7708
    @jeetsingh7708 7 ปีที่แล้ว

    Thank you really enjoyed your formula

  • @joycemaday-a746
    @joycemaday-a746 3 ปีที่แล้ว +1

    Thank you!

  • @vedantpatel6907
    @vedantpatel6907 4 ปีที่แล้ว +1

    I want to choose multiple cells for just 1 condtiton.. How to do it??? I am a learner

  • @shiwalisharma8669
    @shiwalisharma8669 4 ปีที่แล้ว +1

    Thank you so much

  • @hichamalaoui34
    @hichamalaoui34 5 ปีที่แล้ว

    Thanks so much for this video.

  • @MadhanKumar-pn1fi
    @MadhanKumar-pn1fi 4 ปีที่แล้ว +1

    Can we also included the vlookup function ?

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว

      yes

    • @MadhanKumar-pn1fi
      @MadhanKumar-pn1fi 4 ปีที่แล้ว

      @@ExcelDestination ok thanks... Is there any example videos of that, so that I can refer that... Pls share me that link of we have. Thanks for your help

  • @darren2456
    @darren2456 6 ปีที่แล้ว

    a nice formula, not sure about the ands, if you record a nice quality video plus explain more about why you are doing your formula like that

  • @emema7730
    @emema7730 5 ปีที่แล้ว

    Could you show a formula that includes a column for a "role" category like if the person is either a clerk, an agent, or a lead. Each role would have a different range. So let's say for example the added Role column shows the person worked as a clerk, and we use these ranges as examples - their Low range would be Less than or equal to 1000, their medium range would be more than 1000 and less than or equal to 4000, their High range would be more than 4000 and less than 9000, and their Top Level would be more than 9000. and another person worked as a lead so their ranges would be Low range less than or equal to 3000, their medium range would be more than 3000 and less than or equal to 6000, their High range would be more than 6000 and less than 11000, and their Top Level would be more than 11000.

    • @ExcelDestination
      @ExcelDestination  5 ปีที่แล้ว

      send me your file and question with some dummy data. I will provide the formula

    • @emema7730
      @emema7730 5 ปีที่แล้ว

      Thanks, I sent my sample rating sheet to you via email.

    • @ExcelDestination
      @ExcelDestination  5 ปีที่แล้ว

      i will check and respond

  • @babam5792
    @babam5792 4 ปีที่แล้ว +1

    Hi. I have 5 criteria for ratings for employees and each criteria has 3 sub criteria. I need help to put a formula to automate the final rating of the person after meeting a particular set of criteria

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว

      If you can send me email at exceldestination@gmail.com with some dummy data and conditions. I can provide you solution 100 %

  • @avneetsingh7649
    @avneetsingh7649 5 ปีที่แล้ว

    If both the column range are not same then,
    How we can apply nested IF or nested IF(AND) which one to apply and how to apply with formula pls explain it sir?????

  • @markrafaelcorpuz3568
    @markrafaelcorpuz3568 4 ปีที่แล้ว +1

    Do I need to use spaces to separate them?

  • @nicolasbrinez3663
    @nicolasbrinez3663 7 ปีที่แล้ว

    Very helpful, thank you.

  • @lailayasmin7200
    @lailayasmin7200 3 ปีที่แล้ว +1

    thank you!

  • @ExcelDestination
    @ExcelDestination  9 ปีที่แล้ว +2

    Thanks Ryan!!!

    • @tayyabcaisslc5893
      @tayyabcaisslc5893 5 ปีที่แล้ว +1

      Taiyyab gmail com email 👨‍💻👨‍🎓💼

  • @DADSLOVE2804
    @DADSLOVE2804 5 ปีที่แล้ว

    VERY HELPFUL

  • @jays5926
    @jays5926 4 ปีที่แล้ว +3

    For every confused student, there is an indian ready to teach him xD (btw i love indian im not hating)

    • @jokerryt2503
      @jokerryt2503 3 ปีที่แล้ว

      Dang why u hating man

  • @khizarkhan8347
    @khizarkhan8347 5 ปีที่แล้ว +1

    Thank you.

  • @sibyantony5097
    @sibyantony5097 6 ปีที่แล้ว +2

    Thanks a lot!!

  • @ajaysd3309
    @ajaysd3309 6 ปีที่แล้ว

    saved my day