AND Function in Excel
In this tutorial, you will learn about AND formula in excel. AND function in excel is useful to give the last assessment to more than one criterion evaluation that we have. By using AND formula in excel, all of the criterion evaluation must have TRUE value if you want the final result to be TRUE.
Why We Need to Learn About AND Formula in Excel?
In using IF formula on this spreadsheet software, often we need the final evaluation process to more than one criterion evaluation as a part of the input for this formula. For that matter, if we just use manual writing for the input, then it will be very hard to input it properly just as we want it because of the limitation of manual writing for input in this spreadsheet tool.
For case example, where we might need the last assessment for more than one criterion evaluation for IF formula, we can see the condition where we want to see the performance status of a region which is one of the business focus of the company where we work for. Probably there is more than one indicator to see whether the region’s performance is good or bad. If we have complete data for each indicator of the region and we want to create a special column that contains performance status assessment for each region, then we must take a look at all indicators and compare them to the company standard to determine whether the region performance is good or bad according to the company.
If, for example, all of the indicator results must go through a minimum standard limit just so the region can be appraised to have a good performance indicator, then we need a function which can give an appraisal for the evaluation of all indicators before giving the last assessment result in the form of performance status.
In the case where all criteria evaluation need to have correct or TRUE result so the final result can be TRUE, then we need to have the skill in how to use AND function in excel. AND formula in excel will help us in giving the last assessment for all criteria evaluation indicators with the process as being explained earlier. All of the criteria evaluation results need to be TRUE so the final result of the AND function in excel can be correct or TRUE.
What is AND Function in Excel?
AND function in excel is a formula with the usage objective to give the final evaluation to more than one criterion evaluation results with all of them must be TRUE so it can give the final result of TRUE. If just one of them is wrong or has a FALSE value then the final result will be wrong or FALSE. AND formula in excel is mostly used along with IF although we cannot close the possibility that it can be used independently or with another formula in this spreadsheet software, especially the one that also needs criteria evaluation to determine its final result.
A bit explanation about the inputs in this formula is as follows:
=AND(logical1, logical2, …)
Note:
logical1, logical2, … = all the condition evaluation that you want to combine to see the logical value result of the combination
How to Use AND Formula in Excel?
The next part will explain how to use AND function in excel. AND formula in excel needs the input of all the criteria evaluation that want to be evaluated to get the TRUE or FALSE final result. TRUE will be produced if all of the inputs are TRUE and FALSE will be produced if one of the inputs has FALSE value.
Using AND Function in Excel

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

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

Type all criteria evaluation which want to be processed separated by a comma sign

Type close bracket sign
 Press Enter

The process of AND function in excel is done!
Exercise
After you have learned detail steps of AND formula in excel usage from the tutorial, you can practice your understanding so you can be more adept by doing this exercise!
Download the file from the following link and answer the questions. Please download the answer file if you have done answering all the questions and sure about the results!
Link to download exercise file of AND formula in excel:
Download here
Questions
Learn how to use IF formula first in another part of this Compute Expert blog before answering all questions below How is the comparison of variable A indicators to the value in the first row on the corresponding column? Give ‘OK’ if all indicators exceed their value comparison and ‘X’ if not!
 How is the comparison of variable B indicators to the value in the first row on the corresponding column? Give ‘OK’ if all indicators exceed their value comparison and ‘X’ if not!
 How is the comparison of variable C indicators to the value in the first row on the corresponding column? Give ‘OK’ if all indicators exceed their value comparison and ‘X’ if not!
Link to download answer:
Download here
Additional Notes
 The input in AND formula in excel can also be directly given TRUE or FALSE form. Although we rarely do direct input like this in the AND function in excel usage
 For the optimal usage of AND formula in excel, you need to understand how to use IF and nested IF formula in this spreadsheet tool. If you want to learn it, then there is a tutorial for this formula also in another part of this Compute Expert blog!
 There is also another formula that gives the final assessment for the inputs of criteria evaluations which is OR. The final result given by OR will be TRUE if one of the inputs give TRUE and FALSE if all of them are FALSE. The writing of this OR formula is similar to AND function in excel