CELL Formula in MS 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.	1	=CELL("protect",D3)
	The filename containing the cell.	'file:///home/ravneet/Downloads/EXCEL_Formulae01.xls.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 :	#VALUE!
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)