Excel OR Function

Use:

Evaluates the logical or operation for multiple T/F comparisons. The result is true if at least one of the individual comparisons is true. The result is false if all of the individual comparisons all false.

Syntax:

OR( test-1 , test-2 , ... )

Examples:

OR( D12 > 500 , D12 < 750 )

OR( A1 < A2 , A2 < A3 , A3 < A4 , A4 < A5 )

OR( F12 = "John Mote" , F12 = "Ted Williams" )

Related Functions:

IF, AND