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:

Note: a NEW lesson 8 VIDEO is coming soon – sorry for the inconvenience

If I have not covered everything 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

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

  1. Hi Habib,
    Wow! when I was thinking that excel is a piece of cake, then you brought out this complex stuff that normally I would close my browser. Amazingly, you did great justice with your simplified teaching.

    • Thanks for the compliment on my teaching Benson, much appreciated. IF function is one of the hardest to grasp, but once you’ve got it, you love it.

      Habib (ICT tutor)

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

    • 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)

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

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


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

    • 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


  5. 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,


    • 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


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


    • 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…


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


Leave a comment

1 Share
Share via
Copy link
Powered by Social Snap