OR

Syntax:

OR ( argument-list )

Description: Tests if any one or more arguments in argument-list are TRUE.

Arguments:

Name	Type	Description
argument-list	logical, array, reference.	The arguments in argument-list designate the values to be tested. For an array or cell reference, a cell that contains text or is empty shall be ignored.

 

Return Type and Value: logical – TRUE if any one or more arguments in argument-list are TRUE; otherwise, FALSE.

However, if no logical values are found, the return value is unspecified.

[Example:

OR(TRUE) results in TRUE
OR(FALSE,FALSE) results in FALSE
OR(10=5,3=1+2,0) results in TRUE
OR({10,5,6,7},TRUE,E6:F6) results in TRUE, when E6 contains FALSE and F6 contains 0

end example]