OR

Returns TRUE if any of the specified arguments evaluate to TRUE; returns FALSE if all arguments evaluate to FALSE.

Syntax

OR( 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 OR function returns the #VALUE! error value.

Example

Formula

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

See Also

Function Reference
AND Function
IF Function