Information(Microsoft Excel Functions)
It primarily includes functions for examining the nature of the data in a cell. Functions other than error determination are used less frequently.
Contents
Functions.
| Function | Importance | Description |
|---|---|---|
| ERROR.TYPE ISERR ISERROR ISNA | High | Performs cell error determination. |
| ISBLANK ISFORMULA ISREF ISTEXT ISNONTEXT ISLOGICAL ISNUMBER ISODD ISEVEN | Middle | Determines what kind of information the data in the cell is. |
| CELL | Low | Get various information about the cell. |
| INFO | Low | Get information about the operating environment. |
| ISOMITTED | Middle | Helper function for LAMBDA functions to determine if custom function arguments are set or omitted. |
| NA | Low | Generate N/A error. |
| SHEET | Low | Get the number of the designated sheet. |
| SHEETS | Low | Get the number of worksheets. |
| TYPE | Low | Get cell data type. |