<< Click to Display Table of Contents >> AND (logical AND function)

Syntax:

AND(Value1 [, Value2, Value3 ...])

Description:

This returns the logical value TRUE if all of the given arguments are TRUE, otherwise it returns FALSE.

You can use it to check, for example, whether several conditions all apply.

Example:

AND(TRUE, TRUE) returns TRUE

AND(TRUE, FALSE) returns FALSE

AND(FALSE, FALSE) returns FALSE

AND(A1>0, A1<1) returns TRUE if A1 is greater than zero and less than one.

See also:

OR, XOR, NOT