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

Syntax:

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

Description:

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

You can use it to evaluate, for example, if several conditions are fulfilled all together.

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