IF Function in Excel Tutorial

Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect. An IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

As full-disclosure, I work at Microsoft as a full-time employee.

[moshelieberman]

Kevin, you never let me down. You are so articulate, and thanks to your expertise in teaching, I am gaining a vast array in many different areas of Excel.

[Shelita]

Thank you Kevin :) You make learning all of these functions so much easier. You are the best!!!

[natalyaroberts]

I feel like you are speaking a different language 🤯

[quackykwulala]

Omg, I had to comment because you just saved my night, I have this late assignment thing due and I had no idea how to use excel and I was LITERALLY ABOUT to SPEND ALL NIGHT writing out the function for every box literally am so thankful for this video bless you, my guy.

[nathanmaldonado]

It didn't help me from what I needed it for but you got a thumbs up for doing it on the dialog box. Thank you.

[advisedenvy]

Hey Kevin I just wanted to thank you for the videos you make it helped me start my YouTube channel knowing witch recorder and video editor to use so thanks and keep up the awesome work.

[juhimalhotra]

Thank you so much kevin for explaining it nicely. Keep making such type of videos so that we can learn from you .

[llaw]

Can you do a video on more advanced IF formulas, i.e. the nested ones? Thanks Kevin!

[jannaliebanico]

Thank you for this video, it was clearly explained that made me learn it faster than any other tutorials that I tried to watch.

[joedesilva]

Thank you, made it simple for my introduction to IF function.

[bridgerpetersen]

You’re the reason I have an A in my class. Thank you

[FaithOnahTV]

I just used the lesson learnt to answer a question in few seconds😊 Thank you Kelvin.

[Kemar_peart]

Hi kevin. Can you walk me through the steps on how to use the (if function) to get a range of random numbers in a row in one column. eg: RANGE #1 to Row 2. 6. 9.17. 28. 35

[tekonjonjo]

Very helpful. Couldn't remember how to use the IF function. Video was great help.

[tahirnectar]

Very Helpful and yes I'd like to see this type of video in the future as you explain things very well.
Keep up the good work.

[NoelRemasu-gjxw]

This video is what I needed for the last 7 years of my life.

[Mayatron]

Honestly, I have yet to see another youtube actual given the sample document. Its very hard to follow videos like this without having the data set. Very grateful, thank-you. Slowly learning excel skills I'll need.

[billreinhold]

Could you color highlight the cell if the expense was over budget?

[DarrenAnna]

Thank you so much; you made it so easy to understand!

[taliap]

thank you so much. I am budgeting at the moment and new to excel. This video gave me a lot of information on how to effectively plan my spend!