Skip to content

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

SE

On this page (10)

SE(condition; then; else?) — without the 'else' the result is blank.

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

Aliases#

Canonical name: SE. Accepted aliases (case-insensitive): if.

Syntax#

code
SE(expr; arg2; [arg3])

All arguments are expressions.

Returns#

The chosen branch (same type as the 'then'/'else'); blank when there is no 'else'.

Null handling#

A blank condition is treated as false.

Evaluation context#

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

Differences from DAX#

  • DAX equivalent: IF
  • Compatibility: Compatible with DAX
  • Note: Without the 'else', it returns blank (like IF's BLANK).

Examples#

code
SE(receita > 100; 1; 0)

Example with values#

Input: condition 10 > 5.

code
SE(10 > 5; "sim"; "não")  →  "sim"

Expected result: "sim"

Business example#

Flag “target hit” when revenue exceeds the goal.

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