Difference between revisions of "Manuals/calci/ISBLANK"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISBLANK'''(Value) where, '''Value''' - represents the cell. </div> ---- <div id="1SpaceContent" clas...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ISBLANK(n)'''</div><br/> |
| + | *<math>n</math> 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 | ||
| + | *121 abc 12/1/2012 | ||
| + | #ISBLANK(A1)=FALSE | ||
| + | #ISBLANK(B1)=FALSE | ||
| + | #ISBLANK(C1)=FALSE | ||
| + | #ISBLANK(D1)=TRUE | ||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/ISLOGICAL | ISLOGICAL ]] | ||
| + | *[[Manuals/calci/ISTEXT | ISTEXT ]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Correlation] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 02:19, 12 December 2013
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
- 121 abc 12/1/2012
- ISBLANK(A1)=FALSE
- ISBLANK(B1)=FALSE
- ISBLANK(C1)=FALSE
- ISBLANK(D1)=TRUE