Page 439 - Excel 2013 All-in-One For Dummies

Information, Please . . . 421
Table 6-1
CELL Function info_type Argument
“address”
“col” “color”
“contents” “filename”
“format”
“parentheses” “prefix”
“protect”
“row” “type”
“width”
The CELL Functions info_type Arguments Returns This Information
Cell address of the first cell in the reference as text using absolute cell references
Column number of the first cell in the reference
1 when the cell is formatted in color for negative values; oth- erwise returns 0 (zero)
Value of the upper-left cell in the reference
Filename (including the full pathname) of the file containing the cell reference: returns empty text (“”) when the workbook containing the reference has not yet been saved
Text value of the number format of the cell (see Table 6-2): Returns “-” at the end of the text value when the cell is for- matted in color for negative values and “()” when the value is formatted with parentheses for positive values or for all values
1 when the cell is formatted with parentheses for positive values or for all values
Text value of the label prefix used in the cell: Single quote (‘) when text is left-aligned; double quote (“) when text is right- aligned; caret (^) when text is centered; backslash (\) when text is fill-aligned; and empty text (“”) when the cell contains any other type of entry
0 when the cell is unlocked and 1 when the cell is locked (see Book IV, Chapter 1 for details on protecting cells in a worksheet)
Row number of the first cell in the reference
Text value of the type of data in the cell: “b” for blank when cell is empty; “l” for label when cell contains text constant; and “v” for value when cell contains any other entry
Column width of the cell rounded off to the next highest integer (each unit of column width is equal to the width of one char- acter in Excel’s default font size)
Table 6-2 shows the different text values along with their number formats (codes) that can be returned when you specify “format” as the info_type argument in a CELL function. (Refer to Book II, Chapter 3 for details on number formats and the meaning of the various number format codes.)
Book III Chapter 6
Lookup, Information, and Text Formulas