Excel IF Function




In this tutorial, you will learn about how to use excel IF function. Understanding how to use IF function excel can be very useful because IF is one of the formulas most used in this spreadsheet software. You must learn it especially if you often want to do something based on a particular condition of your data.


Why do We Need to Learn About IF Formula in Excel?


While using this spreadsheet software, sometimes we want to do something specifically based on the evaluation of data condition on our cells. For a simple example, to see whether we hit the target or not in the table of our production numbers, if the amount of production is the same or more than the target then probably we want to label it with the “ACHIEVED” word on a different column in the table. The opposite writing may also want to be done as we will use the word “NOT ACHIEVED” if the target is not achieved. This might be done so the data becomes easier to analyze and look at by ourselves or other people related to our job. In this case, understanding how to use the IF function in excel is very important.

Excel IF formula can be used for a wide scope of cases. Not limited to just giving some marks to our data. It can help us in evaluating the condition of our data and return a result based on the process. This is important if we have much data and we want a practical way to evaluate and compare it. Because it is often used, understanding how to use excel IF function is something that should be had by the frequent users of this software. You can get this by learning the next parts of this tutorial!


What is the Excel IF Function?


Excel IF Function is a function in this spreadsheet software to help filling cells based on the evaluation result from certain criteria. This formula is often combined with other formulas in the spreadsheet because it can help to give a result based on a certain condition.

A brief explanation of the inputs in it as follows:


=IF(logical_test, value_if_true, value_if_false)


Note:
  • logical_test = the condition to be evaluated
  • value_if_true = the result if it is right
  • value_if_false = the result if it is wrong



How to Use Excel IF Formula?


Here is how to use excel IF function with the steps told by the following.


Using IF

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Excel IF Function - Screenshot of Step 1

  2. Type IF (can be with large and small letters) and open bracket sign after =

    Excel IF Function - Screenshot of Step 2

  3. Type condition which you want to be evaluated to determine cell content then type comma sign ( , )

    Excel IF Function - Screenshot of Step 3

  4. Type cell content if the condition is evaluated true then type comma sign

    Excel IF Function - Screenshot of Step 4

  5. Type cell content if the condition is evaluated false

    Excel IF Function - Screenshot of Step 5

  6. Type close bracket sign

    Excel IF Function - Screenshot of Step 6

  7. Press Enter
  8. The process is done!

    Excel IF Function - Screenshot of Step 8



Exercise


After learning how to use excel IF formula, you can practice your understanding through the following exercise!

Download the file from the following link and answer the questions below. Please download the answer key file if you have tried to answer and sure about it.

Link of the exercise file:
Download here

Questions

Is the sales target of Niko, Cathy, and Acong achieved? Use IF to answer it with “Achieved” or “Not Achieved”!
Link of the answer key file:
Download here


Additional Note


IF is often used more than once in one writing. This is often called nested IFs. A more detailed explanation about how to use it that way can be learned in this part of the Compute Expert tutorial!



<

Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert