Using the New IFS Function in Excel

Technology for Teachers and Students
Technology for Teachers and Students
143,419
35
Published 2020-03-23
Learn how to use the great, new IFS function in Excel. IFS lets us create up to 127 IF statements in one formula! This can make the old nested IF strategy completely obsolete. In the video you'll see two different examples of how useful the IFS function can be. ***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Here's the practice file that goes with the video: bit.ly/excelifs
All Comments (21)
  • @ABMA79
    You truly tackle any issue at its core. your simplicity with examples to illustrate functionality is more than amazing. Great lesson and I hope to be able to view more of your excellent lectures in the near future. Thanks a lot.
  • @kathleencrisp1
    Thank you, you teaching style is so easy to follow and retain. All the best. Stay well. Appreciative Excel beginner.
  • @natashaz8665
    I absolutely love your tutorials. You make it look and sound so easy! Thank you!
  • @AsimAbduljabbar
    Great tutorial simple and easy to understand. Thanks for sharing! Awesome work!
  • @soo6623
    I love your videos you make the learning easier and more fun I don’t even feel bored. you’re the best teacher ever thank you for helping us
  • @Jojosmith342
    EXCELLENT !!! I am glad to find you - the GREATEST TEACHER on youtube 👌.Thank you millions for taking time to educate & inspire us learning. I always thumb ups 👍every lessons I watch. Your video is on my daily learning schedule since I first found you♥👏
  • @AXNJXN1
    After weeks of searching... YOUR vid finally knocks this out of the park - and clearly! Thank you...
  • @livinginlalaville
    Very cool! Thank you! I used to use the nested IF function but lately hadn't needed to. That may change as my job changes yet again. 😊
  • @mor8266
    Excellent example and video tutorial. Thanks
  • @princessjaydee5589
    clear explanation, great. I wish you also have the tutorials for outlook. thank you
  • @rebelkb2263
    you have really helped me improve my excel skills thanks a lot
  • @user-dk5yr3zj8l
    You are great teacher Sir. Thanks a lot for your nice tutorial.
  • @chrishellmax
    Got me hooked on this from the first second. I am addicted to Excel and vba coding. Subbed.
  • @ThatOfficeGuy
    This is a great new function, so much simpler than a nested IF functions or having to combine IF with OR.
  • @jdmxxx38
    Excellent presentation. Smooth stepwise path to the information.
  • @Twtigg
    Thanks, very informative, great presentation, looking forward to more, again thanks.