Function Dictionary Function Examples Function Categories


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.
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
What Does It Do ?        
This function examines a cell and displays information about the contents, position and formatting.
=CELL("Type Of InfoRequired",CellToTest)
The Type Of Info Required is a text entry which must be surrounded with quotes " ".
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
The following example uses the =CELL() function as part of a formula which extracts the filename.
The name of the current file is : #VALUE!


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download