AND

Calculates the logical AND of a number of Boolean values.

Syntax:

AND(list)

Returns the logical AND of all the Boolean values in the list.

list 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 AND 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.

Revisions:

This function was added in 2.00.