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.