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