Difference between revisions of "Manuals/calci/ISNUMBER"
Jump to navigation
Jump to search
Line 34: | Line 34: | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Is_functions Is functions] | [http://en.wikipedia.org/wiki/Is_functions Is functions] | ||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Revision as of 06:20, 14 March 2017
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
- =ISNUMBER(2) = TRUE
- =ISNUMBER(0) = TRUE
- =ISNUMBER(-100) = TRUE
- =ISNUMBER(y) = NULL
- =ISNUMBER($) = FALSE
- =ISNUMBER("17") = TRUE
Related Videos
See Also
References