- is the number
is the numberDescription
"This function isa group of Information Functions that can be used to find out information about a specific.The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.These functions are simple data validation and data type checking functions.The IS FUNCTIONS are listed below: ISARRAY(n) ISLEAPYEAR(n) ISBLANK(n) ISERR(n) ISERROR(n) ISLOGICAL(n) ISNA(n) ISNONTEXT(n) ISREF(n) ISTEXT(n) ISPMT(n) ISEMPTY(n) ISNULL(n) ISEVEN(n) ISODD(n) ISPRIME(n), where n is value to check with the function.The n can be any type like emptycell, boolean values,text,nontext,number,referencevalue or name referring to any of these.this function will give the result as either TRUE or FALSE according to the n value. 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."
These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
- =ISLOGICAL(TRUE) is 1
- =ISLOGICAL(“TRUE”) is 0*
- =ISNUMBER(4) is 1
ISBLANK
V
ISERR
V
ISERROR
V
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISREF
ISTEXT
- ISBLANK
V refers to an empty cell.
- ISERR
Vl refers to any error value except #N/A.
- ISERROR
V refers to any error value
- ISLOGICAL
V refers to a logical value.
- ISNA
V refers to the NaN error value.
- ISNONTEXT
V refers to any item that is not text.
- ISNUMBER
V refers to a number.
- ISREF
V refers to a reference.
- ISTEXT
V refers to text.