Difference between revisions of "Manuals/calci/ISBLANK"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''ISBLANK( | + | <div style="font-size:30px">'''ISBLANK (Value)'''</div><br/> |
| − | *<math> | + | *<math>Value</math> is the value to test. |
| + | **ISBLANK(), 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 33: | Line 35: | ||
==References== | ==References== | ||
| − | [http://en.wikipedia.org/wiki/Is_functions Is Function] | + | *[http://en.wikipedia.org/wiki/Is_functions Is Function] |
Latest revision as of 17:16, 1 August 2018
ISBLANK (Value)
- is the value to test.
- ISBLANK(), returns TRUE if the value is blank.
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
Related Videos
See Also
References