AND Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> 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

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

    AND Function in Excel - Screenshot of Step 1

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

    AND Function in Excel - Screenshot of Step 2

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

    AND Function in Excel - Screenshot of Step 3

  4. Type close bracket sign

    AND Function in Excel - Screenshot of Step 4

  5. Press Enter
  6. The process of AND function in excel is done!

    AND Function in Excel - Screenshot of Step 6



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
  1. 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!
  2. 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!
  3. 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




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