Excel 应用03_公式使用

2009/11/30

--------------------------------------------

CONCATENATE("A1","A2") =A1A2
WEEKDAY("2009/12/1",1) =3
YEAR("2009/12/1")            =2009
MONTH("2009/12/1")        =12
DAY("2009/12/1")             =1
DATE(2009,12+1,1)-1       =2009/12/31
HOUR("08:30:18")            =8
MINITE("08:30:18")          =30
HOUR("08:30:18")            =18
TIME(9,26,17)                   =9:26 AM
格式->条件格式       
COUNTIF(,)       
IF(OR(3<1,3<4),TRUE,FALSE)   =TRUE
IF(AND(3<1,3<4),TRUE,FALSE)  =FALSE
CEILING(1.236,1)               =2
RIGHT(2.365,2)                  =65
LEFT(2.365,2)                    =2.
MID(20091214,2,3)           =009

 

2010/05/07
--------------------------------------------
1.求一列中最大数：

    =MAX(A:A),=MAX(sheet1!A:A)
2.合计A列中等于"ILOVEU"的B列中行值：

    =SUMIF(A:A,"ILOVEU",B:B)

3.