Excel CELL Function |

Examples of the Excel Cell Function

		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.	C:\Users\Shahzaib\Downloads\Documents\ [MS Excel Formulas.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 :	MS Excel Formulas.xls
	=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)