Complete List of Excel Information Functions References and Examples
Information Functions is a built-in function in Excel that returns info about the current environment, including platform.
The Information Functions can be used as a worksheet function in Excel. As a worksheet function, the INFO function can be entered as part of a formula in a cell of a worksheet.
Here’s a full list of Built-In Information Functions in Excel and their Descriptions below:
Click each of the function link to see detailed example.
Error Information Functions |
|
| ISERROR | Tests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE |
| ISERR | Tests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE |
| ISNA | Tests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE |
| ERROR.TYPE | Tests a supplied value and returns an integer relating to the supplied value’s error type |
Numerical Information Functions |
|
| ISNUMBER | Tests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE. |
| ISEVEN | Tests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE. |
| ISODD | Tests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE. |
| N | Converts a non-number value to a number, a date to a serial number, the logical value TRUEto 1 and all other values to 0 |
Function Returning a Constant Value |
|
| NA | Returns the Excel #N/A error |
| Other Data Type Functions | |
| ISBLANK | Tests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE |
| ISLOGICAL | Tests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE |
| ISTEXT | Tests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE |
| ISNONTEXT | Tests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE |
| ISREF | Tests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE |
| ISFORMULA | Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013) |
| TYPE | Returns information about the data type of a supplied value |
General Information Functions |
|
| CELL | Returns information about the contents, formatting or location of a given cell |
| SHEET | Returns the sheet number relating to a supplied reference (New in Excel 2013) |
| SHEETS | Returns the number of sheets in a reference (New in Excel 2013) |
| INFO | Returns information about the current operating environment |