Logical Functions In Excel Tutorial (IF, IFS, AND, OR, COUNTIF, SUMIF): Excel Formulas and Functions

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

КОМЕНТАРІ • 81

  • @SimonSezIT
    @SimonSezIT  11 місяців тому

    ✅ Download the exercise files and follow along here: ➡www.simonsezit.com/article/logical-functions-in-excel/

  • @thechannel7072
    @thechannel7072 3 роки тому +12

    Learning these things on internet makes internet very useful.
    Thanks for putting your hours and sharing knowledge for free to the people who are needed it.

  • @Christian-ll3wk
    @Christian-ll3wk Рік тому +2

    This is probably the BEST excel tutorial I've used. Thank you!

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

    I like these webinars. It's a lot of fun trying to figure out all the processes. I learned Excel 20 years ago at a local Community College. Since then, I have used it from time to time; within that time, Microsoft keeps adding to its application. It is like 'standing on the shoulders of giants'.

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

      Glad you like them Timothy!

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

    This is sooooooooo impactful!, WOW-It's worth the time and not boring. Thank you Simon Sez IT team.

  • @TrumpISAgentORANGE
    @TrumpISAgentORANGE 2 роки тому +2

    I've already watched a lot of great tutorials on IF, other functions and nesting. I just got overwhelmed and did not feel very confident. This tutorial was so helpful and relieved so much of my stress. Thank you so much!!!!!

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

      Glad it was helpful. Thanks for watching ;-)

  • @madvasto
    @madvasto 2 роки тому +1

    It was very well explained! It helped me understand better the combined IF functions. Thank you!!!

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

      You're very welcome, Madlen! Here's some additional training if you need it -> ua-cam.com/video/oN82Umc9MCQ/v-deo.html

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

    You’re such a good tuitor in excel.. I am currently learning about Microsoft,, and I watched many videos regarding about formulas, which giving me hard time to understand..but when I watched your video,, I was amaze the way you explained,, it’s understandable and I figured out finally in my mind , ,all the functions of each formulas,may god bless you😊😊😊😊thank you

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

      Glad you liked it, Shirley. Thanks for taking the time to watch and comment :-)

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

    After watching a great deal of tutorials looking at Logical Functions in Excel, I attest this one was helpful and then some! It helped me understand and apply its magic to solve an assigment involving nested IF functions; the solution to the assigment worked like a dream! Thank you very much!

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

      Thanks 😊 There is additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html

  • @TheHoshmanddeeba
    @TheHoshmanddeeba 4 роки тому +2

    thanks for this, very nice, when you zoomed in, that was when I really began to see your sheet properly. It was fuzzy before that. Best Regards, from Birmingham UK

    • @SimonSezIT
      @SimonSezIT  4 роки тому

      The video quality is usually automatically chosen dependent on your internet strength. To change the quality please select the settings Cog Icon at the bottom of the video and select "Quality" and choose a higher quality video such as" 1080p" I hope that helps !

  • @rodolfojr.delrosario4512
    @rodolfojr.delrosario4512 2 роки тому

    This tutorial is the best in terms of EXcel!!!! This is about creating a very useful videos. Subscribed!!!

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 2 роки тому +1

    Thanks alot Deborah,has been very informative

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

    Watching tutorial makes everything looks easy until I have to do it on my own. Your file is so easy to download for practice, thank you!

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

      Glad you liked it, Michelle 🙂 If you need it, you can get additional Excel training here ➡️
      ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html

  • @tharunkumar9682
    @tharunkumar9682 4 роки тому +1

    Thanks a lot ,excellent job ,Easy understandable accented tutorial ,clearly explained much needed logics 👍

  • @Absadumar
    @Absadumar 3 місяці тому +1

    Hello, thank you for the tutorial. It would have been better if you had zoomed in to be clear.

    • @SimonSezIT
      @SimonSezIT  3 місяці тому

      Thanks for the feedback 😊 We have the latest Logical Function tutorial. Hope this helps: ua-cam.com/video/uHv9HRxrWLg/v-deo.html

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

    Wonderful Tutorial. I am trying to create an Automatic Bowling Scoresheet. Any suggestions for an Existing Template or what function to use to calculate scores for Strikes, Spares, etc.?

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

    Deborah makes Sumifs fun and easy.

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

      She makes everything look easy. 😊

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

    Helpful, thank you.

    • @SimonSezIT
      @SimonSezIT  9 місяців тому

      You are very welcome! Glad it was helpful. 🙂
      🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html

  • @goodman-it2qy
    @goodman-it2qy День тому

    I thank you very much

  • @ghettoghost2657
    @ghettoghost2657 10 місяців тому

    absolutely fantastic lesson

    • @SimonSezIT
      @SimonSezIT  10 місяців тому

      Glad you enjoyed it. Thanks for watching! 🙂
      🔥Check out our FREE 300+ hour training course playlist here 👉
      ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

  • @darrylmorgan
    @darrylmorgan 4 роки тому +2

    Thumbs Up!Excellent Tutorial Thank You Debs :):):)

    • @SimonSezIT
      @SimonSezIT  4 роки тому

      Thank you Daryl, I'm glad you enjoyed it!

  • @mahamedali6158
    @mahamedali6158 2 місяці тому

    very excellent presentation

    • @SimonSezIT
      @SimonSezIT  2 місяці тому

      Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html

  • @AveyAvey
    @AveyAvey 4 роки тому +6

    Deborah Ashby is undoubtedly ,the top 5 excel trainers currently living! She should be given Knighthood!

    • @SimonSezIT
      @SimonSezIT  4 роки тому +1

      Let's start a petition haha! I'm pleased to hear you enjoyed the tutorial!

    • @AveyAvey
      @AveyAvey 4 роки тому

      @@SimonSezIT indeed, thoroughly.... Looking forward for the BI tutorial... . dosent seem, your star trainer won't be the instructor for that course :-(

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

    Thanks, I learned a lot.

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

    very much helpful. thank you.

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

      Glad it was helpful! 🙂
      We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
      For more information about Simon Sez IT courses, visit:
      SimonSezIT.com: www.SimonSezIT.com/
      Stay in touch!
      UA-cam Channel: www.youtube.com/@SimonSezIT
      LinkedIn: www.linkedin.com/company/simon-sez-it/
      Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
      ♥️ We appreciate your support!

  • @billeas576
    @billeas576 17 днів тому

    so helpful!

    • @SimonSezIT
      @SimonSezIT  16 днів тому

      Wow, thanks! Glad it was helpful. 🤩

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

    That's great training

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

      Glad you are enjoying the training. 😀

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

    Highly appreciated for your Tutorials, good revision for me. Many many thanks. B. M War, Additional Chief Engineer Civil, Meghalaya Energy Corporation ltd.

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

      Thanks for taking the time to leave some positive comments 😊 We have additional free Excel training if you need it 👉
      ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html

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

    very good tutorial

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

      Glad you enjoyed it. Thanks for watching! 🙂

  • @arv-Hackney-London
    @arv-Hackney-London 2 роки тому

    Is there an issue with the exercise file? This is the message that is flagging up when I tried to open it 'file format or file extension is not valid.' All of us would appreciate it someone at Simon Sez It can solve the problem. Thank you so much.

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

    Hi, Thanks for the video. I am looking for a solution which can help me to extract specific word from a string present in one cell and replace the same with different word from another cell. How to do it ?

  • @AhmedMaher-kg5en
    @AhmedMaher-kg5en 3 роки тому +1

    More than excellent

  • @አንዲትኢትዮጵያ
    @አንዲትኢትዮጵያ 7 місяців тому

    Thanks!!

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

      You are very welcome! Glad it was helpful. 🙂

  • @አንዲትኢትዮጵያ
    @አንዲትኢትዮጵያ 7 місяців тому

    አመሰግናለሁ!!

  • @MOHAMEDHASSAN-gp1nt
    @MOHAMEDHASSAN-gp1nt 4 роки тому +2

    عمل رائع شكرا جزيلا

  • @Rich-rp9xy
    @Rich-rp9xy 10 місяців тому

    Is this still relevant to excel if i want to learn for example a job where excel is required

  • @mohanasharank759
    @mohanasharank759 2 роки тому +1

    very super

  • @DavidBasseyIkpeme-mx8nu
    @DavidBasseyIkpeme-mx8nu 11 місяців тому

    Can u please always zoom when teaching for clearer view....i can see it clearly

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

    can you provide this excel file for practice, Please

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

    How can I do an IF to read (Data Cell) and if that cell contains data...A Date. I want an auto-fill from a specific cell (Cost cell) to go into the new cell next to the data cell?

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

    Is it possible to ask the IF function to leave the cell blank if the value is false?

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

      Yes. Put " " in negative condition.

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

    DIDNT I JUST CALM DOWN AFTER WATCHING THIS, THANKS A LOT BUT IM STILL HAVING PROBLEM WITH UNDERSTANDING IF FUNCTION, I KEEP ON FAILING AND FAILING

    • @SimonSezIT
      @SimonSezIT  7 місяців тому +1

      Keep on practicing. Here are more Microsoft Excel Tips and Tricks to try on ➡️
      ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html

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

    Can somebody share the excel files.?? Am not able to access them

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

      Download the exercise files and follow along here: www.simonsezit.com/article/logical-functions-in-excel/

  • @emmanuelpenada7423
    @emmanuelpenada7423 11 місяців тому

    how can i download that helpful tools?

    • @SimonSezIT
      @SimonSezIT  11 місяців тому

      Hello Emmanuel. Thanks for watching. You can download the exercise files 👉www.simonsezit.com/article/logical-functions-in-excel/

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

      @@SimonSezITthe exercise files aren’t here… please help

  • @Amitsingh-pu7qv
    @Amitsingh-pu7qv 3 місяці тому

    CAN I DOWNLOAD PRACTICE FILE FREE ?

  • @TheSason666
    @TheSason666 9 місяців тому

    22:34 27:39 34:54 40:55

  • @williamredmond8128
    @williamredmond8128 8 місяців тому

    "Let me reduce my employee's to value ratings."

  • @rubelmahmud328
    @rubelmahmud328 10 місяців тому

    Great channel to excel effectively for free

    • @SimonSezIT
      @SimonSezIT  10 місяців тому

      Glad you enjoyed it. Thanks for watching! 🙂
      🔥Please check out our FREE 300+ hour training course playlist here 👉
      ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html