Difference between revisions of "Manuals/calci/ISNUMBER"

Latest revision as of 16:50, 2 July 2018

ISNUMBER(Number)

This function is one of the group in $ISFUNCTIONS$ .
The $ISFUNCTION$ is also known as data information functions, data inspection functions or data-testing functions.
$ISNUMBER$ is used to test given value is number or not.
This function gives the result as TRUE when the given value is the number otherwise this function gives th result as FALSE.
This function will not convert any numbers from text.
For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.

The syntax is to find whether the given data is a number in ZOS is .
- $Number$ is any number.
For e.g.,ISNUMBER(log(20)),ISNUMBER(SUM(10,20,30,40,50))

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ISNUMBER(n)'''</div><br/>
+<div style="font-size:30px">'''ISNUMBER(Number)'''</div><br/>
-*<math>n</math> is the number
+*<math>Number</math> is any number.
+**ISNUMBER(),Returns TRUE if the value is a number.
 ==Description==
@@ Line 9: / Line 10: @@
 *This function will not convert any numbers from  text.
 *For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.
+==ZOS==
+*The syntax is to find whether the given data is a number in ZOS is <math>ISNUMBER(Number)</math>.
+**<math>Number</math> is any number.
+*For e.g.,ISNUMBER(log(20)),ISNUMBER(SUM(10,20,30,40,50))
 ==Examples==
-#ISNUMBER(2)=TRUE
+#=ISNUMBER(2) = TRUE
-#ISNUMBER(0)=TRUE
+#=ISNUMBER(0) = TRUE
-#ISNUMBER(-100)=TRUE
+#=ISNUMBER(-100) = TRUE
-#ISNUMBER(y)=NULL
+#=ISNUMBER(y) = NULL
-#ISNUMBER($)=FALSE
+#=ISNUMBER($) = FALSE
-#ISNUMBER("17")=TRUE
+#=ISNUMBER("17") = TRUE
+==Related Videos==
+{{#ev:youtube|oD0srLcl3vo|280|center|ISNUMBER}}
 ==See Also==
@@ Line 24: / Line 34: @@
 ==References==
+[http://en.wikipedia.org/wiki/Is_functions Is functions]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]