Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Digging Up the Facts
Table 15-1 shows the list of possible entries for the first argument of the CELL
function.
Table 15-1
Selecting the First Argument for the CELL Function
Argument
Example
Comment
address
=CELL
(“address”)
Returns the address of the last
changed cell.
col
=CELL
(“col”,Sales)
Returns the column number of
the first cell in the Sales range.
color
=CELL
(“color”,B3)
Tells whether a particular cell
(in this case, cell B3) is
formatted in such a way that negative
numbers are represented in
color. The number, currency,
and custom formats have
selections for displaying negative
numbers in red. If the cell is
formatted for color-negative
numbers, a 1 is returned; otherwise,
a 0 is returned.
contents
=CELL
(“contents”,B3)
Returns the contents of a
particular cell (in this case,
cell B3). If the cell contains a
formula, returns the result of
the formula and not the
formula itself.
filename
=CELL
(“filename”)
Returns the path, filename,
and worksheet name of the
workbook and worksheet that
has the CELL function in it (for
example, C:\Customers\[Acme
Company]Sheet1). Results in
a blank answer in a new
workbook that has not yet
been saved.
format
=CELL
(“format”,D12)
Returns a cell’s number format
(in this case, cell D12). See
Table 15-2 for a list of possible
returned values.
Search JabSto ::




Custom Search