Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
HTML-код
- Опубликовано: 26 июн 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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...
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 Form...
Custom formatting symbols: • Four SMART Ways to use...
If Function with Partial text match: • Excel IF Function with...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 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: / lgharani
LinkedIn: / 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
Grab the file I used in the video from here 👉 pages.xelplus.com/if-function-file
=F2*G2, IF(H2=0,"5") how do i get this to work so that my value is never 0?
@@nicolezee950you are giving wrong equation
Your tutorials are great! I didn't quite understand what you were saying at the end of the "Nested Excel IF Formulas" section at around 7:50 ish when you were saying that Excel will "leave the formula" as soon as it recognizes a met condition?? I mean I think I understand what you meant but how would you have written out any of the formulas with multiple logical tests where, as you were writing it, it recognized a met condition before you finished writing it?
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 RUclips. 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!
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.
Wonderful! It's great to have you here.
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!
Thanks Jim! I'm glad you like the videos.
Leila, you have the best Excel tutorials I've found on RUclips. By far. Clear, concise, excellent examples. Thanks so much!
Not because she is female ...riiiighhhtt
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.
کانال های کود را فراموش نکنید قربان دستان پر مهر تان.........
Honestly I have never understand if function like this before even after my Two months class.. God bless you for this wonderful teaching
I'm glad I could help with that :)
Astonishing, isn't it?
Leila is a gem, really making an impact for millions of Excel users.
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.
Ohhh thank you Su Sue! That means a lot! I'm very happy you find the explanation easy to follow :)
You are very good explained so thank you.
@@LeilaGharani Thanks you are so good. your explanation is very easy. Thanks a lot again
28iejhd6ffiffffcfffrrŕrfFFFdded
S
outstanding demonstration..Thanks a lot..Highly Recommended
Mind blowing clear explanation
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.
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.
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.
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
Madam youhave the most peaceful voice ive ever heard in my life, Godbless you
Excel is one of those programs where most people have a basic knowledge, and most people just assume you know how to use, I had a coworker who had a background in Accounting, and she could run laps around me in Excel and I was just scratching my head and asking "could you do it one more time, but slower?" having Leila explain it makes it so much easier to learn. I wish there were more people like Leila who are willing to help out in Excel.
I used to be one of those people ... until I realized there is much more to learn :) I'm happy the tutorials are helpful for you. Keep learning!
This is 1000x better than a course I paid for. I'm glad I found you on RUclips and I've subscribed. Thanks so much!
I want to be able to run .30 to 1 on excel, please how can I do that ?
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.
That's very kind! Thank you.
After searching for an hour how to use "if" multiple times: you are the only one come up with this most accurate and proper formula. Thank you so much Leila from the bottom of my heart for this well prepared tutorial.
You're very welcome. Glad the tutorial is helpful.
This lady is phenomenal, fantastic at explaining everything in detail. I am super happy and excited about taking all these courses. Thank you so much Leila, you are fantastic !!
Thank you so much!
your explanation is really good, thank you!
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...
Thank you so much Leila ! So simple but yet so effective ways of teaching !!
Leila you're the best, thank you so much!
You are the best Excel tutor ever..... Keep it up. And thank you so much for everything.
Thank you leila
Queen of excell
Thanks alot, following you from 2 years ago and you have never failed me.
Your videos are awesome. Thanks for the work you do and the help you have given us over the years.
As usual, thank you for the video you make our work much easier!! Thank you
I'm very happy to hear that Hossam. Thank you for your nice comment.
Very useful. Thanks Leila
You're very welcome Alex.
I've watched several tutorials on Excel by other instructors. In my opinion, you are by far the best! Thank you for sharing your knowledge in such a clear and understandable way.
Thank you for the kind words.
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.
Amazing Work! Thank you for your kind help. You are saving millions :D Indeed. Just Loved the video.
easy simp boy
You deserve a lot more than just 76k subs. Hopefully, all good things comes to you. Thank you leila.
Now check her subs :). Your wish has worked pretty well.
729K ❤️
902k subs
@@danelleforbes5771 950k subs
998k
Thank you! After two days of googling and youtubing, you're the first person/video to make sense of nested IF forumulae. please post more of the more complicated nested IF/AND/OR, etc statements. you're a natural teacher.
Glad it was helpful!
I'm glad I found you on RUclips and I've subscribed. Thanks so much!
Well! perfect explanation we are moving into another level, thanks and stay blessed.
Fantastic so useful. Been pulling my hair out with this. Thank you
Perfect video, You did a great job in this video. You covered the "IF-" function very well. Thank you and keep it up.
I love how you’re conveying your information in a mathematical way , which helps in grasping not just memorizing, i rarely comment in youtube but i have to this time !
This is much better than the college course that I paid for! Thank you! plus, you have a very calming voice.
Thank you!
It is great learning experience with you
@@LeilaGharani mam you teaches excellent
Thanks Leila, your name is very precious to me (my mum's name), plus you're exceptionally good on explaining!, God bless and happy new year Leila.
Your voice is so calm and relaxing
So good, clear and easy to understand. Thank you so much
I loved it. I've done using windings font. 😂😂😂
Your work is nice
Glad you like it Imran.
I watch your videos your teaching style is very easy to understand and very simple
Great pics,
You have helped me upskill!!! Thank you so very much for explaining concepts that I just couldn't get before your videos... you are much appreciated lady!!!
so glad that I've found this. I doing a workbook on Body Mass Index of a population (1,800+ people) with multiple factors aside from Age, Height, and Weight, such as Age Groups, Waist and wrist circumference, and Body Frame values.
Leila, your videos are so clear and present amazing Excel capabilities that I haven't met in my 20 years with Excel. I've not yet finished this video, but I'm wondering why you didn't give C2 a name instead of referencing it as $C$2. I like names because they make formulas easier to read when I come back later and wonder what I was doing - such as "If (YTDRevenue > etc. Probably you discuss names in other videos that I haven't yet watched.
A Big fun of you from African horn, ETHIOPIA. May God pay you for your effort.
Thank you for posting this video. The OR statement was what I needed to perfect my excel formula.
Glad to help Carol :)
Amazing work!!! If all professors could explain as clear as you do, we would live in a less stressed world, haha! Great Job!!!
Thanks Marco! 😃
Rightly said Marco...m a big fan of this teacher
@@LeilaGharani Hey
The Way you teach us is amazing
Can you tell how time you take to be such a expert in this
Great video. Would you also be able to throw some light on how do you insert different scenarios like
>100025000
Assume that you have the value in cell B17 and you insert this function in C17 cell
=IF(B171000,B17=25000,B1739000,30%))))
This function will do what you have requested
Calm, compose and comprehensive. You are dream of every XL student❤️
You have helped me AGAIN, thank you so much! You break everything down so well. :)
Nice explanation. I was completely befuddled until I watched your video. Now I am not. Thank you.
Rick
Did anyone tell you? You're pretty easy on the eyes.
Study the two functions separately then you'll see how easy they fit together. First up is INDEX(col, row) then MATCH(lookup cell, column to find it, 0 for exact match). Since
MATCH finds the row, it becomes the second argument for INDEX.
Gustav Mahler Are you making a joke?
OMG If it wasn't for this video I don't think that I would have ever figured out how to configure multiple IF functions using greater and less than symbols! I searched for several examples and this was by far the best one. It was easy to follow and understand! I am definetly a subscriber now!
Great to hear!
you are doing a great service to all who need to learn Excel,, so thank you so much
Thank you Leila! This is a good lecture. If you can provide the excel exercise with headings only, we can practice simultaneously with your video. It will speed up our learning. A miracle will happen.
Loved the simplicity of how you teach.
Assignment done.
Thanks Leila (Y)
Stay blessed.
Thank you very much, Leila! I'm using the compound logic function for phone numbers in my P.O. spreadsheet. Depending on the supplier entered, their phone number appears in the corresponding cell! It's a game changer!
Your videos are extremely valuable. Getting better at excel improved many areas in my life, I truly appreciate your valuable content.
Wow - you are the best in explaining - you really broke it down in chunks and brought at all together.
Leila you explain difficult things so simply that is great.
Where were you all my life?!
Keep this up please.
Leila’s Excel videos are the best. Thank you.
My every solution for Excel problem is @Leila Gharani Videos. Thanks a lot.
You don't rush while explaining. That way concepts inside the minds of students sink very easily and not in a garbled manner. Your examples with each step explained so clearly further help students like is understand better. Thanks a lot.
Thank you for this video, the "or" condition saved my time😀
I just got my associates and working towards my cs bachelor's. I have been importing excel sheets into mysql because i was unaware you could use elif statements in excel. This saves so much time and makes it easier to cleanse and organize. Best randomly suggested video ive ever watched.
That's great!
I am so green with Excel, thank you for these videos, it is a great help!
Hey, really love this video and criteria condition's are awesome !
Excellent demonstration. Thank you!
so well explain, you blow your peers away in the way you explain and demonstrate. thank you
God bless your soul, just found what I needed, cheers from brazil
The ONLY Excel video you'll EVER need!
Enjoyed the cleared and simple step by step instructions
Thank you for your clear explanation. This is what is required when you are teaching excel, someone ...learning becomes sooo easy
Outstanding Demonstration thanks a lot Highly Recommended.
Thanks Leila, you're the BEST trainer/lector which I ever met.
Thank you for the kind words 🙏
Thanks so much dear Leila
They're so interesting...
Glad you like it!
Brilliant! Thank You!
You are really awesome, as a CS Student I still find that Excel formula is hard to understand, And you explained it real good.
It's just simple programming,
The reason why it's confusing is the shitty excel syntax and the fact that it forces you to write it in a single line so it quickly become a complicated mess.
Awesome. Clear and useable. Thanks.
The best IF video i have seen til now, what i like hte most is the file so i can practice myself. Thanks very much
YOU ARE AN EXCEL GODDESSSSSSSSSSSSSS!!!!!!!!!!!!!!!
Great work! Very clearly explained, thank you very much.
This is my first video looking up how to use the if/or function, your examples are great and the explanations are very clear. Thanks for delivering such a clear instructions, you got another subscriber.
Glad the video is helpful Jon. Great to have you here!
Very simple tutorial. Thank you so much!
You are a truly master!! Thanks so much!
I love your videos. Your explanations make things a lot easier! You are the best by far. I appreciate you! :)
Just wanted to drop a comment that I automatically understood and applied the formula after watching this video so thank you so sooo much!
That's great to hear!
Toujours d'une grande clarté, Leila !
Thank you for the video. I love your voice, delivery style and the video was smooth flowing (no mistakes in terms of the sequence of order of process). Again, ty.
Thanks for the kind feedback :)
Great tutorial to learn nested if formula! Thank you very much!
So much appreciated!! I stuck somewhere. Bcz of your video, made it clear. Looking forward to your more videos!!!Love from india♥️
THANK YOU. WAS EXPLAINED CLEARLY
This video is amazing, easy to follow and comprehend. Thank you