The Excel information functions are used to return the information about the formatting, location, or content of cells, whether value is an error or not a text, sheet number, number of sheets in a reference and much more.
Complete List of Excel Information Functions (A to Z)
All information functions in Excel are mentioned below in alphabetical order:
| Function | Description |
| CELL Function | Information about a cell’s location, formatting or contents. |
| ERROR.TYPE Function | Number that corresponds to a specific error type. |
| INFO Function | Information about the current operating environment. |
| ISBLANK Function | TRUE if a given cell is blank (empty), else returns as FALSE. |
| ISERR Function | TRUE if the given value is an error (except N/A), else returns as FALSE. |
| ISERROR Function | TRUE if the value is any error (except #N/A), else returns as FALSE. |
| ISEVEN Function | TRUE if the number is even, else returns as FALSE. |
| ISFORMULA Function | TRUE if there is a reference to a cell that contains a formula, else returns as FALSE. |
| ISLOGICAL Function | TRUE if the value is a logical value, else returns as FALSE. |
| ISNA Function | TRUE if the value is #N/A error, else returns as FALSE. |
| ISNONTEXT Function | TRUE if the value is not text, else returns as FALSE. |
| ISNUMBER Function | TRUE if the value is a number, else returns as FALSE. |
| ISODD Function | TRUE if the number is odd, else returns as FALSE. |
| ISOMITTED Function | TRUE if the value in a LAMBDA is missing, else returns as FALSE. |
| ISREF Function | TRUE if the value is a reference, else returns as FALSE. |
| ISTEXT Function | TRUE if the value is text, else returns as FALSE. |
| N Function | A value converted to a number. |
| NA Function | The error value #N/A. |
| SHEET Function | The sheet number. |
| SHEETS Function | The number of sheets in a reference. |
| TYPE Function | A number indicating the data type of a specified value. |