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