30.GEOMEAN................................................................................................................................................... 31
31.GROWTH..................................................................................................................................................... 32
32.HARMEAN................................................................................................................................................... 32
33.HYPGEOMDIST........................................................................................................................................... 32
34.INTERCEPT............................................................................................................................................... 32
35.KURT......................................................................................................................................................... 32
36.LARGE....................................................................................................................................................... 32
37.LINEST..................................................................................................................................................... 32
38.LOGEST..................................................................................................................................................... 33
39.LOGINV..................................................................................................................................................... 33
40.LOGNORMDIST........................................................................................................................................... 33
41.MAX........................................................................................................................................................... 33
42.MAXA......................................................................................................................................................... 33
43.MEDIAN..................................................................................................................................................... 33
44.MIN........................................................................................................................................................... 33
45.MINA......................................................................................................................................................... 33
46.MODE......................................................................................................................................................... 33
47.NEGBINOMDIST......................................................................................................................................... 34
48.NORMDIST................................................................................................................................................. 34
49.NORMSINV................................................................................................................................................. 34
50.NORMSDIST............................................................................................................................................... 34
51.NORMSINV................................................................................................................................................. 34
52.PEARSON................................................................................................................................................... 34
53.PERCENTILE............................................................................................................................................. 34
54.PERCENTRANK........................................................................................................................................... 34
55.PERMUT..................................................................................................................................................... 35
56.POISSON................................................................................................................................................... 35
57.PROB......................................................................................................................................................... 35
58.QUARTILE................................................................................................................................................. 35
59.RANK......................................................................................................................................................... 35
60.RSQ........................................................................................................................................................... 35
61.SKEW......................................................................................................................................................... 35
62.SLOPE....................................................................................................................................................... 35
63.SMALL....................................................................................................................................................... 36
64.STANDARDIZE........................................................................................................................................... 36
65.STDEV....................................................................................................................................................... 36
66.STDEVA..................................................................................................................................................... 36
67.STDEVP..................................................................................................................................................... 36
68.STDEVPA................................................................................................................................................... 36
69.STEYX....................................................................................................................................................... 36
70.TDIST....................................................................................................................................................... 37
71.TINV......................................................................................................................................................... 37
72.TREND....................................................................................................................................................... 37
73.TRIMMEAN................................................................................................................................................. 37
74.TTEST....................................................................................................................................................... 37
8
75.VAR........................................................................................................................................................... 37
76.VARA......................................................................................................................................................... 37
77.VARP......................................................................................................................................................... 37
78.VARPA....................................................................................................................................................... 38
79.WEIBULL................................................................................................................................................... 38
80.ZTEST....................................................................................................................................................... 38
(十一)文本和数据函数........................................................................................................................................ 38
1.ASC............................................................................................................................................................. 38
2.CHAR........................................................................................................................................................... 38
3.CLEAN......................................................................................................................................................... 38
4.CODE........................................................................................................................................................... 38
5.CONCATENATE............................................................................................................................................. 38
6.DOLLAR 或RMB........................................................................................................................................... 38
7.EXACT......................................................................................................................................................... 39
8.FIND........................................................................................................................................................... 39
9.FINDB......................................................................................................................................................... 39
10.FIXED....................................................................................................................................................... 39
11.JIS........................................................................................................................................................... 39
12.LEFT 或LEFTB......................................................................................................................................... 39
13.LEN 或LENB............................................................................................................................................. 39
14.LOWER....................................................................................................................................................... 40
15.MID 或MIDB............................................................................................................................................. 40
16.PHONETIC................................................................................................................................................. 40
17.PROPER..................................................................................................................................................... 40
18.REPLACE 或REPLACEB............................................................................................................................. 40
19.REPT......................................................................................................................................................... 40
20.RIGHT 或RIGHTB..................................................................................................................................... 40
21.SEARCH 或SEARCHB................................................................................................................................. 41
22.SUBSTITUTE............................................................................................................................................. 41
23.T............................................................................................................................................................... 41
24.TEXT......................................................................................................................................................... 41
25.TRIM......................................................................................................................................................... 41
26.UPPER....................................................................................................................................................... 41
27.VALUE....................................................................................................................................................... 41
28.WIDECHAR................................................................................................................................................. 41
三、函数应用案例──算账理财................................................................................................................................ 42
1.零存整取储蓄................................................................................................................................................... 42
2.还贷金额............................................................................................................................................................ 42
3.保险收益............................................................................................................................................................ 42
4.个税缴纳金额.................................................................................................................................................... 43
四、函数应用案例──信息统计................................................................................................................................ 43
1.性别输入............................................................................................................................................................ 43
2.出生日期输入.................................................................................................................................................... 44
3.职工信息查询.................................................................................................................................................... 44
4.职工性别统计.................................................................................................................................................... 45
5.年龄统计............................................................................................................................................................ 45
9
6.名次值统计........................................................................................................................................................ 45
