AND
Description
Tests the specified conditions. Returns True if all conditions are True; otherwise,
returns False. Example: =AND(A5<B12,C4>D22).
Syntax
AND(
value1
,
value2
,...)
- value1: A condition to test.
- value2: A condition to test.
Example
Formula | Result |
|---|---|
=AND(A1<A2,A3>A4) where A1 contains 5, A2 contains 10, A3
contains 15, and A4 contains 20. | FALSE |