Office-Excel 120个常用函数集
A类1abs26day
2average27days360
3averagea28dsum
4and29dollar
5address E类30evaluate
6areas31exact
7asc32emonth
C类8ceiling33even
9count34exp
10counta F类35find
11counif36floor
12countblank37false
13cell38frequency
14code39fixed
15char G类40get.cell
16choose41gcd
17clean H类42hlookup
18column43hour
19columns44hyperlink
20combin I 类45if
21concatenaet46int
D类22date47index
23datedif48indirect
24datestring49iserror
25datevalue50isblank
51iseven76offset101
52isnumber P类77power T类102
53isodd78proper103
54istext79product104 L类55large Q类80quotient105 56len R类81right106
57lenb82rightb107
58left83rept108
59leftb84row109
60lower85rows110
61lcm86rank111
62lookup87rand U类112 M类63max88randup V类113 64maxa89randdown114
65min90randbetween W类115
66mina91rmb116
67mod92replace117
68mid S类93sum118
69minute94search119
70mode95sumif其它120 N类71not96second 二○一三年四月四日
星期四
72n 97sqrt 73now
98subtatol 74
networkdays 99sumproduct O类
75or 100
small
type
trim
time
today timevalue trunc transpose t
text
upper value vlookup weekday workday weeknum widechar year
&