User Tools

Site Tools



Category: Special function


This function creates an empty value.

Use cases

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.

See also

syntax/functions/empty.txt · Last modified: 2021/09/13 00:06 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki