Home › Excel formulas › Information functions
Excel Information Functions: Full List with Examples
Information functions check what a cell holds, such as blank, number, text or error. They are often wrapped inside IF to avoid errors. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| ISBLANK | Checks whether a cell is empty. |
| ISERROR | Checks whether a value is any kind of error. |
| ISNUMBER | Checks whether a value is a number. |
| ISTEXT | Checks whether a value is text. |
| ISNA | Checks whether a value is the #N/A error specifically. |
| ISEVEN | Checks whether a number is even. |
| ISODD | Checks whether a number is odd. |
| ISFORMULA | Checks whether a cell contains a formula. |
| ISREF | Checks whether a value is a valid cell reference. |
| ISLOGICAL | Checks whether a value is TRUE or FALSE. |
| N | Converts a value to a number — text becomes 0, dates become serial numbers. |
| SHEET | Returns the sheet number of a reference. |
| SHEETS | Returns the number of sheets in a reference. |
| ERROR.TYPE | Returns a number matching a specific error type. |
| INFO | Returns information about the current operating environment. |
| CELL | Returns information about the formatting, location, or contents of a cell. |
| NA | Returns the #N/A error value deliberately, often as a placeholder. |
Practice Information functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Information functions?
Cellgrids lists 17 Excel Information functions. Popular ones include ISBLANK, ISERROR, ISNUMBER, ISTEXT, ISNA. Each has its own page with syntax, arguments and an example.
How can I practice Excel Information functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Information function should a beginner learn first?
Start with ISBLANK. Checks whether a cell is empty.