Information functions in Excel empower users to assess, validate, and interpret the contents and structure of data with clarity and precision — without the need for complex programming. These essential tools help identify data types, detect errors, verify conditions, and provide feedback that enhances the reliability of formulas and models. Whether you’re auditing spreadsheets, building dynamic logic with conditional formatting, or ensuring data quality, Excel’s information functions allow analysts, developers, and everyday users to gain control over how data behaves and responds. By leveraging these functions, users can create smarter, more responsive workbooks that adapt dynamically to input changes and support more accurate, data-driven decision-making.
This function returns a number indicating the data type of the specified value. Syntax: TYPE(value) Arguments: value (required): The expression to check (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name).
This function returns the #N/A error value, indicating that a value does not exist. Syntax: NA Arguments: This function does not take any arguments. Background: Although the NA() function does not require arguments, you must include the parentheses; otherwise, Excel will interpret it as
This function returns a value converted into a number. Syntax. N(value) Arguments value (required). The expression (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name) that you want to convert
Returns TRUE if the value is text (including numeric strings like « 123 »). Returns FALSE for numbers, errors, logical values, empty cells, or empty strings (« »). Syntax ISTEXT(value) Key Behavior Input Type ISTEXT Result Notes Regular text TRUE « Apple », « 123 » Empty cell FALSE Number FALSE 100, 3.14 Boolean FALSE TRUE/FALSE
Returns TRUE if the value is a valid cell reference (including named ranges). Returns FALSE for all other inputs (numbers, text, invalid references). Syntax ISREF(value) Key Features What Returns TRUE? ✔ Standard references (A1, Sheet2!B5) ✔ Named ranges (« Sales Data ») ✔ Structured references (Table1[Column1]) What Returns FALSE?
Its returns TRUE if the number is odd, and FALSE if it is even. Syntax ISODD(number) Arguments number (required) – The value to check (can be a cell reference, formula, or direct input). Key Behavior ✅ Integers: Evaluates normally (e.g., 3 → TRUE, 4 → FALSE). Decimals: Truncates decimal places before checking (e.g., 5.9 → TRUE, -2.3 → FALSE). ❌ Non-numbers: Returns #VALUE! for text/logical
Returns TRUE if the value is a numeric value (including dates/times, percentages, and formulas that return numbers). Returns FALSE for all other types (text, logical values, errors, blank cells). Syntax ISNUMBER(value) Key Features Part of the IS() function family – evaluates without type conversion Returns FALSE for empty cells (though
This function returns TRUE if the value is not text (including numbers, errors, logical values, or empty cells). It returns FALSE only if the value is text. Syntax ISNONTEXT(value) Arguments value (required): The expression to check (number, text, formula, logical value, error, reference, or name). Key Features Part of
This function returns TRUE if the value is the #N/A error. Otherwise, it returns FALSE. Syntax ISNA(value) Arguments value (required) – The expression to check (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name). Background Part of
This function returns TRUE if the value is a logical value (TRUE or FALSE). Otherwise, it returns FALSE. Syntax ISLOGICAL(value) Arguments value (required) – The expression to check (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name).
This function returns TRUE if the number is even, and FALSE if it is odd. Syntax ISEVEN(number) Arguments number (required) – The expression to be checked. Background Accepts any numeric expression. Integers are evaluated directly. Decimal numbers are truncated before evaluation (e.g., 2.4 becomes 2, -1.6 becomes -1). Returns #VALUE! for non-numeric inputs (e.g., text, logical values).
This function returns TRUE if the value is any error value (including #N/A). Otherwise, it returns FALSE. Unlike ISERR(), this function does recognize #N/A as an error. Syntax ISERROR(value) Arguments value (required) – The expression to check (a number, text, a formula without an equal sign, a logical value, an error value,
This function returns TRUE if the value is an error value. Otherwise, it returns FALSE. Exception: Unlike ISERROR(), this function does not recognize #N/A as an error and returns FALSE for it. Syntax ISERR(value) Arguments value (required) – The expression (a number, text, a formula without an equal sign, a logical value, an error
This function returns TRUE if the value argument refers to an empty cell. Otherwise, it returns FALSE. Syntax ISBLANK(value) Arguments value (required) – The expression (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name) that
This function returns a number corresponding to an error value in Excel. If no error exists in the cell or in the calculation, the function returns the #N/A error. Syntax ERROR.TYPE(error_value) Arguments error_value (required) – The error value (either the actual error in
Excel offers far more than just basic formulas. Beyond the Information functions, there’s a powerful universe of functions designed to help you analyze data, automate tasks, and build dynamic spreadsheets. In this section, you’ll discover key categories such as lookup functions, logical functions, text manipulation, financial formulas, and more — each with clear explanations and real-world examples to help you master them with confidence.
