Information Functions in Excel
Information Functions in Excel
Excel boasts a vast library of functions, but don’t be overwhelmed! We’ll explore the most essential functions grouped into intuitive categories. Here is the list of Excel Formulas and Functions. We have included Excel functions, Description, Syntax. Explained with Example Formulas.
Information Functions
Get to Know Your Spreadsheet Better with Information Functions! These tools reveal details about cells, formatting, and workbook properties. Whether you need to check a cell’s data type (ISNUMBER, ISTEXT) or access workbook information (INFO), these functions provide valuable insights into the inner workings of your spreadsheet.
- Reveal details about cells, formatting, and workbook properties.
- Become a Spreadsheet Detective: Information Functions act as your eyes and ears, revealing hidden details about your data.
- Cell Secrets Exposed: Uncover cell formatting, data types, and location with the CELL function.
- Workbook Wisdom: Get the inside scoop on your workbook using INFO, like the number of sheets or protection status.
- Data Type Discrimination: Distinguish between blank cells (ISBLANK), numbers (ISNUMBER), or text (ISTEXT) for cleaner formulas.
| Function | Description | Syntax and Formula |
| CELL | The CELL function returns information about the formatting, location, or contents of a cell. | Syntax: CELL(info_type, [reference]) Formula: CELL(“filename”,A1)This example returns the file name of the workbook containing the cell A1. |
| ERROR.TYPE | The ERROR.TYPE function returns a number that corresponds to a specific error value in Microsoft Excel. | Syntax: ERROR.TYPE(error_val) Formula: ERROR.TYPE(#VALUE!)This will return the number 2, which corresponds to the #VALUE! error. |
| INFO | Description:The INFO function is an information function in Excel that returns information about the operating environment. | Syntax: INFO(type) Formula: INFO(“numfile”)This example returns the number of currently open files. |
| ISBLANK | The ISBLANK function in Excel checks if a cell is empty or not. | Syntax: ISBLANK(value) Formula: ISBLANK(A1)This formula will return TRUE if cell A1 is empty, and FALSE if it is not. |
| ISERR | The ISERR function in Microsoft Excel is a logical function that returns TRUE when the value provided is an error value other than #N/A, and FALSE when the value is not an error value. | Syntax: ISERR(value) Formula: ISERR(A1)In this example, the ISERR function will return TRUE if the value in cell A1 is an error value, and FALSE if it is not. |
| ISERROR | The ISERROR function is used to check if a value is an error and returns either TRUE or FALSE. | Syntax: ISERROR(value) Formula: ISERROR(A1) |
| ISEVEN | The ISEVEN function is used to determine whether a number is even or odd. | Syntax: ISEVEN(number) Formula: ISEVEN(2) will return TRUE because 2 is an even number. |
| ISFORMULA | The ISFORMULA function in Excel is used to check if a cell contains a formula. It returns TRUE if the cell contains a formula and FALSE if it does not. | Syntax: ISFORMULA(cell) Formula: To check if cell A1 contains a formula, the following formula can be used:=ISFORMULA(A1) |
| ISLOGICAL | The ISLOGICAL function is used to check if a value is a logical value (TRUE or FALSE). | Syntax: ISLOGICAL(value) Formula: ISLOGICAL(TRUE) returns TRUE |
| ISNA | The ISNA function in Excel is used to check whether a given value is the #N/A error value. | Syntax: ISNA(value) Formula: ISNA(A1)If A1 contains the #N/A error value, then the ISNA function will return TRUE. Otherwise, it will return FALSE. |
| ISNONTEXT | The ISNONTEXT function is used to check if a value is not text. It returns TRUE if the value is not text and FALSE if it is text. | Syntax: ISNONTEXT(value) Formula: ISNONTEXT(“Hello”)This will return FALSE as “Hello” is text. |
| ISNUMBER | The ISNUMBER function is used to determine if a value is a number or not. | Syntax: ISNUMBER(value) Formula: ISNUMBER(A1) will return TRUE if A1 contains a number, and FALSE if A1 does not contain a number. |
| ISODD | The ISODD function is used to check if a number is odd. It returns TRUE if the number is odd and FALSE if the number is even. | Syntax: ISODD(number) Formula: ISODD(3)This will return TRUE because 3 is an odd number. |
| ISOMITTED | The ISOMITTED function in Excel checks whether a value is omitted from a list of values. | Syntax: ISOMITTED(value) Formula: ISOMITTED(A1) |
| ISREF | The ISREF function checks if a cell reference is valid. | Syntax: ISREF(value) Formula: ISREF(A1) returns TRUE if A1 is a valid cell reference, FALSE if not. |
| ISTEXT | The ISTEXT function is a built-in function in Excel that checks to see if a cell contains text. It returns TRUE if the value is text and FALSE if not. | Syntax: ISTEXT(value) Formula: ISTEXT(A1)This formula will return TRUE if the value in cell A1 is text and FALSE if not. |
| NPER | The NPER function in Excel is used to calculate the number of periods for an investment based on a constant payment and a constant interest rate. | Syntax: NPER(rate, pmt, pv, [fv], [type]) Formula: To calculate the number of periods for an investment of $1000 with a payment of $50 and an interest rate of 5%:NPER(5%, -50, 1000)Result: 20 |
| NA | The NA function returns the #N/A error value, which indicates that a value is not available. | Syntax: NA() Formula: NA() |
| SHEET | SHEET is an Excel function that returns the sheet number of a reference. | Syntax: SHEET(reference) Formula: SHEET(A1)This would return the sheet number of the cell A1. |
| SHEETS | The SHEETS function returns the number of sheets in a reference. | Syntax: SHEETS(reference) Formula: SHEETS(“Sheet1:Sheet3”)This would return the number 3, since the reference includes three sheets. |
| TYPE | TYPE: The TYPE function is an Excel Information function that returns a number indicating the type of value in a cell. | Syntax: TYPE(value) Formula: TYPE(A1)If cell A1 contains the value “Hello”, the result of the function would be 1, indicating that the value is a text string. |
You May Like to Browers More
