AND

Returns TRUE if all arguments are TRUE. Returns FALSE if any of the arguments is FALSE.

Sample Usage

AND(TRUE,FALSE)
AND(C5,C6)
AND(A2>1,A2<100)

Syntax

AND(logical_expression1, logical_expression2)

• logical_expression1 - An expression or reference to a cell containing an expression that represents some logical value. Each expression must be either TRUE or FALSE.
  
• logical_expression2 - [OPTIONAL] An expression or reference to a cell containing an expression that represents some logical value. Each expression must be either TRUE or FALSE.

Examples

AND(TRUE,TRUE) returns a value of TRUE.
AND(TRUE,FALSE) returns a value of FALSE.
AND(FALSE,FALSE) returns a value of FALSE.
AND(A2>1, A2<100) returns TRUE if A2 is greater than 1 and less than 100, otherwise it displays FALSE.