Excel AND Function (Example + Video)
When to use Excel AND Function
Excel AND function can be used when you want to check multiple conditions.
What it Returns
It returns TRUE if all the conditions evaluate to TRUE, else it returns a FALSE (Note: it would return FALSE even if one condition is FALSE).
Syntax
=AND(logical1, [logical2],…)
Input Arguments
- logical1 – the first condition that you want to evaluate for TRUE or FALSE.
- [logical2] – (Optional) This is the second condition that you want to evaluate for TRUE or FALSE.
Additional Notes
- AND function can be used with other formulas to be more efficient.
- For example, in an IF Function, you can test a condition and then specify a value when it’s TRUE and a value when it is FALSE. Using AND function within IF enables users to test multiple conditions at one go.
- For example, if you have to test whether if A1 is greater than 0 and less than 100, here is how you can do it in an IF function:
=IF(AND(A1>0,A1<100),”Approve”,”Reject”)
- For example, if you have to test whether if A1 is greater than 0 and less than 100, here is how you can do it in an IF function:
- For example, in an IF Function, you can test a condition and then specify a value when it’s TRUE and a value when it is FALSE. Using AND function within IF enables users to test multiple conditions at one go.
- The arguments must either evaluate to logical values (TRUE/FALSE), or the arguments must be arrays/references of logical values.
- Text and empty cells are ignored.
- If the specified range contains no logical values, the AND function returns #VALUE! error.
- You can test a maximum of 255 conditions in a single AND function.
Excel AND Function – Live Example
Excel AND Function – Video Tutorial
Related Excel Functions:
2 thoughts on “Excel AND Function | Formula Examples + FREE Video”
It’s really helped in understanding lookup functions. Thanks!
Nice Article, thanks for sharing, Keep up the good work!