The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. We will get into all that in addition to some examples, tips, and tricks in this video.

My name is Tony and I have a degree in architecture and business administration. Excel is a powerful tool so don’t get discouraged. I’ve spent numerous hours, days, weeks working on my spreadsheets and years learning what I know. My hope is that my tutorials will be a quick way for you to learn what I know in a more condensed timeline.

The IF function is a must know essential tool that can be used in numerous applications and workflows. See my courses page for advanced uses of this function in combination with other functions or the related videos section for similar functions.