OR

Use the OR function to test whether one of a series of conditions is true.

OR evaluates a series of conditions and returns "true" if at least one evaluates to "true"; otherwise returns "false".

Syntax:

OR (series-condition-expression)

Meaning:

OR (conditions_to_evaluate)

Returns:

"True" or "false"

OR evaluates to "true" if any member of the argument evaluates to "true" and evaluates to "false" if all members of the argument evaluate to "false".

Examples

• Order(s)=IF (OR (Store:Table = Store#:Order:Input), Order:Input)

  This example produces an Order if the Store# of an Order in Input matches any Store in Table.

Related function

• ALL