Difference between revisions of "Manuals/calci/ISNUMBER"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
==Examples== | ==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 |
==See Also== | ==See Also== | ||
Revision as of 07:04, 26 December 2013
ISNUMBER(n)
- is the number
is the numberDescription
- 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.
.
is also known as data information functions, data inspection functions or data-testing functions.
is used to test given value is number or not.Examples
- =ISNUMBER(2) = TRUE
- =ISNUMBER(0) = TRUE
- =ISNUMBER(-100) = TRUE
- =ISNUMBER(y) = NULL
- =ISNUMBER($) = FALSE
- =ISNUMBER("17") = TRUE