Everything You Need To Know About The If Formula In Excel

Learn how to use the IF Function to write formulas that return results based on a condition or logical test. This tutorial also includes training on logical tests, comparison operators, nested IF formulas, multiple conditions with AND and OR functions, and common causes of formula errors.

Related Videos:

Excel Tables Tutorial: Beginners Guide for Windows & Mac:

VLOOKUP Tutorial for Excel - Everything You Need To Know:

#MsExcel #ExcelCampus
00:00 Introduction
00:40 If Formula Tutorial for Excel
01:04 If Function Explained
03:48 Write an If Formula
05:01 Optional Arguments
05:46 Grouping Data with IF
07:47 Cell Reference Technique
12:08 Nested IF Formulas
15:53 Causes of Errors
17:54 If Formula Challenge

[johnfox]

As always You are a natural teacher. Just the right pace for newbies and no padding in there at all. Concise and easy to understand. Thank you.

[MrBileDuct]

Jon, I just have to say what an awesome tutor you are! It's partially about what you reveal but mostly about how you do You are as logical as an Excel spreadsheet but > it is your ability to express the process with concise clarity that makes you excel. I have learned - and more importantly, understood, so much through your tutorials. Keep on, keeping on - ad infinitum!

[jamiephillips]

These are really helpful videos thank you. I’ve paid for a course recently and I find your videos much better and understand and practice with

[jessicaleng]

Thank you Jon for showing how to use this really useful function on building simple report.

[Jay-ugni]

This video is a life saver every time I needed a refresher on nested ifs. Thank you Jon!

[valeriephillips]

This is the best video I have seen on the topic. Great examples and easy to follow along!

[lilminishlomit]

Thank you Jon, you are truly a gift. I improved my excel skill by watching your tutorials. God bless you!

[database_tips_tricks]

real excel expert this man, tks goodness for him

[jabsbabson]

An excellent description of the IF formula usage. Thumb up!

[JuniorKnowledge]

thanks from somalia Jon, they helped me too much.

[minyongchen]

Thank you, Jon. Your videos are very helpful.

[detroitresearcher]

HOLY CRAP. THANK YOU! YOU ARE SO EASY TO FOLLOW!

[angelikajoycequiogue]

Thank you so much! You tutorials were better than the course I recently paid for.

[kirstenholland]

Really enjoyed this one and the pace of explanation.

[MrDhunpagla]

What a refreshing of knowledge !!! Thanks Jon ...keep sharing please

[ARIFSAIFIFARHAN]

Excellent Job!
i learned clearly and sharply use of inbuilt function of IF

[beatricejerop]

I always find your tutorials simple and easy to follow, Naturally a teacher keep it up

[ncfundi]

Hi Jon, thank you so much for these videos. They are definitely very helpful. Question for you though….is there a way to look at a group of logical test v. individual logical test to yield a result? I’ve created a enormous embedded IFAnd statement ( to where I’ve reached the maximum allowed by my version of excel) but I need to figure out a way to consolidate so that the formula isn’t so large. Any insight that you can provide would be greatly appreciated. Thanks

[gautamkhandke]

Thanks for your video. It was very well explained and easy to understand.🙏

[yeshir]

Thank you very much for this tutorial, I appreciate.