Information Function

it is the group of function which provide us know details about cells, formatting, and workbook properties.

1- CELL

The CELL function returns information about the formatting, location, or contents of a cell.

2- ERROR.TYPE

The ERROR.TYPE function returns a number that corresponds to a specific error value in Microsoft Excel.

3- INFO

The INFO function is an information function in Excel that returns information about the operating environment.

4- ISBLANK

The ISBLANK function in Excel checks if a cell is empty or not.

5- ISERR

The ISERR function in Microsoft Excel is a logical function that returns TRUE when the value provided is an error value other than #N/A, and FALSE when the value is not an error value.

6- ISERROR

The ISERROR function is used to check if a value is an error and returns either TRUE or FALSE.

7- ISEVEN

The ISEVEN function is used to determine whether a number is even or odd.

8- ISFORMULA

The ISFORMULA function in Excel is used to check if a cell contains a formula. It returns TRUE if the cell contains a formula and FALSE if it does not.

9- ISLOGICAL

The ISLOGICAL function is used to check if a value is a logical value (TRUE or FALSE).

10- ISNA

The ISNA function in Excel is used to check whether a given value is the #N/A error value.

11- ISNONTEXT

The ISNONTEXT function is used to check if a value is not text. It returns TRUE if the value is not text and FALSE if it is text.

12- ISNUMBER

The ISNUMBER function is used to determine if a value is a number or not.

13- ISODD

The ISODD function is used to check if a number is odd. It returns TRUE if the number is odd and FALSE if the number is even.

14- ISOMITTED

The ISOMITTED function in Excel checks whether a value is omitted from a list of values.

15- ISREF

The ISREF function checks if a cell reference is valid.

16- ISTEXT

The ISTEXT function is a built-in function in Excel that checks to see if a cell contains text. It returns TRUE if the value is text and FALSE if not.

17- NA

The NA function returns the #N/A error value, which indicates that a value is not available.

18- SHEET

SHEET is an Excel function that returns the sheet number of a reference.

19- SHEETS

The SHEETS function returns the number of sheets in a reference.

20- TYPE

The TYPE function is an Excel Information function that returns a number indicating the type of value in a cell.