OR (Report Builder)
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. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Logical Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)