Category: Special function

This function creates an empty value.

Use empty() to insert empty values into cells, or within other functions.

This function does not require arguments.

Return value type: Empty value

While a value can be tested for an empty value using a "value = empty()" expression, the IsEmpty function can also be used. The two approaches are equivalent.

[Content] = empty()  //Returns TRUE if [Content] contains an empty value, otherwise, FALSE.

coalesce(empty(), 'ABC', '')  //Using empty() as an argument within a function.

if( [Value] = 10, 'Ten', empty() )  //Using empty() to set a return empty value in an If statement.

• IsEmpty(expression)
• The EasyMorph Type system