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

In this Excel tutorial, we take a look at Logical Functions in Excel. That's functions such as IF, IFS, COUNTIF and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel.

This was taken from a live, recorded session. You can download the Excel files that Debs uses below and follow along.

In this session we covered:

- The IF Function
- Nested IF in Excel
- The IFS Function
- The AND and OR Functions
- COUNTIF and SUMIF
- Error checking Functions IFERROR and IFNA

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[thechannel]

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-llwk]

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

[sanmi]

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

[timothytabor]

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'.

[lenoracollins]

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

[madvasto]

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

[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

[lawrencekazibwe]

Thanks alot Deborah, has been very informative

[darrylmorgan]

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

[tharunkumar]

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

[rodolfojr.delrosario]

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

[rph]

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!

[AveyAvey]

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

[shirleywickremachci]

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

[TeamLA]

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!

[bubwar]

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

[howardslade]

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

[vineetp]

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 ?

[Rich-rpxy]

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

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