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/)
Related troubleshooting
- 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/)
Functions in this category
- 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.
- ISERR: Returns TRUE if the value is any error except #N/A, otherwise returns FALSE.