IF AND Excel Formula


Home >> How to Use Excel Tutorial >> Excel Formulas List >> IF AND Excel Formula



In this tutorial, you will learn IF AND excel formula combination. The understanding of IF AND function in excel is important. Especially if you want to evaluate more than one logic condition which all must be right in your IF writing.


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


In doing spreadsheet data processing, often we need to use the IF function. In using the function, sometimes we need to evaluate more than one logic condition for its input. This happens if there are several criteria that must be fulfilled before we can get a TRUE/FALSE result. In this situation, we need to understand how to do it so our data analysis process can be optimum.

As an example of this need in our work, let’s say we evaluate sales regions’ performance for our company. To get good result in the assessment, probably there are some criteria that must be achieved. Things like product sales quantity, loyal customers, or the kinds of products sold might become the criteria. At this moment, it will be helpful if we can use a condition formula with more than one logic condition evaluation. Not knowing how to do this will make our data processing becomes much more complex.

For this kind of situation, you need to understand how to implement the IF AND excel formula. Using the combination of these two formulas will make our work related to logic becomes easier. Probably, this combination is the thing that you need in your work right now.


What is IF AND Excel Formula?


IF AND excel formula is a formulas combination to get the evaluation result of more than one logic condition simultaneously. AND is a natural partner for IF because it can produce TRUE/FALSE from its formula process.

The general explanation on the inputs of IF AND excel formula combination will be given separately:


=IF(logical_test, value_if_true, value_if_false)


Note:
  • logical_test = the condition to evaluate
  • value_if_true = the result if the evaluation results in TRUE
  • value_if_false = the result if the evaluation results in FALSE



=AND(logical1, logical2, …)


Note:
logical1, logical2, … = all the condition evaluation that want to be combined to get the final logic value result


How to Use IF AND Function in Excel?


The following will explain how to use the IF AND excel formula. In here, AND becomes the input of IF in its logical test input part.


Using IF AND Formula in Excel

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

    IF AND Excel Formula - Screenshot of Step 1

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

    IF AND Excel Formula - Screenshot of Step 2

  3. Type AND (can be with large and small letters) and open bracket sign

    IF AND Excel Formula - Screenshot of Step 3

  4. Type all condition which wants to be processed separated by comma signs ( , )

    IF AND Excel Formula - Screenshot of Step 4

  5. Type close bracket sign when all your conditions have been inputted then type a comma sign

    IF AND Excel Formula - Screenshot of Step 5

  6. Type cell content if all of the conditions is evaluated true then type a comma sign

    IF AND Excel Formula - Screenshot of Step 6

  7. Type cell content if one of the conditions is evaluated false

    IF AND Excel Formula - Screenshot of Step 7

  8. Type close bracket sign

    IF AND Excel Formula - Screenshot of Step 8

  9. Press Enter
  10. The process is done!

    IF AND Excel Formula - Screenshot of Step 10



Exercise


After you have understood how to do the combination of IF AND excel formula, now let’s do an exercise. This exercise is done so you can become better in your implementation of the formulas’ combination.

Download the exercise file and answer the questions below. Download the answer key file if you have done the exercise and want to check your answers. Or probably when you are confused on how to do the exercise and want to see some clues.

Link of the exercise file:
Download here

Questions

Answer each question in the appropriate gray-colored cells!
  1. Passing criteria 1 is score 1 and 2 must be above 50. What is the passing status for each person? Answer with “Pass” and Fail”!
  2. Passing criteria 2 is score 1 and 3 must be above 60. What is the passing status for each person? Answer with “Pass” and Fail”!
  3. Passing criteria 3 is score 1, 2, and 3 must be above 55. What is the passing status for each person? Answer with “Pass” and Fail”!

Link of the answer key file:
Download here


Additional Note


If you need to evaluate more than one condition where one right results in TRUE, use the IF OR combination. The explanation about this combination can be read in another tutorial on Compute Expert!



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