Logical AND operation.
AND requires at least one argument. You can use single arguments and/or scope arguments.
Example
Value 1 |
Value 2 |
AND |
FALSE |
FALSE |
FALSE |
FALSE |
TRUE |
FALSE |
TRUE |
FALSE |
FALSE |
TRUE |
TRUE |
TRUE |
=AND (TRUE;TRUE) returns the following:
=AND(A1>100;A2>100) returns TRUE.