AND function in Excel

Syntax

=AND(logical1, [logical2], …)

Example

=AND(B2>=50,C2>=75) is TRUE only if the score is at least 50 and attendance at least 75.

From the lesson AND, OR, XOR Functions.

Common mistakes

• Writing B2>=50 AND C2>=75 instead of AND(B2>=50,C2>=75).
• Expecting XOR to behave like OR when both tests are TRUE (it gives FALSE).

Related logical functions

• IFReturns one value if a test is TRUE and another if FALSE.
• IFSChecks conditions in order and returns the first TRUE match.
• IFERRORReturns a fallback when a formula errors.
• IFNAReturns a fallback only for #N/A errors.
• SWITCHMatches an expression against a list of values.
• ORTRUE if any argument is TRUE.
• XORTRUE if an odd number of arguments are TRUE.
• NOTReverses TRUE and FALSE.