AND

Returns TRUE if all of the specified arguments evaluate to TRUE; returns FALSE if one or more of the arguments evaluate to FALSE.

Syntax

AND( Logical l1, [Logical l2], ... ) → Logical

Parameters

l1
l2
…

One or more logical values to test.

Remarks

The arguments must evaluate to logical values or arrays of logical values. If the specified range contains an argument that does not meet this requirement, the AND function returns the #VALUE! error value.

Example

Formula

=AND(A1)
=AND(B1:B5,A1>0)

See Also

Function Reference
OR Function
IF Function