Information Functions

Below listed are the various information functions of Microsoft Excel.

Cell():

CELL function is used to find the information about its content, formatting, etc

Error.type():

ERROR.TYPE function returns the number which represents the type of error.

Info():

INFO function provides information about the operating environment of the computer.

Isblank():

ISBLANK function is used to find if the given cell is empty or not.

Iserr():

ISERR function is used to find if there is any error value in a cell.

Iserror():

The ISERROR () indicates whether the given expression contains an error value or not.

Iseven():

ISEVEN function is used to find if the given number is even or not.

Islogical():

ISLOGICAL function checks if the content of the given cell is logical or not.

Isna():

ISNA function used to find if the given cell contains #N/A (Not applicable) error.

Isnontext():

ISNONTEXT function is used to determine whether the given cell contains a non-text or a text.

Isnumber():

ISNUMBER function is used to determine whether the given cell contains number or not.

Isodd():

ISODD function is used to find if the given number is odd or not.

Isref():

ISREF function shows if the given value inside the function is a cell address.

Istext():

ISTEXT function is used to determine whether the given cell contains text or not.

N():

N function returns the mathematical value of the given entry.

NA():

The NA () displays the error value when there is no value available in the cell.

Type():

The TYPE () returns the nature of the value.