OR (PQL - xl)

This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

OR(logical1, logical2)

Function Arguments

Name

Description

Type

Optional

logical1

Provide numeric (1 or 0) or logical values (TRUE or FALSE). You can also specify a single array instead of listing the values separately. Similarly, you can specify an expression

StringOrNumber

logical2

Provide numeric (1 or 0) or logical values (TRUE or FALSE). You can also specify a single array instead of listing the values separately. Similarly, you can specify an expression

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'OR' function - using the same inputs, logic and outputs.