Difference between revisions of "Manuals/calci/ISNUMBER"

From ZCubes Wiki
Jump to navigation Jump to search
Line 13: Line 13:
 
*The syntax is to find whether the given data is a number in ZOS is <math>ISNUMBER(Number)</math>.
 
*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.
 
**<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==
 
==Examples==

Revision as of 14:22, 28 March 2018

ISNUMBER(Number)


  • is any number.

Description

  • This function is one of the group in .
  • The is also known as data information functions, data inspection functions or data-testing functions.
  • 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.

ZOS

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

Examples

  1. =ISNUMBER(2) = TRUE
  2. =ISNUMBER(0) = TRUE
  3. =ISNUMBER(-100) = TRUE
  4. =ISNUMBER(y) = NULL
  5. =ISNUMBER($) = FALSE
  6. =ISNUMBER("17") = TRUE

Related Videos

ISNUMBER

See Also

References

Is functions