AND

Returns the logical AND of all the given Boolean values.

Syntax:

AND(list)

Returns the logical AND of the Boolean values in the list, which may be an array, a range of cells, or a comma-separated list of values.

If all parameters passed to the AND function are TRUE, the Boolean value TRUE is returned; otherwise FALSE is returned.

Unlike the corresponding logical operator &, all parameters of the AND function are always evaluated.

Example:

AND(A1, A2)

where the cell values are TRUE and FALSE will return the Boolean value FALSE.

Added in 1.36.