# Excel Made Easy

## 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)