AND

Returns TRUE if all the evaluated expressions are TRUE. Returns false if any expressions are false.  Empty cells are ignored.

Syntax

AND(expression,{expression},...)

Arguments

expression Values or cell references to examine.

Example

AND(TRUE,FALSE) returns FALSE