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.