Difference between revisions of "Manuals/calci/ISEMPTY"

From ZCubes Wiki
Jump to navigation Jump to search
Line 13: Line 13:
 
#=ISEMPTY ("a")=false
 
#=ISEMPTY ("a")=false
  
 +
==See Also==
 +
*[[Manuals/calci/ISMONTH  | ISMONTH ]]
 +
*[[Manuals/calci/ISBLANK  | ISBLANK ]]
 +
*[[Manuals/calci/ISEMPTY  | ISEMPTY ]]
  
 +
==References==
 +
*[https://support.office.com/en-us/article/IS-functions-0f2d7971-6019-40a0-a171-f2d869135665 Is Functions]
  
  

Revision as of 12:39, 20 September 2017

ISEMPTY(n)


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

See Also

References