How to use the IF Function in Microsoft Excel - For Beginners

In this video, I will show you how to use an IF formula with multiple conditions in Microsoft Excel for beginners. The IF function is one of the more popular functions in Microsoft Excel and an important one to know how to use. I will show you how to create a formula with an IF function and a nested IF and a nested AND Function.

0:00 Introduction
0:54 What is an IF function?
1:46 Inserting the IF function and creating an IF Statement
4:03 Typing in an IF function
6:18 The IF function with a nested AND function
8:50 The IF function with a nested AND function and a nested IF function

[tafiqulbarirabbi]

Shout-out to Jamie Sir. An incredible teacher for us who walked through us so easily through the lessons of Count IF, Count IFS, Sum IF, Sum IFS, and IF function and many more lessons sir. I really like your teaching and the way you speak it seems you're explaining me right in front of me . Thanks again Sir.

Love from Muscat, Oman 🇴🇲

[olliefoxx]

This is a fantastic video! If youre watching this on your phone he's made this video much easier to see and follow along compared to other videos Ive watched. I like the way he placed different functions side by side and slowly built up into more complex formulas. This is well done by a proper teacher!

[lesliealvarez]

You are an excellent teacher! Thank you for developing some of your time on teaching online!

[evinharrelson]

You are such a great teacher. I’m so glad you have these available for free here. If I were you, I’d be making money somehow off teaching others. You probably already are. Just saying. You’re good enough!!!

[dreajam]

Thank you so much for creating these exercises. They are very helpful. I am literally on your channel every single day 😁

[rueljhonalpay]

Thank you, sir, for posting another very useful lesson. Keep up the good work. Again, thank you so much.

[rickpalechuk]

Another great tutorial as always Jamie!
Thanks for sharing,
Cheers

[sgit]

YOU . . . are an excellent instructor.

[brianking]

Thanks Jamie, excellent demonstration of the IF function. More like this please.

[brentt]

Thank you, sir, for posting another very useful lesson this time. Keep up the good work.

[shashimaansingh]

Thank you so much. It helps me a lot to understand the function very well. You’re such a great 👍 teacher. God bless you.

[janehillz]

Thank you so much. You’re such a great 👍 teacher. God bless you

[ciedlle]

Sir, Thank you so much. It helps me a lot to understand the function very well.

[shwan_ibrahim]

thank you teacher for another useful lesson

[Mr.DMT.]

thanks, can you show how to make colors change in cells depending on if statements

[IdriceFanel]

Really thank-you sir for the job you're doing, i couldn't understand it in others videos but you really explain it well really thanks 🙏

[HoneedewLUV]

I am smiling because I get it! 😁 I am new to this and I thank you for "dummying down", as we say, for us common folk to understand. LOL, just kidding. But seriously, thank you for using the kiss method and keeping it simple. I cannot wait to try this stuff at work. Many thanks.

[meraj]

Yoo it was very well explained. Iam now staring to get it a bit 😅

[catboy]

Very helpful but if you ever update these videos it would be helpful if you’d go back and “read” the formulas that you create. Part of the difficulty for newbies is looking at the formula and interpreting it without the formula builder. Thanks.

[iriniviore]

Can we avoid the nested if by using the ifs?