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

Tests if any of two or more conditions is met.

Syntax

IF x OR y THEN 1 ELSE 0

where:

  • x: Boolean argument to test.
  • y: Boolean argument to test.

Format

Input Format Output Format

x: Boolean

y: Boolean

Binary

Arguments

The function uses the following arguments:

  • x: Boolean: Expression that equates to a Boolean result
  • y: Boolean: Expression that equates to a Boolean result

Constraints

The function has no constraints.

Excel equivalent

Back to Top

Example

IF x > 1000 OR y = Products.Bananas THEN 1 ELSE 0

Returns 1 if x is greater than 1000 OR y is Bananas.

Back to Top

Similar functions