MSOfficeExcel 2007 Tutorial Information Functions 50 codes

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Information Functions
1 =CELL (address) returns the address of the last changed cell
2 =CELL (contents,B3) returns the contents of B3
3 =CELL (filename) returns the path, filename, and work sheet name of the workbook and worksheet
4 =CELL (format,D1) returns a number format
5 =CELL (protect,A1) returns 1 if a protection is set to locked
6 =CELL(color, B3) tells whether B3 is formatted for color-negative numbers
7 =CELL(prefix, A1) returns the type of text alignment in a cell
8 =CELL(row, B6) returns the row number of the first cell in the range
9 =CELL(row, Summary) returns the row number of the first cell in the name
10 =CELL(type, A1) returns the type of information in a cell
11 =CELL(width) returns the width of the last changed cell, rounded to an integer
12 =CELL(width, A1) returns the width of A1
13 =ERROR TYPE(#NULL!) Number of the #NULL! error
14 =INFO(directory) returns the path of the current directory
15 =INFO(numfile) return the number of active worksheets
16 =INFO(origin) returns the address of the cell at the top and to the left of the scrollable area
17 =INFO(osversion) returns the name of the current operating system
18 =INFO(recalc) returns the recalculation mode for the workbook
19 =INFO(release) returns the version number of Excel being run
20 =INFO(system) returns the name of the operating environment
21 =ISEVEN(-1) checks whether -1 is even
22 =ISEVEN(2 5) checks whether 2 5 is even
23 =ISODD(2 5) checks whether 2 5 is odd
24 =ISODD(5) checks whether 5 is odd
25 =TYPE({1,2;3,4}) checks the type of an array constant
26 =TYPE(2+A) checks the type of the formula, which returns the error #VALUE!
27 =TYPE(A1) checks the type of the value above
28 Cell function
29 Combine CHOOSE and ERROR TYPE to display friendly error message
30 Combine IF and INFO formula to check the Excel version
31 Counting Nontext Cells
32 Determining Whether a Cell Contains Text
33 ERROR TYPE(error_val) returns a number corresponding to an error type
34 If #NULL! or #DIV0!, display messages
35 INFO(type_text) returns information about the current environment
36 ISBLANK returns TRUE if the value is blank
37 ISERR returns TRUE if the value is any error value except #NA
38 ISERROR returns TRUE if the value is any error value
39 ISEVEN(number) returns TRUE if the number is even
40 ISLOGICAL returns TRUE if the value is a logical value
41 ISNA returns TRUE if the value is the #NA error value
42 ISNUMBER returns TRUE if the value is a number
43 ISODD(number) returns TRUE if the number is odd
44 ISREF returns TRUE if the value is a reference
45 ISTEXT returns TRUE if the value is text
46 NA returns the error value #NA
47 Return the number of logical values (TRUE or FALSE) in a range named Data
48 Return the total number of #NA error values in a range named Data
49 Return the total number of error values in a range named Data
50 TYPE(value) returns a number indicating the data type of a value