Lesson 8 – What is the IF function, and how to insert it in Excel?

In this lesson, I’m going to be showing you how to:

  • Understand, what an IF function is
  • Insert an IF function

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS in Excel?

Or go back to:

Lesson 7 What is the ROUND function, and how to insert it in Excel?

Lesson 6 What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

12 thoughts on “Lesson 8 – What is the IF function, and how to insert it in Excel?”

  1. This is a fantastic explanation of the IF Function. It was easy to understand and follow along with, especially as I have always struggled with this one. Thank you for your videos Habib.

    Reply
    • Thank you for the compliment Samantha. The IF function is the tricky one, so take your time and watch the tutorial a few times and you will get it. Initially it is hard to digest it, but after a few views of my tutorial you will master the IF function – I promise 🙂

      Habib (ICT Tutor)

      Reply
  2. Hi Habib. Thank you for your details explanation and patient pace in the video tutorial. Yes, I can understand what you teach. I’m not an excel expert, especially using formula. I only know how to use simple formula. Yes, I have learn that “IF” is a powerful function. Knowing how to use it can save us lot of time in the work. Thank you for sharing!

    Reply
    • You’re very Welcome Janet. Keep practicing after watching my tutorials and your excel skills will always get better and better. But please always understand what I’m saying before having a go yourself.

      Habib

      Reply
  3. Really helpful video on understanding and utilising the IF function in excel. Helps to watch with an actual example being worked through. Thanks

    Reply
    • I’m glad this video tutorial was useful in understanding the IF function in Microsoft Excel. I tried to make it as user friendly as possible.

      Many Thanks

      Habib

      Reply
  4. Hi Habib,

    I am really enjoying these lessons and the videos are truly engaging.

    With the role I do in project management I am heavily using excel and the functions that I am learning from you are making my role a lot easier. I am also sharing what I learn with my colleagues and they too are improving in how they are using excel.

    Thank you for sharing and keep up the great work.

    All the best,

    Tom

    Reply
    • Wow! I’m truly humbled to hear your kind comments and how my video tutorials on Microsoft Excel are helping you and your company. Please let us know if there is anything else you would like to learn about the Microsoft Office.

      Thank you
      Best wishes

      Habib

      Reply
  5. Hello Habib,

    Thanks for putting this video together. I really appreciate your comprehensive teaching style, and found the material very helpful.

    I also like how you have broken up the material into smaller chunks. That’s very valuable.

    Please keep the tutorials coming!

    Michael

    Reply
    • If it is helping my visitors then I will continue with my tutorials. I am tutor by profession, hence my teaching style (I must say I do get complimented on my teaching style a lot 🙂
      Learning in smaller chunks is very effective. More tutorials are on their way…

      Habib

      Reply
  6. Hi Habib, thank you for this informative post. The video was explained thoroughly and at a pace that someone like me, unfamiliar with advanced excel, could understand. Thank you once again for sharing.

    Reply

Leave a comment

Share via
Copy link
Powered by Social Snap