Difference between revisions of "Manuals/calci/ISEMPTY"
Jump to navigation
Jump to search
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''ISEMPTY( | + | <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 9: | Line 12: | ||
==Examples== | ==Examples== | ||
#=ISEMPTY ()=true | #=ISEMPTY ()=true | ||
| − | #=ISEMPTY ("")=false | + | #=ISEMPTY (" ")=false |
#=ISEMPTY (1)=false | #=ISEMPTY (1)=false | ||
#=ISEMPTY ("a")=false | #=ISEMPTY ("a")=false | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|Nd0JfLStYG8|280|center|ISBLANK}} | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/ISMONTH | ISMONTH ]] | ||
| + | *[[Manuals/calci/ISBLANK | ISBLANK ]] | ||
| + | *[[Manuals/calci/ISNA | ISNA ]] | ||
| + | ==References== | ||
| + | *[https://support.office.com/en-us/article/IS-functions-0f2d7971-6019-40a0-a171-f2d869135665 Is Functions] | ||
Latest revision as of 15:07, 7 March 2019
ISEMPTY (Thing)
- is any value or empty.
- ISEMPTY(), returns TRUE if the value is blank.
is any value or empty.
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
Related Videos
See Also
References