AND
Returns TRUE if all of its arguments are TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
What it does
Returns TRUE only if all conditions are TRUE.
Syntax
AND(logical1, [logical2], ...)
Arguments
logical1(logical) — First condition to test.
Examples
All conditions must pass
Check if Score≥80 AND Attendance≥90%.
FORMULA
=AND(A2>=80,B2>=0.9)
RESULT
true
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Score | Attendance |
| 2 | 85 | 0.95 |
| 3 | 78 | 0.92 |
| 4 | 90 | 0.88 |