SCHOOL BOOKS


SCHOOL BOOKS




EXAM TIME TABLE 2018 -- +2 +1 10TH










Tamilnadu School Books Change for Academic Years


Standards


Academic year




2, 7, 10 & 12


2019-20


3, 4, 5 & 8


2020-21





STD - 1
STD - 2
STD - 3
STD - 4
STD - 5
STD - 6
STD - 7
STD - 8
STD - 9
STD - 10
STD - 11
STD - 12









.

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 plus1 all books free download, Tamilnadu 11th all books free download