AND

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

=AND(A1>100;A2>100) returns TRUE.

AND