Difference between revisions of "Manuals/calci/ISEMPTY"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''ISEMPTY(n)'''</div><br/>
+
<div style="font-size:30px">'''ISEMPTY (Thing)'''</div><br/>
 +
*<math>Thing</math> is any value or empty.
 +
**ISEMPTY(), returns TRUE if the value is blank.
 +
 
 
==Description==
 
==Description==
 
*This function is  one of the group in ISFUNCTIONS.
 
*This function is  one of the group in ISFUNCTIONS.
Line 12: Line 15:
 
#=ISEMPTY (1)=false
 
#=ISEMPTY (1)=false
 
#=ISEMPTY ("a")=false
 
#=ISEMPTY ("a")=false
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|Nd0JfLStYG8|280|center|ISBLANK}}
 +
  
 
==See Also==
 
==See Also==

Latest revision as of 15:07, 7 March 2019

ISEMPTY (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

References