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

[@SimonSezIT]

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

[@thechannel7072]

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]

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

[@sanmi1752]

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

[@timothytabor7887]

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]

Glad you like them Timothy!

[@TrumpISAgentORANGE]

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]

Glad it was helpful. Thanks for watching ;-)

[@madvasto]

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

[@SimonSezIT]

You're very welcome, Madlen! Here's some additional training if you need it -> kzbin.info/www/bejne/pX-bY4ijmJ6AebM

[@TheHoshmanddeeba]

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]

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 !

[@lawrencekazibwe9751]

Thanks alot Deborah,has been very informative

[@SimonSezIT]

Glad it was helpful!

[@rph247]

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]

Thanks 😊 There is additional Excel training here if you need it -> kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@darrylmorgan]

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

[@SimonSezIT]

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

[@Heuschele]

Helpful, thank you.

[@SimonSezIT]

You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@rodolfojr.delrosario4512]

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

[@SimonSezIT]

Welcome aboard!

[@brandonculbengan9564]

Thanks, I learned a lot.

[@ghettoghost2657]

absolutely fantastic lesson

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@shirleywickremachci7831]

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]

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

[@subhashini4242]

very much helpful. thank you.

[@SimonSezIT]

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

[@tharunkumar9682]

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

[@SimonSezIT]

Glad it was helpful!

[@Team8LA]

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]

Glad you liked it, Michelle 🙂 If you need it, you can get additional Excel training here ➡️ kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@oskarhaas824]

That's great training

[@SimonSezIT]

Glad you are enjoying the training. 😀

[@mahamedali6158]

very excellent presentation

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@billeas576]

so helpful!

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@AhmedMaher-kg5en]

More than excellent

[@SimonSezIT]

Thanks Ahmed!

[@questionresearch8721]

Deborah makes Sumifs fun and easy.

[@SimonSezIT]

She makes everything look easy. 😊

[@goodman-it2qy]

I thank you very much

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@cheryllin4079]

very good tutorial

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂

[@Absadumar]

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

[@SimonSezIT]

Thanks for the feedback 😊 We have the latest Logical Function tutorial. Hope this helps: kzbin.info/www/bejne/q3nZanuIrdeKgsk

[@አንዲትኢትዮጵያ]

Thanks!!

[@SimonSezIT]

You are very welcome! Glad it was helpful. 🙂

[@አንዲትኢትዮጵያ]

አመሰግናለሁ!!

[@bubwar9716]

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

[@SimonSezIT]

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

[@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.?

[@MOHAMEDHASSAN-gp1nt]

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

[@mohanasharank759]

very super

[@SimonSezIT]

Thank you! Cheers!

[@vineetp1861]

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 ?

[@arv-Hackney-London]

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.

[@TheSason666]

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

[@rubelmahmud328]

Great channel to excel effectively for free

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 🔥Please check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@Rich-rp9xy]

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

[@unknownhippieexplorer8848]

can you provide this excel file for practice, Please

[@emmanuelpenada7423]

how can i download that helpful tools?

[@SimonSezIT]

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

[@angelaanil]

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

[@lisaaustin3187]

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

[@cindy7lee]

Yes. Put " " in negative condition.

[@CardExpressions]

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?

[@angelaanil]

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

[@SimonSezIT]

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

[@Amitsingh-pu7qv]

CAN I DOWNLOAD PRACTICE FILE FREE ?

[@BEEMOKOPU]

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]

Keep on practicing. Here are more Microsoft Excel Tips and Tricks to try on ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@DavidBasseyIkpeme-mx8nu]

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

[@Sorrybutno]

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