Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

OU

On this page (10)

True when ANY condition holds.

FieldValue
CategoryLogic
TypeScalar (operates value by value)
Arity2 or more arguments
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: OU. Accepted aliases (case-insensitive): or.

Syntax#

code
OU(expr; arg2; …)

All arguments are expressions.

Returns#

Logical (1 = true, 0 = false).

Null handling#

Blank is treated as false (spreadsheet rule: 0 and blank text are false).

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: OR
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Accepts N conditions; DAX OR() accepts only 2 (for more, use || or nested OR).

Examples#

code
OU(receita > 1000; lucro > 0)

Example with values#

Input: 1 > 5 OR 2 > 1.

code
OU(1 > 5; 2 > 1)  →  1

Expected result: 1

Business example#

Apply a business rule — customer tier, order status, target hit or missed.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links