Logical Functions In Excel Tutorial (IF, IFS, AND, OR, COUNTIF, SUMIF): Excel Formulas and Functions
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- ✅ Download the exercise files and follow along here: ➡️www.simonsezit...
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...
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...
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit...
💻 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...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
✅ Download the exercise files and follow along here: ➡www.simonsezit.com/article/logical-functions-in-excel/
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.
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'.
Glad you like them Timothy!
This is probably the BEST excel tutorial I've used. Thank you!
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!!!!!
Glad it was helpful. Thanks for watching ;-)
This is sooooooooo impactful!, WOW-It's worth the time and not boring. Thank you Simon Sez IT team.
It was very well explained! It helped me understand better the combined IF functions. Thank you!!!
You're very welcome, Madlen! Here's some additional training if you need it -> th-cam.com/video/oN82Umc9MCQ/w-d-xo.html
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
Glad you liked it, Shirley. Thanks for taking the time to watch and comment :-)
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
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 !
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!
Thanks 😊 There is additional Excel training here if you need it -> th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
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!
Glad you liked it, Michelle 🙂 If you need it, you can get additional Excel training here ➡️
th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
This tutorial is the best in terms of EXcel!!!! This is about creating a very useful videos. Subscribed!!!
Welcome aboard!
Thanks a lot ,excellent job ,Easy understandable accented tutorial ,clearly explained much needed logics 👍
Glad it was helpful!
Thanks alot Deborah,has been very informative
Glad it was helpful!
very excellent presentation
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Deborah Ashby is undoubtedly ,the top 5 excel trainers currently living! She should be given Knighthood!
Let's start a petition haha! I'm pleased to hear you enjoyed the tutorial!
@@SimonSezIT indeed, thoroughly.... Looking forward for the BI tutorial... . dosent seem, your star trainer won't be the instructor for that course :-(
Thumbs Up!Excellent Tutorial Thank You Debs :):):)
Thank you Daryl, I'm glad you enjoyed it!
Thanks, I learned a lot.
absolutely fantastic lesson
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Helpful, thank you.
You are very welcome! Glad it was helpful. 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
very much helpful. thank you.
Glad it was helpful! 🙂
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Deborah makes Sumifs fun and easy.
She makes everything look easy. 😊
Hello, thank you for the tutorial. It would have been better if you had zoomed in to be clear.
Thanks for the feedback 😊 We have the latest Logical Function tutorial. Hope this helps: th-cam.com/video/uHv9HRxrWLg/w-d-xo.html
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.?
Highly appreciated for your Tutorials, good revision for me. Many many thanks. B. M War, Additional Chief Engineer Civil, Meghalaya Energy Corporation ltd.
Thanks for taking the time to leave some positive comments 😊 We have additional free Excel training if you need it 👉
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
That's great training
Glad you are enjoying the training. 😀
More than excellent
Thanks Ahmed!
very good tutorial
Glad you enjoyed it. Thanks for watching! 🙂
አመሰግናለሁ!!
عمل رائع شكرا جزيلا
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.
Thanks!!
You are very welcome! Glad it was helpful. 🙂
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 ?
Can u please always zoom when teaching for clearer view....i can see it clearly
Is this still relevant to excel if i want to learn for example a job where excel is required
very super
Thank you! Cheers!
22:34 27:39 34:54 40:55
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?
Is it possible to ask the IF function to leave the cell blank if the value is false?
Yes. Put " " in negative condition.
can you provide this excel file for practice, Please
CAN I DOWNLOAD PRACTICE FILE FREE ?
how can i download that helpful tools?
Hello Emmanuel. Thanks for watching. You can download the exercise files 👉www.simonsezit.com/article/logical-functions-in-excel/
@@SimonSezITthe exercise files aren’t here… please help
Can somebody share the excel files.?? Am not able to access them
Download the exercise files and follow along here: www.simonsezit.com/article/logical-functions-in-excel/
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
Keep on practicing. Here are more Microsoft Excel Tips and Tricks to try on ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
"Let me reduce my employee's to value ratings."
Great channel to excel effectively for free
Glad you enjoyed it. Thanks for watching! 🙂
🔥Please check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html