Logical
Modern
AND
Returns TRUE only if all conditions are TRUE.
Available in All versions
Syntax
AND(logical1, [logical2])What it returns
TRUE if every argument is TRUE; otherwise FALSE.
Arguments
| Argument | Required | Description |
|---|---|---|
logical1 |
Yes | The first condition to test. |
logical2 |
No | Additional conditions to test (up to 255). |
Example
| A | B | |
|---|---|---|
| 1 | Age | Member |
| 2 | 20 | No |
ResultFALSE
AND needs every condition TRUE. Age 20 ≥ 18 holds, but Member is not Yes, so the result is FALSE.
=AND(A2>=18, B2="Yes")Important to know
Returns TRUE only when every condition is TRUE.
Commonly used inside IF as the logical_test.