Information Functions

ERRORTYPE

This function returns a number corresponding to one of the error values.

ISBLANK

This function tests whether a value, an expression or contents of a referenced cell is empty.

ISERR

This function, Is Error Other Than Not Available, tests whether a value, an expression or contents of a referenced cell has an error other than not available (#N/A).

ISERROR

This function, Is Error of Any Kind, tests whether a value, an expression or contents of a referenced cell has an error of any kind.

ISEVEN

This function, Is Number Even, tests whether a value, an expression or contents of a referenced cell is even.

ISFORMULA

This function tests whether contains a formula of a referenced cell.

ISLOGICAL

This function tests whether a value, an expression or the contents of a referenced cell is a logical (Boolean) value.

ISNA

This function, Is Not Available, tests whether a value, an expression or contents of a referenced cell has the not available (#N/A) error value.

ISNONTEXT

This function tests whether a value, an expression or contents of a referenced cell has any data type other than text.

ISNUMBER

This function tests whether a value, an expression or contents of a referenced cell has numeric data.

ISODD

This function, Is Number Odd, tests whether a value, an expression or contents of a referenced cell has numeric data.

ISREF

This function, Is Reference, tests whether a value, an expression or contents of a referenced cell is a reference to another cell.

ISTEXT

This function tests whether a value, an expression or contents of a referenced cell has text data.

N

This function returns a value converted to a number.

NA

This function returns the error value #N/A which means not available.

SHEET

This function returns the sheet number of the reference sheet.

SHEETS

This function returns the number of sheets in a reference.

TYPE

This function returns the type of value.