1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. OR

Tests to see if any of two or more conditions is met.

Syntax

x>1000 OR y>1000

Boolean TRUE where either x or y is greater than 1000.

E = OR(A, B, C, D)

E is true if any one of A or B or C or D is true.

Format

Input Format Output Format

x: Boolean

y: Boolean

Boolean

Arguments

The function uses the following arguments:

x>1000 OR y>1000

x: Boolean: Expression that equates to a Boolean result.

y: Boolean: Expression that equates to a Boolean result.

E = OR(A, B, C, D)

E: Boolean: Expression that equates to a Boolean result.

A: Boolean: Expression that equates to a Boolean result.

B: Boolean: Expression that equates to a Boolean result.

C: Boolean: Expression that equates to a Boolean result.

D: Boolean: Expression that equates to a Boolean result.

Constraints

The function has no constraints.

Excel equivalent

Back to Top

Example

x > 1000 OR y >1000

the result is a Boolean check box that's TRUE if either x or y is greater than 1000.

E = OR(A, B, C, D)

E is a Boolean check box that's TRUE if any one of A, B, C, or D is true.

Back to Top

Similar functions