Difference between revisions of "Manuals/calci/ISEMPTY"
Jump to navigation
Jump to search
(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...") |
|||
| Line 1: | Line 1: | ||
| + | <div style="font-size:30px">'''ISEMPTY(n)'''</div><br/> | ||
==Description== | ==Description== | ||
*This function is one of the group in ISFUNCTIONS. | *This function is one of the group in ISFUNCTIONS. | ||
Revision as of 04:09, 14 March 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
- =ISEMPTY ()=true
- =ISEMPTY ("")=false
- =ISEMPTY (1)=false
- =ISEMPTY ("a")=false