/How to use IF Function in Microsoft Excel 2013

How to use IF Function in Microsoft Excel 2013

If you have ever attend any interview as a Data Entry or Excel Expert, one of the function that one would expect that you must know how to use is the IF Function statement. As we all know IF a conditional statement is. If I tell you now that If I have money, I will buy a car. That means my purchase of a car is subject to the availability of fund.

 

 

Let’s come down with IF Function statement
Anytime I am with my students and I am trying to explain how to use IF Function statement to them. One of the ready-made question is that: How does this apply to real life? Let us say for example, you have some Sales Rep that needs to be motivated. You can use the Function to determine how many of them are qualified for your reward. Just like the example I will be using now, we have decided that any of our Sales Rep that makes $1,000 and above shall be rewarded. If you make below that, nothing shall be given to you. Let us see how we can use If Function to achieve that.

 

if function

 

I am going to address the first question that says Sales Person receives 9% commission of the total sales if he is able to make $1000 or above or else no commission.  First and foremost, we are going to head over to the Function Library and look for IF Function.

 

You will always find the If Function under the Formula Tab. You can also click on fx in the Formula box and it will take you directly to the Function Library.

 

I am going to address the first question that says Sales Person receives 9% commission of the total sales if he is able to make $1000 or above or else no commission.  First and foremost, we are going to head over to the Function Library and look for IF Function.

 

Where you will find IF Function

You will always find the If Function under the Formula Tab. You can also click on fx in the Formula box and it will take you directly to the Function Library.

 

The first argument said Logical text. That means you need to come up with an argument that the formula will work with. Whenever any column is bolded this way, that means without it , you cannot find your answer.

 

Based on our argument, we are going to use the first sales to judge the overall sales. So, we are going to click on the first sales just like what am going to do in the screenshot below.

 

The F2 here is representing my sales. I believe this should be very easy for you to understand. You should not that no matter how the question is been framed, based on the law of BODMAS, equals to will not come before Greater than.

 

Let’s move on to the next argument.

 

 

The one said value if True,  that means what value should appear when the argument is true, you can put a value here or you can decide to put a Formula. In our own case , the salesman receives 9% . I will put 9% for now, but in my next article, I am going to teach you how to put simple calculation in that box.

 

The last part said vale if false, which means what should be the value if the argument is not true, I will simply put  NO COMMMISION to save the day.

 

Click on OK now you should see the answer to your question. If you have further question , make use of the comment box.

 

If you have any comment. Feel free to make use of the comment box.

 

Action Point

If you enjoy our article, sign up to get our next article in your inbox. You need to confirm your subscription by clicking on the link sent to your email. You can check the spam folder for it.

 

Add us to your mailing list to receive directly from us. Thanks.

 

Salau Adeniyi Olayinka (CEP, MCTP,CSCU, Hubspot Inbound Marketing Expert) is an accomplished Digital Marketer and E-Business Consultant . His passion is writing and sharing of knowledge and meeting people. He intends to use this blog to boost ICT and E-Business Knowledge in Nigeria and beyond.