Manuals/calci/IS FUNCTIONS

ISFUNCTIONS(n)

• $n$ is the number

Description

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