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

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

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

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

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

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

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

Type cell content if one of the conditions is evaluated false

Type close bracket sign
 Press Enter

The process is done!
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 graycolored cells! 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”!
 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”!
 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!