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.