CELL Function (Functions in Excel)

This is the cell and contents to test.	17.50%
The cell address.	$D$3	=CELL("address",D3)
The column number.	4	=CELL("col",D3)
The row number.	3	=CELL("row",D3)
The actual contents of the cell.	0.175	=CELL("contents",D3)
The type of entry in the cell. Shown as b for blank, l for text, v for value.	v	=CELL("type",D3)
The alignment of the cell. Shown as ' for left, ^ for centre, " for right. Nothing is shown for numeric entries.		=CELL("prefix",D3)
The width of the cell.	12	=CELL("width",D3)
The number format fo the cell. (See the table shown below)	P2	=CELL("format",D3)
Formatted for braces ( ) on positive values. 1 for yes, 0 for no.	0	=CELL("parentheses",D3)
Formatted for coloured negatives. 1 for yes, 0 for no.	0	=CELL("color",D3)
The type of cell protection. 1 for a locked, 0 for unlocked.	0	=CELL("protect",D3)
The filename containing the cell.	F:\Excel\[Functions in Excel.xls]CELL
		=CELL("filename",D3)

What Does It Do ?

This function examines a cell and displays information about the contents, position and formatting.

Syntax

=CELL("TypeOfInfoRequired",CellToTest)

The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".

Formatting

No special formatting is needed.

Codes used to show the formatting of the cell.

Numeric Format	Code
General	G
0	F0
#,##0	,0
0.00	F2
#,##0.00	,2
$#,##0_);($#,##0)	C0
$#,##0_);[Red]($#,##0)	C0-
$#,##0.00_);($#,##0.00)	C2
$#,##0.00_);[Red]($#,##0.00)	C2-
0%	P0
0.00%	P2
0.00E+00	S2
# ?/? or # ??/??	G
m/d/yy or m/d/yy h:mm or mm/dd/yy.	D4
d-mmm-yy or dd-mmm-yy	D1
d-mmm or dd-mmm	D2
mmm-yy	D3
mm/dd	D5
h:mm AM/PM	D7
h:mm:ss AM/PM	D6
h:mm	D9
h:mm:ss	D8

Example
The following example uses the =CELL() function as part of a formula which extracts the filename.
	The name of the current file is :	Functions in Excel.xls
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)

Related Posts by Categories