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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.