Excel120个常用函数集
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
二
○
一
八
年
九
月
十
八
日
星期二
substitute
true
type
trim
time
today
timevalue
trunc
transpose
t
text
upper
value
vlookup
weekday
workday
weeknum
widechar
year
&