Information Functions

Function

Description

CELL

Returns information about the formatting, the position, and the content of a cell

ERROR.TYPE

Returns a number corresponding to an error type

INFO

Returns information about the current operating system environment

ISBLANK

Returns TRUE if the value refers to an empty cell

ISERR

Returns TRUE if the value is an error value (with the exception of #NV)

ISERROR

Returns TRUE if the value is an error value

ISEVEN

Returns TRUE if the number is even

ISLOGICAL

Returns TRUE if the value is a logical value

ISNA

Returns TRUE if the value is the error value #NV

ISNONTEXT

Returns TRUE if the value isn’t text

ISNUMBER

Returns TRUE if the value is a number

ISODD

Returns TRUE if the number is odd

ISREF

Returns TRUE if the value is a reference

ISTEXT

Returns TRUE if the value is text

N

Returns a value converted into a number

NA

Returns the error value #NV

TYPE

Returns a number indicating the data type of a given value