Skip to content

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

E

On this page (10)

True when ALL conditions hold.

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

Aliases#

Canonical name: E. Accepted aliases (case-insensitive): and.

Syntax#

code
E(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: AND
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Accepts N conditions; DAX AND() accepts only 2 (for more, chain && or nest AND).

Examples#

code
E(receita > 1000; lucro > 0)

Example with values#

Input: 1 > 0 AND 2 > 1.

code
E(1 > 0; 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