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).
Microsoft support article on using the IF Function:
Access the sample data that I use in this video here:
Watch more Excel tutorial videos:
As full-disclosure, I work at Microsoft as a full-time employee.
Tag: if function excel, if, if function, if formula, how to use if, function, formula, excel, microsoft, microsoft excel, office, microsoft office, excel 365, 365, office 365, excel 2019, excel 2016, excel 2013, excel 2010, tutorial, guide, how to, help, step by step, rows, columns, ms, learn, if excel, excel if, if statement
Xem thêm: https://taichinh4u.net/category/review
⏭ Here's a playlist of all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Tommorow is my ict exams,
i hope i pass
Can you combine an if with a VLookup ? – i am using lookup to return a value, then need to create a formula using the returned data? Thank you,
very helpful thanks
Listen I followed your instructions and I got a D in class lol. 😬
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.
Can you a) make the text a color and/or b) make the cell change color
I feel like you are speaking a different language 🤯
19 idiots who cannot understand disliked the video
Hi Kevin! I'm doing excatly what you told in the video. However, instead of showing Over Budget-Investigate, the Status of the Entertainment I have is still "Within Budget". Why is that? What did I do wrong?
"OOoOOh I wonder if 525 is LESS than 600!!¿¡? Lemme just type out an extremely long over complicated formula to chECK THaT!" I fucking hate this job so much
Does if functions work with rang?
I have a question what if you need to know if it's greater than zero and if its equal to zero. What function is that?
Thank you so much kevin for explaining it nicely. Keep making such type of videos so that we can learn from you .
So I am trying to come up with a formula that used the IF function as well as the TODAY() function. Basically, I need to it to display a text IF TODAY() -30 is true. Please help with that format.
Could you color highlight the cell if the expense was over budget?
You are best teacher ever🥰🥰💯👌..
Thanks for helping us..
How can we email you??actually I want to send few pictures of formulae of excel from my book so i can learn from you..easily bcs my excel teacher is very rude..whenever i ask from him sth,he start scolding..so I feel much comfortable from learning you ❣❣..
Secondly..when I double click on the corner of cell ..three of if function answers (within budget),while ur third one resulted (over budget)
Hey Kevin. I have a question.. For example i use the function "IF" like this: =IF(A2=B2; B4; C4)… If its true, then it will appear the content of the cell B4.. However, when i want to appear the content of the cell with its special formatting, what can i do for this??
For example, if there is a thick outline out of the cell, i want to appear the content of the cell with the thick outline…
You will help me a lot!
Hi. I want my excel sheet to calculate using IF, or, and to calculate the following.
C4 =Kg then D4 shows 1000 and C4 = Meter then D4 shows 100 and sow on. how to make this to happen?
I’m struggling finding out how to do the if function using multiple worksheets 😥
Is it possible to use the if function to automatically go to the next cell below once the original cell value is now at zero? What is the bwxt function to use to for this. Many thanks
What is that separate dialog box?
your way of teaching is had to understand
Awesome , simple vedios for understanding easily.
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 #36………… Row 2. 6. 9.17. 28. 35
Hi Kevin, everyone. I need some body help me to created the IF function in Excel with this number: 10,11,9,12,8,13,7,14. my email:[email protected] Thanks a lot.
Just wondering if you could do something on Query's for the internet and from another workbook, a more advances formulas & functions, wrapping formulas, and basically using functions & formulas in intermediate stage and advanced stages. You are the only person on YouTube I can find that deals directly with MS Office 365, I am getting some glitches trying to merge between 2016 tutorials and yours on 365. I'd much prefer to learn from you where you are using 365, also could you tell me if 365 has that "What are you looking for" feature, there is only an average search which doesn't give the information 2016 claims to show the user.
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.
Thank you. It would be helpful to zoom in and show us what you are doing.
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.
Thank you for this.
I have an ICT exam coming up on Wednesday as part of an early years education qualification and I need to do some serious revision.
Your videos are excellent.
If H1 = 1, return the values from A1:E1. It returns only text. How can I do to return values (numbers)?
Dude!, u the man! U just cut through all the gobbledegoop in my textbook and gonna save me and many others so much time and headache. THANKS!
im using 2007 and =IF(B2<C2,"Within Budget","OverBudget – Investigate") dosen't work. How come? is there a reason kevin. Cause I watched most of your tutorials and i did great but with this one im having a hard time with =IF(B2<C2,"Within Budget","OverBudget – Investigate")
Nvm i fixed it. BTw as i said, I did great with excel i love your tutorials keep it up Kevin 😀
my problem =IF(B2<C2,"Within Budget","OverBudget – Investigate")
fixed =IF(C2<B2,"Within Budget","OverBudget – Investigate") i didn't follow this properly at first time :/
How do you add another formula into the if statement?
=if(c40>0,"C40*.2","0") – this just gives me the entry of c40*.2 instead of its formula value. How do I structure the formula to give the value for c40*.2 instead?
Hi Kevin, I'm beginner I would like see some basic Excel functions. Big Thanks from Italy
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.