Difference between revisions of "Manuals/calci/ISBLANK"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
#=ISBLANK(C1)=FALSE | #=ISBLANK(C1)=FALSE | ||
#=ISBLANK(D1)=TRUE | #=ISBLANK(D1)=TRUE | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|Nd0JfLStYG8|280|center|ISBLANK}} | ||
==See Also== | ==See Also== | ||
Revision as of 13:48, 12 June 2015
ISBLANK(n)
- is the value to test.
is the value to test.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.
- ISBLANK 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
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 121 | abc | 12/1/2012 |
- =ISBLANK(A1)=FALSE
- =ISBLANK(B1)=FALSE
- =ISBLANK(C1)=FALSE
- =ISBLANK(D1)=TRUE