10 Advanced IF formulas every analyst should know

Поділитися
Вставка
  • Опубліковано 25 лис 2024

КОМЕНТАРІ • 339

  • @Maheshwaripn
    @Maheshwaripn 3 роки тому +27

    Following you on website for years and today I found you here, immediately subscribed
    Your examples are like patented inventions for free

    • @chandoo_
      @chandoo_  3 роки тому +4

      Thanks Prashant for the love and support for all these years.

  • @roderickmose4691
    @roderickmose4691 3 роки тому +120

    =IF("excellent learning needed"="yes" , "Chandoo" , "")

  • @MrRanjithm1
    @MrRanjithm1 Рік тому

    You are really superb Chandoo. Coming from the Indian dub continent at 74 years, I started following your tips, and I have understood these formulas much more than before, and I can use them in many of my worksheets I do for a school. Thank you very much.

  • @srinivasraogampala4420
    @srinivasraogampala4420 3 роки тому +2

    I am using nested if function for lot of years. Now I came to know that there is a IFS function, much readable code.. You are awesome bro.

  • @erickowaga5473
    @erickowaga5473 Рік тому +1

    I've struggled with the IF function for too long before I came across your channel. You're awesome. Thanks for the great stuff.

  • @AnuragSingh-fp6ei
    @AnuragSingh-fp6ei 3 роки тому +8

    Chandoo, I have been following you since more than a decade now. Thanks once again for awesome tips and tricks!! These are so useful

    • @chandoo_
      @chandoo_  3 роки тому

      Glad you like them!

  • @mikelib62
    @mikelib62 3 роки тому +6

    you have a knack of making a difficult, look so simple and matter of fact- you are indeed one of the best on this subject

  • @derrickpeoples1864
    @derrickpeoples1864 7 місяців тому

    Chandoo, you saved my life! I had to use your second example (i.e., Any two out of three conditions) in a real world work assignment, and I got the solution I was looking for, :)

  • @m.raedallulu4166
    @m.raedallulu4166 2 роки тому

    I've been following you since nearly three years, and you are a wonderful Excel person, Chandoo!
    Thank you so much!

  • @KannadatiBindyaChannel
    @KannadatiBindyaChannel 2 роки тому

    Hi Guru, Thanks for your IF and only IF TIPS....!!!! using the IF function for almost a decade from you... the Advanced TIPS to use excel extensively and wisely. keep Going ...!!!

  • @shivsharma9153
    @shivsharma9153 3 роки тому +1

    So thankful to youtube and creators like you, who making this great knowledge available for free which we would not able to access if there was no youtube.

  • @30ktothemoon76
    @30ktothemoon76 3 роки тому

    How come is this free stuff on youtube? This is gem! Thanks for the awesome tips and tricks! Instantly subscribed.

  • @akilj9502
    @akilj9502 10 місяців тому +1

    Hello Chandoo, your content is amazing. I love the way you take time and explain every part of the Function / Formula. Thanks a million. You are the best!!

  • @dilansenn
    @dilansenn 3 роки тому +1

    Thank you very much Sir, I was struggling to use the IF function with wildcards on a major project I was stucked for a long time, this video was a life saver to over come that. Thanks loads and please keep doing this brilliant work. Wish you all the best. God bless you.

  • @Me-ow5rw
    @Me-ow5rw 3 роки тому +2

    I already learnt from you through your online course. You are Awesome.

    • @chandoo_
      @chandoo_  3 роки тому

      Glad to hear that. Thank you so much for going thru the course :)

  • @sandipgumtya130
    @sandipgumtya130 3 роки тому +5

    Hi Chandoo, thanks for the amazing tips. Many of these were unknown. Just found that the "on-call" thing can be done with the below formula too.
    =IF(OR(C8=$C$32:$C$36),"On Call","Not On Call").
    Thanks

  • @rajavintemakhan
    @rajavintemakhan 3 роки тому +1

    Thank you chandoo not only for this trick also for the excel file you made before to use as database I made some change and implemented in my company as an instant pallet generator still they are using the file everyday without showing any error.. 😊😊

  • @vramarathnam
    @vramarathnam 23 дні тому

    Excellent Demonstration. Great Efforts. Learnt a lot today. Thank You very much

  • @iQuMaster
    @iQuMaster 3 роки тому +2

    There is IFS function?!! Man you just made my life so much easier 😄

  • @timemerick733
    @timemerick733 3 роки тому +1

    Really enjoyed the graph example. I added an additional column for average to get a column with a static value and included it in my chart as a line type. It added a pop to the 2nd average overlayed bar showing a dynamic average line. Thanks!

  • @NodictatorsinKZ
    @NodictatorsinKZ Рік тому

    You're the best in explaining Excel! Love your channel and your videos, please keep us the good work. Love it.

  • @patrickschardt7724
    @patrickschardt7724 3 роки тому +1

    Wonderful examples. I knew some functions existed but never thought to use them with IF

    • @chandoo_
      @chandoo_  3 роки тому +3

      I am glad you found it useful. One powerful way I maximise my learning & memory is by thinking "I know A, I know B, I wonder if I can combine A&B"...

    • @patrickschardt7724
      @patrickschardt7724 3 роки тому +1

      @@chandoo_ that’s a great strategy for learning

  • @BlockFHatter
    @BlockFHatter 3 роки тому

    Once again thank you so much. You are very clear and easy to understand the instructions. You make the complicated far less so.

    • @chandoo_
      @chandoo_  3 роки тому

      Aww.. thank you for that.

  • @Skyggespil
    @Skyggespil 3 роки тому +2

    in the wildcard assignment (column O) you dont need to do a countifs. Just write "=if(C8="*"&$O$5&"*","bo person","not a bo person".
    Great video, I definitely picked up a good handful of pointers

    • @chandoo_
      @chandoo_  3 роки тому +1

      Thank you.
      hmm.. which version of Excel you are using? When I test it on Excel 365, it doesn't work.

  • @jitendrapatel1831
    @jitendrapatel1831 3 роки тому

    This guy is genius in excel. All the best Chandu.

    • @chandoo_
      @chandoo_  3 роки тому

      Thank you Jitendra...

  • @Patrick-ge2zn
    @Patrick-ge2zn 3 роки тому

    Thankyou for the video, the cell formatting is much easier than the way I was doing it .

  • @rosedesoloc8081
    @rosedesoloc8081 2 роки тому

    Thank you so much for teaching us for free.

  • @raghvendrasingh9721
    @raghvendrasingh9721 3 роки тому

    Thank you sir for sharing such information in small videos with brief description and its functionality. It really helps

    • @chandoo_
      @chandoo_  3 роки тому +1

      You are most welcome

  • @blazerbeavs2333
    @blazerbeavs2333 Рік тому

    I didn't know you could embed dates in your formulas! I use the between formula frequently and always have date inputs in cells. Cool stuff!

  • @sukoi2113
    @sukoi2113 3 роки тому +1

    Awesome gyan. This is the best "If" class.

  • @taizoondean689
    @taizoondean689 6 місяців тому

    Was revising Thank You again and God Bless You

  • @prashantsteele
    @prashantsteele 2 роки тому

    Life changer Lessons... No words more needed... Thanks Chandoo

  • @ishyamkumar3372
    @ishyamkumar3372 5 місяців тому

    Chandoo Sir Thank you very much for your valuable training videos, Its really useful in my carrier ,

  • @ayazmewati3194
    @ayazmewati3194 Рік тому

    Sir your simplicity is exemplary

  • @JustOkko
    @JustOkko 3 роки тому +1

    Wow! I thought I had advanced IF skills, but this adds some to my portfolio. Thanks!

    • @chandoo_
      @chandoo_  3 роки тому

      Glad it was helpful!

  • @cursodeexcelcompletogratis7773
    @cursodeexcelcompletogratis7773 3 роки тому +2

    who can ever dislike this video ? you rocks ! congratulation from Brazil

  • @michaelvincentmamongcara1208
    @michaelvincentmamongcara1208 3 роки тому +3

    Hi Chandoo, loving your videos. For inventory analysis in manufacturing/warehousing, hope you can give us an excel method on how to determine the FEFO or "First Expiry/First Out" - *Fresher production dates are served instead of older ones* affected items. Considering the age requirements of multiple customers. This might be a bit complex, but hope you can give a simple and easy way.

  • @Oveea-i9e
    @Oveea-i9e Рік тому

    Absolutely awesome! So glad I came about your page! :)

  • @tapanbarick9572
    @tapanbarick9572 Рік тому

    Sir I like your teaching style.

  • @rory1653
    @rory1653 3 роки тому +1

    great examples Chandoo. love the level you're demonstrating; definitely matched the 'advanced' title. cheers

  • @aivie1900
    @aivie1900 2 роки тому

    Thank you so much for this Sir, I found the great examples I needed for my work. More power to your channel. God Bless.

  • @jet-joyexceltraining8418
    @jet-joyexceltraining8418 3 роки тому

    Every learn something new from your videos

  • @PriyankaLiyanage
    @PriyankaLiyanage 2 дні тому

    Thank you very much Mr. Chandoo.

  • @amihem1080
    @amihem1080 3 роки тому +1

    👍 Following you last many year...you are awasome

    • @chandoo_
      @chandoo_  3 роки тому

      Thank you Amit 😀

  • @HacTacbka
    @HacTacbka 2 роки тому

    your videos are straight to the point and it pleases me so much! I'm hooked from the first second =) I tried looking similar videos by other exel-pros, but yours are interesting, quick and with great examples. Thank you!

  • @RA-rh5lb
    @RA-rh5lb Місяць тому

    Thanks, Chandoo for ifs example here.. definitely i didn't understand boolean methos.. confusing

  • @wayneedmondson1065
    @wayneedmondson1065 3 роки тому +3

    Hi Chandoo. Awesome IF function workout! Thanks for sharing :)) Thumbs up!!

  • @RA-rh5lb
    @RA-rh5lb Місяць тому

    =if (excellent learning needed" ="Yes", "Not to confuse with Boolean ", "Chandoo")

  • @peerzsalim1722
    @peerzsalim1722 2 роки тому

    Hi Mr.Chandoo, Thanks for your effort. Best Wishes

  • @meniporat3527
    @meniporat3527 3 роки тому +2

    A shorter solution to the "Review" challenge:
    =IF(AND(YEAR(F8)=2019,MONTH(F8)

  • @vaibhavmhaske173
    @vaibhavmhaske173 3 роки тому

    Thank you...chandoo sir
    Your videoa are ao precise and to the point.. I am finding it very easy to learn and work

  • @mickaell3451
    @mickaell3451 3 роки тому

    The boolaen replacement trick and a median used for dates trick are a good way to confuse the colleagues. Im definitly gonna use it :D Thanks Chandoo

    • @chandoo_
      @chandoo_  3 роки тому

      I find that both of them also offer some speed improvements too.

    • @mickaell3451
      @mickaell3451 3 роки тому

      @@chandoo_ i didnt think of this aspect. thanks for this detail.

  • @vitorpontes1048
    @vitorpontes1048 3 роки тому +1

    Loved your tips and tricks. You're awesome. Thank you for spending the time to teach is us such awesome features. Keep going!

  • @gavidiharish13
    @gavidiharish13 Рік тому

    What a trainer.... ❤❤❤

  • @surajbhardwaj428
    @surajbhardwaj428 3 роки тому +1

    Love bro...

  • @keishrich
    @keishrich 3 роки тому +1

    These were helpful, thank you Chandoo.

    • @chandoo_
      @chandoo_  3 роки тому +1

      You are welcome Keisha.

  • @osirkeci
    @osirkeci 3 роки тому +1

    very good lesson, thank you, Chandoo

    • @chandoo_
      @chandoo_  3 роки тому

      You are welcome Omer...

  • @ruthadere7314
    @ruthadere7314 3 роки тому +1

    very important, thank you!

    • @chandoo_
      @chandoo_  3 роки тому

      Glad it was helpful!

  • @francisaranha
    @francisaranha Рік тому

    Just loved it Chandoo!

  • @heather7461
    @heather7461 3 роки тому +3

    You're amazing, thank you so much !

    • @chandoo_
      @chandoo_  3 роки тому

      You are welcome Heather.

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 3 роки тому

    CHANDOO YOU ARE REALLY GENIUS

  • @ozgur937
    @ozgur937 3 роки тому

    This is such a beautiful representation.

  • @falaksharma1
    @falaksharma1 2 роки тому

    Thanks Sir for such a great video.

  • @lesleywells3497
    @lesleywells3497 2 роки тому

    Excellent content!

  • @bobwhelan5644
    @bobwhelan5644 3 роки тому

    Brilliant Chandoo - such very useful tips, thank you

  • @andreluizsales3286
    @andreluizsales3286 2 роки тому

    Thanks Chandoo!

  • @christianreed4396
    @christianreed4396 2 роки тому

    Wonderful! Thank you for this!

    • @chandoo_
      @chandoo_  2 роки тому

      Glad you enjoyed it!

  • @defrinaelsianipar9883
    @defrinaelsianipar9883 3 роки тому +1

    thats what i need, thank you my brother 👌😁

    • @chandoo_
      @chandoo_  3 роки тому

      I am glad you enjoyed it...

  • @GeorgeAJululian
    @GeorgeAJululian 3 роки тому +1

    Thank you it was very helpful

  • @satishgundoji1144
    @satishgundoji1144 3 роки тому

    one of the best channels!

  • @florincopaci6821
    @florincopaci6821 3 роки тому +1

    Great work! Like always i m impressed.Thank you for sheering this

    • @chandoo_
      @chandoo_  3 роки тому

      Thank you florin...

  • @ragavendra77
    @ragavendra77 Рік тому

    Amazing Chandoo 👏

  • @siddiqbinsalam1284
    @siddiqbinsalam1284 3 роки тому

    Excellent work brother, thanks.

  • @nirmalabolar1382
    @nirmalabolar1382 2 роки тому

    Awesome video, very informative, thanks

    • @chandoo_
      @chandoo_  2 роки тому

      Glad it was helpful!

  • @acommonman155
    @acommonman155 Рік тому

    Loved it totally

  • @akshaymagre5261
    @akshaymagre5261 3 роки тому

    Logical function which are quite logical :)

  • @dharagajera2902
    @dharagajera2902 3 роки тому

    Excellent!!!!! Can you mentioned how many videos have to watch which is necessary for data analysis beginner as can not able to watch each and every video??
    Please give reply
    Thanks for everything.
    Say yes to chandoo.....

  • @AdityaKumar-br1dx
    @AdityaKumar-br1dx Рік тому

    thanks sir really helpful i got confused when there are so many if constraints in the formula.

  • @briandennehy6380
    @briandennehy6380 3 роки тому +1

    Great stuff, love the countif trick 👍

    • @chandoo_
      @chandoo_  3 роки тому

      Thank you! Cheers!

  • @ardip.6930
    @ardip.6930 3 роки тому

    Thanks buddy...I think I might use a couple of these going forward 😁

  • @aseemgoyal101
    @aseemgoyal101 3 роки тому

    One word....Awesome...keep going mate

  • @giandenorte
    @giandenorte 3 роки тому

    Another great content Master Chandoo! Greetings from Philippines.

  • @arnabsaha33
    @arnabsaha33 2 роки тому

    You are a magician.

  • @algr665
    @algr665 3 роки тому

    Man, you are really good. Love your excel tips. Great job. I just subscribed.

    • @chandoo_
      @chandoo_  3 роки тому

      Thanks for the sub!

  • @raitup00
    @raitup00 3 роки тому

    I didn't expect the Pop quiz!! Saludos desde México

    • @chandoo_
      @chandoo_  3 роки тому

      I hope you passed it ;)

  • @RobertAfrick
    @RobertAfrick 3 роки тому

    I am in the presence of greatness...thanks Chandoo!

  • @pektuspektus612
    @pektuspektus612 3 роки тому

    Thanks Chandoo!
    I'm from Philippines too.
    Lots of new stuffs form me.

  • @uwadiegwuemmanuel8809
    @uwadiegwuemmanuel8809 2 роки тому

    I am grateful

  • @TechWrite
    @TechWrite 3 роки тому

    Great video Chandoo. Many thanks!

  • @nandakishorecb2958
    @nandakishorecb2958 3 роки тому

    Superb... thank you so much :-)

  • @FRANKWHITE1996
    @FRANKWHITE1996 3 роки тому

    As always great video thank you

  • @rajasekarans898
    @rajasekarans898 Місяць тому +1

    Thanks

    • @chandoo_
      @chandoo_  Місяць тому

      Thanks for the love and super 😍

  • @michafabich9213
    @michafabich9213 2 роки тому

    very valuable

  • @Minhasacademy
    @Minhasacademy 3 роки тому

    Thank you so much chandoo sir ❤️

  • @johndurran614
    @johndurran614 3 роки тому

    Another awesome video

    • @chandoo_
      @chandoo_  3 роки тому

      Glad you enjoyed it

  • @shaitarun
    @shaitarun Рік тому

    Amazing ❤

  • @ravi__negi__4333
    @ravi__negi__4333 4 місяці тому

    LEARBNED SOMETHING NEW THANKS

  • @afnanforyou
    @afnanforyou 3 роки тому +3

    Now, since I have mastered IF formula, I no more use it. I either do it the boolean way or Xlookup or vlookup...

  • @aman_mashetty5185
    @aman_mashetty5185 3 роки тому

    Thank you Chandoo for Another great video👌👌

    • @chandoo_
      @chandoo_  3 роки тому

      Glad you enjoyed it

  • @mayurzope6531
    @mayurzope6531 3 роки тому

    Chandoo you are awesome man..keep going...