# IF Function in Excel Tutorial

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

Nguồn: https://taichinh4u.net

Rate this post

#### 41 bình luận

1. 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.

2. 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?

3. "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

4. 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.

5. Hey sir😍😍..
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)
How??

6. 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!

7. 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?
Thank you

8. 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

9. 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

10. 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.

11. 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.

12. 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.

13. 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 :/

14. How do you add another formula into the if statement?

Example
=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?

15. 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.