”;
Information functions provide information about the content, formatting and location of cells in an Excel Worksheet.
Information Functions
The following table lists all the Information functions −
| S.No. | Function and Description |
|---|---|
| 1 | CELL
Returns information about the formatting, location, or contents of a cell |
| 2 | ERROR.TYPE
Returns a number corresponding to an error type |
| 3 | INFO
Returns information about the current operating environment |
| 4 | ISBLANK
Returns TRUE if the value is blank |
| 5 | ISERR
Returns TRUE if the value is any error value except #N/A |
| 6 | ISERROR
Returns TRUE if the value is any error value |
| 7 | ISEVEN
Returns TRUE if the number is even |
| 8 | ISFORMULA
Returns TRUE if there is a reference to a cell that contains a formula |
| 9 | ISLOGICAL
Returns TRUE if the value is a logical value |
| 10 | ISNA
Returns TRUE if the value is the #N/A error value |
| 11 | ISNONTEXT
Returns TRUE if the value is not text |
| 12 | ISNUMBER
Returns TRUE if the value is a number |
| 13 | ISODD
Returns TRUE if the number is odd |
| 14 | ISREF
Returns TRUE if the value is a reference |
| 15 | ISTEXT
Returns TRUE if the value is text |
| 16 | N
Returns a value converted to a number |
| 17 | NA
Returns the error value #N/A |
| 18 | SHEET
Returns the sheet number of the referenced sheet |
| 19 | SHEETS
Returns the number of sheets in a reference |
| 20 | TYPE
Returns a number indicating the data type of a value |
”;