AND

LogicalExcel 2007

TRUE only if every condition is TRUE.

Syntax

AND(logical1, [logical2], …)

Examples

=IF(AND(A2>=40, B2>=40), "Pass", "Fail")

→ both subjects ≥ 40

Related functions

OR NOT IF

More Logical functions

FALSE IF IFERROR IFNA IFS LAMBDA LET NOT OR SWITCH TRUE XOR

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.