A newer version of this documentation is available.

View Latest

Conditional Functions for Unknowns

Conditional functions evaluate expressions to determine if the values and formulas meet the specified condition.

IFMISSING(expression1, expression2, ...)

Returns the first non-MISSING value.

IFMISSINGORNULL(expression1, expression2, ...)

Returns first non-NULL, non-MISSING value.

IFNULL(expression1, expression2, ...)

Returns first non-NULL value. Note that this function might return MISSING if there is no non-NULL value.

MISSINGIF(expression1, expression2)

Returns MISSING if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

NULLIF(expression1, expression2)

Returns NULL if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.