Information Functions
CELL function
The CELL function returns information about the formatting, location, or contents of a cell.
ERROR.TYPE function
The ERROR.TYPE function returns the numeric representation of one of the existing error values.
ISBLANK function
The ISBLANK function checks whether a cell is empty and returns TRUE if it contains no value, otherwise FALSE.
ISERR function
The ISERR function checks whether a value is an error other than
ISERROR function
The ISERROR function checks whether a value is one of the error values and returns TRUE if so, otherwise FALSE.
ISEVEN function
The ISEVEN function checks whether a number is even and returns TRUE if so, FALSE if it is odd.
ISFORMULA function
The ISFORMULA function checks whether a reference points to a cell that contains a formula and returns TRUE if so, otherwise FALSE.
ISLOGICAL function
The ISLOGICAL function checks whether a value is a logical value (TRUE or FALSE) and returns TRUE if so, otherwise FALSE.
ISNA function
The ISNA function checks whether a value is the
ISNONTEXT function
The ISNONTEXT function checks whether a value is not text and returns TRUE if so, otherwise FALSE.
ISNUMBER function
The ISNUMBER function checks whether a value is numeric and returns TRUE if so, otherwise FALSE.
ISODD function
The ISODD function checks whether a number is odd and returns TRUE if so, FALSE if it is even.
ISREF function
The ISREF function checks whether a value is a valid cell reference.
ISTEXT function
The ISTEXT function checks whether a value is text and returns TRUE or FALSE.
N function
The N function converts a value to a number.
NA function
The NA function returns the
SHEET function
The SHEET function returns the sheet number of the reference sheet.
SHEETS function
The SHEETS function returns the number of sheets in a reference.
TYPE function
The TYPE function determines the type of the resulting or displayed value.