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.