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)