Information Functions

Information Functions are used to obtain information about spreadsheets and content, examples of which information can be returned are information on whether the content of a cell is text or number, or empty or returns error. Here is some Information Functions most used:

CELL - Returns all kinds of information about a cell.

ERROR.TYPE - Returns a number that corresponds to the type of error indicated.
INFO - Returns information about the Excel environment.

ISBLANK - Checks if a cell is empty.

ISERR - Checks if the value of a cell has an error not including the #N/A error.

ISERROR - Checks if the value of a cell has an error including the #N/A error.

ISEVEN - Checks if a number is even.

ISLOGICAL - Checks if the value in a cell is a logical value.

ISNA - Checks if the value of a cell has the #N/A error.

ISNONTEXT - Checks if the value in a cell is not text.

ISNUMBER - Checks if the value in a cell is a number.

ISODD - Checks if a number is odd.

ISREF - Checks if the value in a cell is a reference.

ISTEXT - Checks if the value in a cell is text.

NA - Returns the error value #N/A.

TYPE - Returns a number that identifies the data type of the indicated value.