.

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)

.

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