Information Excel Functions

Get information about cells, values, and the environment

IS functions cheat sheet

Empty cell → [ISBLANK](/functions/isblank/)
Any error → [ISERROR](/functions/iserror/) or lookup #N/A only → [ISNA](/functions/isna/)
Text or number → [ISTEXT](/functions/istext/), [ISNUMBER](/functions/isnumber/)
Wrap formulas safely → [IFERROR](/functions/iferror/) and [IFNA](/functions/ifna/)

Lookup failures → [#N/A error](/errors/na/)
Wrong type in formula → [#VALUE!](/errors/value-error/)
Fix formula errors hub → [Formula errors guide](/guides/fix-excel-formula-errors/)

ISBLANK: Returns TRUE if the cell is empty.
ISNUMBER: Returns TRUE if the value is a number.
ISTEXT: Returns TRUE if the value is text.
ISERROR: Returns TRUE if the value is any error value.
ISNA: Returns TRUE if the value is the #N/A error.
CELL: Returns information about the formatting, location, or contents of a cell.
TYPE: Returns a number indicating the data type of a value.
ISEVEN: Returns TRUE if the number is even.
ISODD: Returns TRUE if the number is odd.
ISLOGICAL: Returns TRUE if the value is a logical value (TRUE or FALSE).
ISNONTEXT: Returns TRUE if the value is not text (includes empty cells).
ISREF: Returns TRUE if the value is a reference.
ISFORMULA: Returns TRUE if the cell contains a formula.
FORMULATEXT: Returns the formula in a cell as text.
NA: Returns the error value #N/A (value not available).
SHEET: Returns the sheet number of the referenced sheet.
SHEETS: Returns the number of sheets in a reference.
ISOMITTED: Checks whether a value in a LAMBDA is missing and returns TRUE or FALSE.
ERROR.TYPE: Returns a number corresponding to an error type.
INFO: Returns information about the current operating environment.
N: Returns a value converted to a number.
FIELDVALUE: Retrieves a field from a linked data type value.
ISERR: Returns TRUE if the value is any error except #N/A, otherwise returns FALSE.

Get information about cells, values, and the environment — use this category page as a map before diving into individual function syntax pages.
Functions indexed here: ISBLANK, ISNUMBER, ISTEXT, ISERROR, ISNA, CELL, TYPE, ISEVEN, ISODD, ISLOGICAL, ISNONTEXT, ISREF and more.
Pick one function per week for your team, copy the examples into a practice workbook, and spot-check against manual math.
When functions in this category feed lookups or aggregates, read the related comparison and problem guides linked from function pages.
Small categories still matter in specialized models — document which niche functions your template depends on for auditors.
Confirm Excel version requirements: dynamic array and cube functions may not open in Excel 2019 even if other category members do.

#NAME? often means a niche function name typo or a locale mismatch — compare spelling to this English directory.
#VALUE! in specialized functions usually means wrong argument type — review each parameter description on the function page.
When results differ from documentation, verify regional settings, unit assumptions, and whether the workbook opened in compatibility mode.
Cross-link to fix-excel-formula-errors when multiple function types in this category fail after a bulk find-replace.

ISBLANK (/functions/isblank/): Returns TRUE if the cell is empty. Syntax: =ISBLANK(value).
ISNUMBER (/functions/isnumber/): Returns TRUE if the value is a number. Syntax: =ISNUMBER(value).
ISTEXT (/functions/istext/): Returns TRUE if the value is text. Syntax: =ISTEXT(value).
ISERROR (/functions/iserror/): Returns TRUE if the value is any error value. Syntax: =ISERROR(value).
ISNA (/functions/isna/): Returns TRUE if the value is the #N/A error. Syntax: =ISNA(value).
CELL (/functions/cell/): Returns information about the formatting, location, or contents of a cell. Syntax: =CELL(info_type, [reference]).
TYPE (/functions/type/): Returns a number indicating the data type of a value. Syntax: =TYPE(value).
ISEVEN (/functions/iseven/): Returns TRUE if the number is even. Syntax: =ISEVEN(number).