# Manuals/calci/IS FUNCTIONS

Jump to navigation
Jump to search

**ISFUNCTIONS(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)
- refers to an empty cell.

- ISERR(n)
- refers to any error value except #N/A.

- ISERROR(n)
- refers to any error value

- ISLOGICAL(n)
- refers to a logical value.

- ISNA(n)
- refers to the NaN error value.

- ISNONTEXT(n)
- refers to any item that is not text.

- ISREF(n)
- refers to a reference.

- ISTEXT(n)
- refers to text.

- ISNUMBER(n)
- refers to a number.

- ISARRAY(n)
- ISLEAPYEAR(n)
- ISPMT(n)
- ISEMPTY(n)
- ISNULL(n)
- ISEVEN(n)
- ISODD(n)
- ISPRIME(n)

- where is value to check with the function.

The 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 value.
- This function will not convert to numbers from text.
- Function will consider as string if its written in quotes("").
- "20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string.

## Examples

- =ISEVEN(28) = TRUE
- =ISODD(28) = FALSE
- =ISNUMBER(A) = FALSE
- =ISBLANK(0) = FALSE
- =ISERROR(3/0) = TRUE
- =ISERR(2*6) = FALSE
- =ISNONTEXT(121*56) = TRUE