Skip to content

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

NAO

On this page (10)

Negates the condition.

FieldValue
CategoryLogic
TypeScalar (operates value by value)
Arity1 argument (fixed)
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: NAO. Accepted aliases (case-insensitive): not.

Syntax#

code
NAO(expr)

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: NOT
  • Compatibility: Compatible with DAX
  • Note: Negates the condition.

Examples#

code
NAO(receita > 100)

Example with values#

Input: NAO of 1 > 5 (false).

code
NAO(1 > 5)  →  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