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

Рет қаралды 128,402

4 жыл бұрын

✅ Download the exercise files and follow along here: ➡️www.simonsezit.com/article/lo...
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.
Download the exercise files and follow along here ► www.simonsezit.com/article/lo...
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
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel 2019 T...
✅ Pivot Table Tutorials for Beginners here 👉 • How to Use Microsoft E...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 73

@SimonSezIT 7 ай бұрын

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

@thechannel7072 3 жыл бұрын

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 3 жыл бұрын

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 3 жыл бұрын

Glad you like them Timothy!

@lenoracollins9225 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 2 жыл бұрын

Glad it was helpful. Thanks for watching ;-)

@madvasto 2 жыл бұрын

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

@SimonSezIT 2 жыл бұрын

You're very welcome, Madlen! Here's some additional training if you need it -> kzfaq.info/get/bejne/pbRoZbieyJ-xc4U.html

@TheHoshmanddeeba 4 жыл бұрын

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 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 !

@MOHAMEDHASSAN-gp1nt 4 жыл бұрын

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

@Heuschele 6 ай бұрын

Helpful, thank you.

@SimonSezIT 5 ай бұрын

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

@darrylmorgan 4 жыл бұрын

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

@SimonSezIT 4 жыл бұрын

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

@lawrencekazibwe9751 2 жыл бұрын

Thanks alot Deborah,has been very informative

@SimonSezIT 2 жыл бұрын

Glad it was helpful!

@tharunkumar9682 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Glad it was helpful!

@brandonculbengan9564 Жыл бұрын

Thanks, I learned a lot.

@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 -> kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@rodolfojr.delrosario4512 2 жыл бұрын

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

@SimonSezIT 2 жыл бұрын

Welcome aboard!

@ghettoghost2657 6 ай бұрын

absolutely fantastic lesson

@SimonSezIT 6 ай бұрын

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

@questionresearch8721 Жыл бұрын

Deborah makes Sumifs fun and easy.

@SimonSezIT Жыл бұрын

She makes everything look easy. 😊

@AveyAvey 4 жыл бұрын

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

@SimonSezIT 4 жыл бұрын

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

@AveyAvey 4 жыл бұрын

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

@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 2 жыл бұрын

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

@oskarhaas824 Жыл бұрын

That's great training

@SimonSezIT Жыл бұрын

Glad you are enjoying the training. 😀

@AhmedMaher-kg5en 3 жыл бұрын

More than excellent

@SimonSezIT 2 жыл бұрын

Thanks Ahmed!

@user-od4fz5ls3d 3 ай бұрын

Thanks!!

@SimonSezIT 3 ай бұрын

You are very welcome! Glad it was helpful. 🙂

@user-od4fz5ls3d 3 ай бұрын

አመሰግናለሁ!!

@cheryllin4079 3 ай бұрын

very good tutorial

@SimonSezIT 2 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂

@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 ➡️ kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@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 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@mohanasharank759 2 жыл бұрын

very super

@SimonSezIT 2 жыл бұрын

Thank you! Cheers!

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

@TheSason666 5 ай бұрын

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

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

@Rich-rp9xy 6 ай бұрын

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

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

@unknownhippieexplorer8848 3 жыл бұрын

can you provide this excel file for practice, Please

@CardExpressions 2 жыл бұрын

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?

@rubelmahmud328 6 ай бұрын

Great channel to excel effectively for free

@SimonSezIT 6 ай бұрын

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

@DavidBasseyIkpeme-mx8nu 7 ай бұрын

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

@lisaaustin3187 2 жыл бұрын

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

@cindy7lee 2 жыл бұрын

Yes. Put " " in negative condition.

@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/

@emmanuelpenada7423 7 ай бұрын

how can i download that helpful tools?

@SimonSezIT 7 ай бұрын

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

@BEEMOKOPU 3 ай бұрын

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 3 ай бұрын

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

@williamredmond8128 4 ай бұрын

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

@subhashini4242 9 ай бұрын

very much helpful. thank you.

@SimonSezIT 9 ай бұрын

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