Manuals/calci/ISEMPTY

ISEMPTY (Thing)

• $Thing$ is any value or empty.
  • ISEMPTY(), returns TRUE if the value is blank.

Description

• This function is one of the group in ISFUNCTIONS.
• The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
• ISEMPTY function can be used to check for blank or null values.
• This function will return the result as TRUE when given value or referred cell is empty otherwise the result is FALSE when the cell is nonempty.
• The argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

1. =ISEMPTY ()=true
2. =ISEMPTY (" ")=false
3. =ISEMPTY (1)=false
4. =ISEMPTY ("a")=false

Related Videos

ISBLANK

See Also

• ISMONTH
• ISBLANK
• ISNA

References

• Is Functions

• List of Main Z Functions

• Z3 home