Difference between revisions of "Manuals/calci/ISNUMBER"

Latest revision as of 15: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(Number)'''</div><br/>
 *<math>Number</math> is any number.
+**ISNUMBER(),Returns TRUE if the value is a number.
 ==Description==
@@ Line 13: / Line 14: @@
 *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))
+*For e.g.,ISNUMBER(log(20)),ISNUMBER(SUM(10,20,30,40,50))
 ==Examples==