Information functions (reference)

To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Function

Description

CELL function

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

Note:  This function is not available in Excel Online.

ERROR.TYPE function

Returns a number corresponding to an error type

INFO function

Returns information about the current operating environment

Note:  This function is not available in Excel Online.

ISBLANK function

Returns TRUE if the value is blank

ISERR function

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

ISERROR function

Returns TRUE if the value is any error value

ISEVEN function

Returns TRUE if the number is even

ISFORMULA function
Excel 2013

Returns TRUE if there is a reference to a cell that contains a formula

ISLOGICAL function

Returns TRUE if the value is a logical value

ISNA function

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

ISNONTEXT function

Returns TRUE if the value is not text

ISNUMBER function

Returns TRUE if the value is a number

ISODD function

Returns TRUE if the number is odd

ISREF function

Returns TRUE if the value is a reference

ISTEXT function

Returns TRUE if the value is text

N function

Returns a value converted to a number

NA function

Returns the error value #N/A

SHEET function
Excel 2013

Returns the sheet number of the referenced sheet

SHEETS function
Excel 2013

Returns the number of sheets in a reference

TYPE function

Returns a number indicating the data type of a value

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×