Difference between revisions of "Manuals/calci/ISNUMBER"

Revision as of 13:22, 28 March 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 13: / Line 13: @@
 *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==