# Difference between revisions of "Manuals/calci/ISNUMBER"

ISNUMBER(Number)

• is any number.
• ISNUMBER(),Returns TRUE if the value is a 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

ISNUMBER