Intermediate
Logical
AND
Returns TRUE only if every condition given is true.
Compatibility: All Excel versions
Syntax
=AND(logical1, [logical2], ...)
Example
=AND(A1>=60,B1="Complete")
When to Use It
Combine with IF to check multiple conditions at once — e.g. only pass a student if their score is high enough AND their assignment is marked complete.