Information Functions

CELL

Returns information about the formatting, location, or contents of a cell

COUNTBLANK

Counts the number of blank cells within a range

ERROR.TYPE

Returns a number corresponding to an error type

INFO

Returns information about the current operating environment

ISBLANK

Returns TRUE if the value is blank

ISERR

Returns TRUE if the value is any error value except #N/A

ISERROR

Returns TRUE if the value is any 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 #N/A error value

ISNONTEXT

Returns TRUE if the value is not 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 to a number

NA

Returns the error value #N/A

TYPE

Returns a number indicating the data type of a value