Manuals/calci/ISEMPTY

From ZCubes Wiki
Revision as of 01:24, 14 March 2017 by Jayaram (talk | contribs) (Created page with "==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 fun...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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