This reference lists 20 Excel information functions, ordered by frequency of use, with high-frequency functions marked ⭐. Each function includes its syntax and an example.
| Function | Description | Example |
|---|---|---|
ISBLANK ⭐ |
Returns TRUE if the value is blank | =ISBLANK(A1) — Checks whether A1 is empty, returns TRUE if so — handy for data validation |
ISERROR ⭐ |
Returns TRUE if the value is any error value | =ISERROR(A1) — Checks whether A1 is any error value, used for error trapping |
ISNUMBER ⭐ |
Returns TRUE if the value is a number | =ISNUMBER(A1) — Checks whether A1 is a number, often used in data cleaning and validation |
ISTEXT ⭐ |
Returns TRUE if the value is text | =ISTEXT(A1) — Checks whether A1 is text, often used for data type detection |
CELL |
Returns information about the formatting, location, or contents of a cell | =CELL("address",A1) — Returns the address of A1 such as "$A$1"; can also report type, contents and more |
ERROR.TYPE |
Returns a number matching the type of an error value | =ERROR.TYPE(#REF!) — Returns the number matching an error — 4 for #REF! — useful for error handling |
INFO |
Returns information about the current operating environment | =INFO("directory") — Returns environment info such as the workbook path and Excel version |
ISERR |
Returns TRUE if the value is any error value except #N/A | =ISERR(A1) — Checks whether A1 is an error other than #N/A, such as #VALUE! or #REF! |
ISEVEN |
Returns TRUE if the number is even | =ISEVEN(A1) — Checks whether the number in A1 is even — 2 returns TRUE, 3 returns FALSE |
ISFORMULA |
Returns TRUE if there is a reference to a cell that contains a formula | =ISFORMULA(A1) — Checks whether A1 contains a formula, used to spot calculated cells |
ISLOGICAL |
Returns TRUE if the value is a logical value | =ISLOGICAL(A1) — Checks whether A1 is a logical value such as TRUE or FALSE |
ISNA |
Returns TRUE if the value is the #N/A error value | =ISNA(A1) — Checks specifically whether A1 is the #N/A error, often used after lookup functions |
ISNONTEXT |
Returns TRUE if the value is not text | =ISNONTEXT(A1) — Checks whether A1 is not text (a number, formula, blank, etc.) |
ISODD |
Returns TRUE if the number is odd | =ISODD(A1) — Checks whether the number in A1 is odd — 3 returns TRUE, 2 returns FALSE |
ISREF |
Returns TRUE if the value is a reference | =ISREF(A1) — Checks whether A1 is a valid cell reference |
N |
Returns a value converted to a number | =N("2024") — Converts a value to a number — "2024" becomes 2024, TRUE becomes 1 |
NA |
Returns the error value #N/A | =NA() — Returns the #N/A error, meaning "no value available" — useful as a placeholder |
SHEET |
Returns the sheet number of the referenced sheet | =SHEET() — Returns the index number of the current sheet (starting at 1) |
SHEETS |
Returns the number of sheets in a workbook | =SHEETS() — Returns the total number of sheets in the workbook, including hidden ones |
TYPE |
Returns a number indicating the data type of a value | =TYPE(5) — Returns the data type code: 1 = number, 2 = text, 4 = logical, 16 = error |
From Online Toolbox (www.vba.net)