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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.