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)

Applies To: Excel Online, Excel Starter, Excel 2010, Excel 2013, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel 2016 Preview



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language