# Excel information functions

> Information functions answer a yes-or-no question about a value: is it blank, a number, text, an error? On their own they return TRUE or FALSE.

Source: https://spreadsheetpractice.com/functions/category/info · Updated October 29, 2026

Information functions answer a yes-or-no question about a value: is it blank, a number, text, an error? On their own they return TRUE or FALSE. Their real use is inside IF, SUMPRODUCT and conditional formatting, where they flag bad imports, skip missing data and keep one error from breaking a whole report.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Flag rows with a missing value | [ISBLANK](https://spreadsheetpractice.com/functions/isblank) | TRUE only for truly empty cells, so you can mark gaps before they break totals. |
| Find numbers stored as text | [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber) | FALSE for imported digits that Excel treats as text, which quietly drop out of SUM. |
| Check whether a cell contains some text | [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber) | Wrap SEARCH in ISNUMBER for a contains test that returns TRUE or FALSE. |
| Tell "not found" apart from a real error | [ISNA](https://spreadsheetpractice.com/functions/isna) | Catches only #N/A, so typos and broken references still show. |
| Catch any error before it spreads | [ISERROR](https://spreadsheetpractice.com/functions/iserror) | Covers every error type when you need a safe fallback. |
| Split items or rows by odd and even | [ISEVEN](https://spreadsheetpractice.com/functions/iseven) | Alternate shifts, sides of a street or row shading with one test. |

## All 10 information functions

| Function | What it does | Available in |
|---|---|---|
| [ISBLANK](https://spreadsheetpractice.com/functions/isblank) | ISBLANK returns TRUE when a cell is completely empty. | Every current version |
| [ISERR](https://spreadsheetpractice.com/functions/iserr) | ISERR returns TRUE for any error except #N/A. | Every current version |
| [ISERROR](https://spreadsheetpractice.com/functions/iserror) | ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?. | Every current version |
| [ISEVEN](https://spreadsheetpractice.com/functions/iseven) | ISEVEN returns TRUE when a number is even. | Every current version |
| [ISLOGICAL](https://spreadsheetpractice.com/functions/islogical) | ISLOGICAL returns TRUE when a value is one of the logical values, TRUE or FALSE. | Every current version |
| [ISNA](https://spreadsheetpractice.com/functions/isna) | ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found. | Every current version |
| [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber) | ISNUMBER returns TRUE when a value is a real number, which includes dates and times. | Every current version |
| [ISODD](https://spreadsheetpractice.com/functions/isodd) | ISODD returns TRUE when a number is odd. | Every current version |
| [ISTEXT](https://spreadsheetpractice.com/functions/istext) | ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return. | Every current version |
| [NA](https://spreadsheetpractice.com/functions/na) | NA() returns the #N/A error on purpose, to mark a value as not available. | Every current version |

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
