Information functions: cell, errortype, info, islogical, isna
Excel Function CELL
The CELL() function is used to find the information about a specified cell in the sheet.
The information can be anything ranging from formatting, colour, contents and so on.
The syntax of this function is as given below:
| Value | CELL() | Formula | Comment |
| A | $A$10 | =CELL("address",L2) | gives the address of the cell |
| 2 | 1 | =CELL("col",L5) | give the column number of the cell |
| Hello | Hello | =CELL("contents",L6) | brings out the content |
| -34 | 1 | =CELL("color",L8) | confusing name, only detects special format #'##0.00;[Red]-#'##0.00 |
| -5 | 1 | =CELL("parentheses",L9) | detect special format (#'##0);-#'##0 with parentheses for positive numbers |
| L | 15 | =CELL("row",L11) | gives the row number |
| m | l | =CELL("type",L12) | Returns "b" empty cell, "l" for label if the cell contains a text constant, and "v" for value if the cell contains anything else. |
Excel Function ERROR.TYPE
The ERROR.TYPE() function is used to return an integer specifying a particular error.
The syntax of this function is as given below:
ERROR.TYPE(error value)
| Value | ERROR.TYPE() | Formula |
| #DIV/0! | 2 | =ERROR.TYPE(L20) |
| #NAME? | 5 | =ERROR.TYPE(L21) |
| #VALUE! | 3 | =ERROR.TYPE(L22) |
| #REF! | 4 | =ERROR.TYPE(L23) |
| #NAME? | 5 | =ERROR.TYPE(L24) |
| #NUM! | 6 | =ERROR.TYPE(L25) |
| #N/A | 7 | =ERROR.TYPE(L26) |
| #NULL! | 1 | =ERROR.TYPE(L27) |
Excel Function INFO
The INFO() function is used to obtain information about the current operating environment. You will get information about the directory, files, the operating system
This function returns a string containing the information.
The syntax of this function is as given below:
INFO(text)
| INFO() | Formula |
| C:\Users\Goldorak\Documents\ | =INFO("DIRECTORY") |
| 57 | =INFO("NUMFILE") |
| $A:$A$1 | =INFO("ORIGIN") |
| Windows (32-bit) NT 10.00 | =INFO("OSVERSION") |
| Automatic | =INFO("RECALC") |
| pcdos | =INFO("SYSTEM") |
| Study | =INFO("RELEASE") |
Excel Function ISLOGICAL
The ISLOGICAL() function is used to determine if the supplied expression or value returns a logical result.
That is, if the result is TRUE or FALSE?
This function also returns a Boolean TRUE or FALSE.
The syntax of this function is as given below:
ISLOGICAL(expression)
| ISLOGICAL() | Formula |
| True | =ISLOGICAL(TRUE) |
| True | =ISLOGICAL(FALSE) |
| Study | =ISLOGICAL("FALSE") |
| True | =ISLOGICAL("FALSE") |
| True | =ISLOGICAL(OR(TRUE,TRUE)) |
| False | =ISLOGICAL(1) |
| False | =ISLOGICAL(N54) |
Excel Function ISNA
The ISNA() function is used to determine if a "#NA" error is obtained.
This function returns TRUE if the #NA error occurs, else it returns a FALSE.
The syntax of this function is as given below:
ISNA(value or expression)
| ISNA() | Formula |
| False | =ISNA("#NA") |
| True | =ISNA(#N/A) |
| True | ISNA(VLOOKUP(H67,I60:I63,1,TRUE)) |
| False | =ISNA(J64) |