17.VLOOKUP................................................................................................................................................... 21
(九)数学和三角函数............................................................................................................................................ 21
1.ABS............................................................................................................................................................. 21
2.ACOS........................................................................................................................................................... 21
3.ACOSH......................................................................................................................................................... 22
4.ASIN........................................................................................................................................................... 22
5.ASINH......................................................................................................................................................... 22
6.ATAN........................................................................................................................................................... 22
7.ATAN2......................................................................................................................................................... 22
8.ATANH......................................................................................................................................................... 22
9.CEILING..................................................................................................................................................... 22
10.COMBIN..................................................................................................................................................... 22
11.COS........................................................................................................................................................... 22
12.COSH......................................................................................................................................................... 23
13.COUNTIF................................................................................................................................................... 23
14.DEGREES................................................................................................................................................... 23
15.EVEN......................................................................................................................................................... 23
16.EXP........................................................................................................................................................... 23
17.FACT......................................................................................................................................................... 23
18.FACTDOUBLE............................................................................................................................................. 23
19.FLOOR....................................................................................................................................................... 23
20.GCD........................................................................................................................................................... 23
21.INT........................................................................................................................................................... 23
22.LCM........................................................................................................................................................... 24
23.LN............................................................................................................................................................. 24
24.LOG........................................................................................................................................................... 24
25.LOG10....................................................................................................................................................... 24
26.MDETERM................................................................................................................................................... 24
27.MINVERSE................................................................................................................................................. 24
28.MMULT....................................................................................................................................................... 24
29.MOD........................................................................................................................................................... 24
30.MROUND..................................................................................................................................................... 24
31.MULTINOMIAL........................................................................................................................................... 25
32.ODD........................................................................................................................................................... 25
33.PI............................................................................................................................................................. 25
34.POWER....................................................................................................................................................... 25
35.PRODUCT................................................................................................................................................... 25
36.QUOTIENT................................................................................................................................................. 25
37.RADIANS................................................................................................................................................... 25
38.RAND......................................................................................................................................................... 25
39.RANDBETWEEN........................................................................................................................................... 25
40.ROMAN....................................................................................................................................................... 26
41.ROUND....................................................................................................................................................... 26
42.ROUNDDOWN............................................................................................................................................... 26
6
43.ROUNDUP................................................................................................................................................... 26
44.SERIESSUM............................................................................................................................................... 26
45.SIGN......................................................................................................................................................... 26
46.SIN........................................................................................................................................................... 26
47.SINH......................................................................................................................................................... 26
48.SQRT......................................................................................................................................................... 26
49.SQRTPI..................................................................................................................................................... 27
50.SUBTOTAL................................................................................................................................................. 27
51.SUM........................................................................................................................................................... 27
52.SUMIF....................................................................................................................................................... 27
53.SUMPRODUCT............................................................................................................................................. 27
54.SUMSQ....................................................................................................................................................... 27
55.SUMX2MY2................................................................................................................................................. 27
56.SUMX2PY2................................................................................................................................................. 27
57.SUMXMY2................................................................................................................................................... 28
58.TAN........................................................................................................................................................... 28
60.TRUNC....................................................................................................................................................... 28
(十)统计函数........................................................................................................................................................ 28
1.AVEDEV....................................................................................................................................................... 28
2.AVERAGE..................................................................................................................................................... 28
3.AVERAGEA................................................................................................................................................... 28
4.BETADIST................................................................................................................................................... 28
5.BETAINV..................................................................................................................................................... 28
6.BINOMDIST................................................................................................................................................. 29
7.CHIDIST..................................................................................................................................................... 29
8.CHIINV....................................................................................................................................................... 29
9.CHITEST..................................................................................................................................................... 29
10.CONFIDENCE............................................................................................................................................. 29
11.CORREL..................................................................................................................................................... 29
12.COUNT....................................................................................................................................................... 29
13.COUNTA..................................................................................................................................................... 30
14.COUNTBLANK............................................................................................................................................. 30
15.COUNTIF................................................................................................................................................... 30
16.COVAR....................................................................................................................................................... 30
17.CRITBINOM............................................................................................................................................... 30
18.DEVSQ....................................................................................................................................................... 30
19.EXPONDIST............................................................................................................................................... 30
20.FDIST....................................................................................................................................................... 30
21.FINV......................................................................................................................................................... 30
22.FISHER..................................................................................................................................................... 31
23.FISHERINV............................................................................................................................................... 31
24.FORECAST................................................................................................................................................. 31
25.FREQUENCY............................................................................................................................................... 31
26.FTEST....................................................................................................................................................... 31
27.GAMMADIST............................................................................................................................................... 31
28.GAMMAINV................................................................................................................................................. 31
7
29.GAMMALN................................................................................................................................................... 31
