Manuals/calci/IS FUNCTIONS

ISFUNCTIONS(n)

• $n$ is the number

Description

• This function is a 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 ISFUNCTIONS 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 empty cell, Boolean values,text,non text,number,reference-value 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.

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.