Difference between revisions of "Manuals/calci/ISBLANK"

Latest revision as of 17:16, 1 August 2018

ISBLANK (Value)

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.

Spreadsheet
	A	B	C	D
1	121	abc	12/1/2012

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ISBLANK(n)'''</div><br/>
+<div style="font-size:30px">'''ISBLANK (Value)'''</div><br/>
-*<math>n</math> is the value to test.
+*<math>Value</math> is the value to test.
+**ISBLANK(), returns TRUE if the value is blank.
 ==Description==
 *This function is  one of the group in ISFUNCTIONS.
@@ Line 19: / Line 21: @@
 |}
-#ISBLANK(A1)=FALSE
+#=ISBLANK(A1)=FALSE
-#ISBLANK(B1)=FALSE
+#=ISBLANK(B1)=FALSE
-#ISBLANK(C1)=FALSE
+#=ISBLANK(C1)=FALSE
-#ISBLANK(D1)=TRUE
+#=ISBLANK(D1)=TRUE
+==Related Videos==
+{{#ev:youtube|Nd0JfLStYG8|280|center|ISBLANK}}
 ==See Also==
@@ Line 29: / Line 35: @@
 ==References==
-[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient  Correlation]
+*[http://en.wikipedia.org/wiki/Is_functions  Is Function]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]