Advanced Excel - Information Functions


Advertisements


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



Advertisements
E-Books Store