Introduction to AND Function
Logical functions in Excel are predefined formulas that evaluate a given condition or set of conditions and return a Boolean value (TRUE or FALSE) based on whether the condition is met or not. They are used to test the truth or falsehood of a statement or a condition, and to make decisions based on the result. In this blogpost, we will discuss about AND Function.
AND function returns a Boolean value (TRUE or FALSE) after testing conditions you specify. In simple words, you can test multiple conditions with AND function and it returns TRUE if all those conditions are TRUE, else FALSE.
Download Sample File
Download SAMPLE FILE to work, practice and master the LOGICAL Functions in Excel.
Syntax of AND Function
AND(logical1, [logical2], …)
Arguments of AND Function
- logical1: Condition which you want to verify.
- [logical2]: Additional Conditions you want to verify.
Notes
- Values will be ignored if the reference cell or array contained an empty cell or a text.
- It will return an error if there is no logical value is returned that means the result of conditions should be in logical value (TRUE or FALSE).
- The maximum number of values you can test is 255.
Example of AND Function in MS Excel
In the below example, we have created a condition using IF function that if a student score 60 above marks in both of the subjects then only it will return TRUE else FALSE.
You can also use AND function to work with numbers as well.
Other Excel Logical Functions Tutorials
You can explore and master other Logical functions in Microsoft Excel. Here is a complete list of Logical functions available in Microsoft Excel.
