Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
3,542,338
Published 2018-02-01
Learn how to use Excel's IF Function in your reports. Ideal for Microsoft Excel users who want to delve into conditional formulas, understand when to use nested IFs, and combine IF with AND/OR functions for more complex scenarios.
⬇️ Download the file I used in the video from here: pages.xelplus.com/if-function-file
In This Video, You'll Learn:
▪️ Excel IF Basics: Start with the fundamentals of the IF function, including its structure and simple applications.
▪️ Nested IFs: Understand when and how to use nested IFs, especially when dealing with multiple conditions.
▪️ Combining IF with AND/OR: Learn to enhance the IF function by incorporating AND and OR for broader logical tests.
▪️ Practical Examples: Follow along with real-world examples, including setting thresholds, flagging data points, and using symbols in IF statements.
00:00 When to use the Excel IF function
00:35 When to use a Nested IF formula
00:55 Excel IF THEN formula
03:18 Excel IF formula with AND condition
05:05 Nested Excel IF formula
07:52 Excel IF formula with OR condition
09:17 Excel IF formula with threshold
11:22 Excel IF formula with symbols for result
14:29 Wrap-Up of different uses of Excel IF function
Your IF formula isn't working? One of the main mistakes is the "else" argument. That's the last argument inside the IF function. Make sure you haven't forgotten to specify what should happen "if" the condition isn't met. In case you have more than one condition, here's the place to add the second "if" statement. An IF formula inside another IF formula is called a nested if function.
Links to related videos:
Conditional formatting symbols:    • Excel Conditional Formatting with Sym... Â
Custom formatting symbols:    • Four SMART Ways to use Custom Formatt... Â
If Function with Partial text match:    • Excel IF Function with PARTIAL Text M... Â
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: www.instagram.com/lgharani
LinkedIn: www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
All Comments (21)
-
:_leilaLightbulb: Grab the file I used in the video from here 👉 pages.xelplus.com/if-function-file
-
Since discovering your channel I've improved my excel skills by a loooot. Thank you!
-
Hi Leila Your explanations and exolaining technique is brilliant. A real nice work. Keep up the fabulous job. It is really helpful for so many users like me. Thanks again for the brilliant explanation.
-
Leila, you have the best Excel tutorials I've found on YouTube. By far. Clear, concise, excellent examples. Thanks so much!
-
As a computer trainer for over 30 years, I'd have to say you are by far the best online video tutorial creator that's on YouTube. Every single one of your videos is very clear and easy to understand and the fact that you provide the files for people to use/practice with makes your videos truly exceptional. Thank you!
-
As an instructor myself, I appreciate your skills. This video and the several others I have watched cover the material efficiently, without breaking the material down to a painfully basic level. There is no magic amount of detail for every audience as their diverse skill set is the uncontrollable variable, but you are nailing it for my needs. Thank you, and keep them coming!
-
Wow, girl, you are very good. Thank you very much. You explained it very well. You remind me of my maths tutor who taught me maths so well that I passed with an A+ even though I used to suck so badly at maths in the past. Keep the good work, please. The world needs great teachers like you.
-
I really like the way you use your examples to explain things further and more clearly. You've saved me about 3 days of work so far with the videos I've watched this month. Thank you.
-
Thank you Leila, I have watched other people's Excel Video's but tend to get lost in the technical jargon, however, since I found your video's, I am soaring ahead due to your no nonsense, easy to learn approach to each and every part of the exercise, and they guarantee success every time. I won't watch anyone else's video's anymore because your video lectures are easily miles ahead of the field and as a consequence I have now subscribed and will recommend you to all my family and friends.
-
This is 1000x better than a course I paid for. I'm glad I found you on YouTube and I've subscribed. Thanks so much!
-
Honestly I have never understand if function like this before even after my Two months class.. God bless you for this wonderful teaching
-
Great explanation. I'd been looking for a good example of the OR function for days. This is the first I've found that really explains it.
-
By far the best and correct tutorial, I have did excel 11 years ago but forgot a lot and many videos ppl use to feed their ego and showing ppl incorrect ways to do it and this is how I remember. Being taught at Tafe. Full formula no shortcuts no fancy ways of explaining. Perfect and to the point. Calm voice, clear instructions and best of clear voice and at perfect tempo. Any faster talk and you could miss half the talk. Awesome
-
Lady you are such a great teacher, please keep up the good work, I can't wait to see your next video, thank you so much.
-
outstanding demonstration..Thanks a lot..Highly Recommended
-
Madam youhave the most peaceful voice ive ever heard in my life, Godbless you
-
You present information in a polished but not over-produced way. It's less like teaching ideas and concepts and more like a confident professional passing on information to peers conversationally. You have a great combination of skills and attributes that allows the viewer engage almost like you are speaking with them personally. I'm subscribed, thank you.
-
You are the best Excel tutor ever..... Keep it up. And thank you so much for everything.
-
Besides learning how to correctly use conditional functions in formulas, I learned how to structure my table of requirements. Once I followed your table structure, the logic easily fell into place. Thank you and may God's face shine on you...
-
Thanks Leila, this video has been so helpful. I was about to take an Excel test in my interview, and your tutorial helped me to fix up what I did not know.
