excel__函数应用手册.doc
文本预览下载声明
目 录 一、函数应用基础.....1
(一)函数和公式...1
1.什么是函数……...1
2.什么是公式……...1
(二)函数的
参数....1
1.常量…....1
2.逻辑值…1
3.数组…..1
4.错误值....…..1
5.单元格引用.…...1
6.嵌套函数...….....2
7.名称和标志..…....2
(三)函数输入方法.2
1.“插入函数”对话框.…..2
2.编辑栏输入...…..3
二、函数速查一览3
(一)数据库函数...3
1.DAVERAGE.3
2.DCOUNT.…...3
3.DCOUNTA.....…...3
4.DGET………...3
5.DMAX…….....3
6.DMIN……….3
7.DPRODUCT..3
8.DSTDEV.....……...3
9.DSTDEVP....…4
10.DSUM.……..4
11.DVAR.……….....4
12.DVARP.……...4
13.GETPIVOTDATA.4
(二)日期与时间函数...4
1.DATE...……....4
2.DATEVALUE....…4
3.DAY.....…….....4
4.DAYS360...…….....5
5.EDATE.…..5
6.EOMONTH......…....5
7.HOUR....…5
8.MINUTE.....….5
9.MONTH.5
10.NETWORKDAYS.....5
11.NOW....….....6
12.SECOND..…6
13.TIME...….....6
14.TIMEVALUE....6
15.TODAY….....6
16.WEEKDAY...6
17.WEEKNUM..6
18.WORKDAY...6
19.YEAR..…7
20.YEARFRAC.7
(三)外部函数...7
1.EUROCONVERT..7
2.SQL.REQUEST..….7
(四)工程函数...7
1.BESSELI...……7
2.BESSELJ....…….8
3.BESSELK.……...8
4.BESSELY..…….8
5.BIN2DEC……...8
6.BIN2HEX....…….....8
7.BIN2OCT.....…….....8
8.COMPLEX..…...8
9.CONVERT...……8
10.DEC2BIN..……8
11.DEC2HEX.……8
12.DEC2OCT...……....8
13.DELTA..……....8
14.ERF.……....8
15.ERFC....……...9
16.GESTEP……....9
17.HEX2BIN....……...9
18.HEX2DEC....……...9
19.HEX2OCT....……...9
20.IMABS....……..9
21.IMAGINARY….....9
22.IMARGUMENT.....…....9
23.MCONJUGATE.....…....9
24.IMCOS.…….....9
25.IMDIV......……9
26.IMEXP.…….....9
27.IMLN..……9
28.IMLOG10……..10
29.IMLOG2……..10
30.IMPOWER.……....10
31.IMPRODUCT...…..10
32.IMREAL..…10
33.IMSIN......…….....10
34.IMSQRT..….10
35.IMSUB….…...10
36.IMSUM..…..10
37.OCT2BIN.…..10
38.OCT2DEC....…....10
39.OCT2HEX....…....10
(五)财务函数...10
1.ACCRINT...….....10
2.ACCRINTM.…11
3.AMORDEGRC..…11
4.AMORLINC.…11
5.COUPDAYBS.....11
6.COUPDAYS..….....11
7.COUPDAYSNC...11
8.COUPNUM...…11
9.COUPPCD...….11
10.CUMIPMT......…11
11.CUMPRINC...…12
12.DB.....……....12
13.DDB......…….12
14.DISC……12
15.DOLLARDE….....12
16.DOLLARFR….....12
17.DURATION.….....12
18.EFFECT…….12
19.FV......……....12
20.FVSCHEDULE....…...12
21.INTRATE....…….13
22.IPMT.....…….13
23.IRR…….13
24.ISPMT.
显示全部