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.

1.ISBLANK 
  V refers to an empty cell.
2.ISERR
  V refers to any error value except #N/A.
3.ISERROR
  V refers to any error value 
4.ISLOGICAL
  V refers to a logical value.
5.ISNA
  V refers to the NaN error value.
6.ISNONTEXT
  V refers to any item that is not text.
7.ISNUMBER
  V refers to a number.
8.ISREF
  V refers to a reference.
9.ISTEXT 
  V refers to text.