Manuals/calci/ISNUMBER

ISNUMBER(n)

• $n$ is the number

Description

• 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.

Examples

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

See Also

• ISLOGICAL
• ISODD
• ISEVEN