AND function

Category: Logical functions

What does this function do?

Evaluates the arguments indicated and returns TRUE if all arguments are true, or FALSE if any argument is not met.

Syntax:

AND(logical1, [logical2]...[logicalN]) with N=255



logical1 (required): First condition to evaluate.

logical2 (optional): Additional conditions to evaluate.

Examples:

If A1 = 1 and B1 = 10

= AND (A1> 6, B1> 9) = FALSE
= AND (A1> 6, B1 <9) = FALSE
= AND (A1> 0, B1> 0) = TRUE