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:

• ISBLANK(n)
  • $n$ refers to an empty cell.
• ISERR(n)
  • $n$ refers to any error value except #N/A.
• ISERROR(n)
  • $n$ refers to any error value
• ISLOGICAL(n)
  • $n$ refers to a logical value.
• ISNA(n)
  • $n$refers to the NaN error value.
• ISNONTEXT(n)
  • $n$ refers to any item that is not text.
• ISREF(n)
  • $n$ refers to a reference.
• ISTEXT(n)
  • $n$ refers to text.
• ISNUMBER(n)
  • n refers to a number.
• ISARRAY(n)
• ISLEAPYEAR(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(n) 
  n refers to an empty cell.
2.ISERR(n)
  n refers to any error value except #N/A.
3.ISERROR(n)
  n refers to any error value 
4.ISLOGICAL(n)
  n refers to a logical value.
5.ISNA(n)
  n refers to the NaN error value.
6.ISNONTEXT(n)
  n refers to any item that is not text.
7.ISNUMBER(n)
  n refers to a number.
8.ISREF(n)
  n refers to a reference.
9.ISTEXT(n) 
  n refers to text.