Calculates the Boolean (logical) AND of a number of Boolean values.
Syntax:
AND( Boolean_values:List )
Returns the Boolean (logical) AND of all the Boolean values in the list.
If all parameters passed to the AND
function are TRUE
,
the Boolean value TRUE
is returned; otherwise FALSE
is returned.
Note:
Unlike the corresponding AND Boolean 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 Fireworkz 2.00.