Share via

  • Article

OR (Report Builder 1.0)

Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

Syntax

OR(logical, logical)

logical

Indicates the first condition to be tested.

logical

Indicates the second condition to be tested, if the first condition is False.

Remarks

  • The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.

  • If an array or reference contains empty cells, those values are ignored.

Example

Formula

Result

OR(Days to Manufacture > 10, Days to Manufacture < 2)

Returns a True or False value for each item. For example, True is displayed if manufacturing an item takes more than 10 days or less than 2 days.