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.