AND

AND - Returns TRUE if all arguments are TRUE. If one of the elements is FALSE, this function returns the FALSE value. The arguments are either logical expressions themselves that return logical values, or arrays containing logical values.


Syntax:

AND(Logical value 1; Logical value 2 ...Logical value 30)

Logical value 1; Logical value 2 ...Logical value 30 are conditions to be checked.

Example:

=AND(2<3;5>=4;11+10=21) will return TRUE

=AND(2<3;5>=4;11+10=30) will return FALSE


Screen Shot: