IFEMPTY
Description
If the specified value or expression results in an empty array, the function returns the value_if_empty value; otherwise, it returns the value. This function is intended for use with unconstrained array formulas.
Syntax
IFEMPTY(
value
, value_if_empty
) - value: The value or expression to evaluate.
- value_if_empty: The value to return if the initial value or expression results in an empty array; it must be both empty and an array. Otherwise, the function returnsvalue.