CELL EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

CELL

     
 
 
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. D:\4GP BACK UP\EXCEL FORMULA\[EXCEL-Formula-Dictionary 2010.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("Type Of InfoRequired",CellToTest)
The Type Of Info Required 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)