【資料名稱】：Excel2003函數(shù)應用完全手冊

【資料作者】：1

【資料日期】：1

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

一、函數(shù)應用基礎.......................................................................................................................................................... 1
（一）函數(shù)和公式.................................................................................................................................................. 1
1.什么是函數(shù).................................................................................................................................................. 1
2.什么是公式.................................................................................................................................................. 1
（二）函數(shù)的參數(shù).................................................................................................................................................. 1
1.常量.............................................................................................................................................................. 1
2.邏輯值.......................................................................................................................................................... 1
3.數(shù)組.............................................................................................................................................................. 1
4.錯誤值.......................................................................................................................................................... 1
5.單元格引用.................................................................................................................................................. 1
6.嵌套函數(shù)...................................................................................................................................................... 2
7.名稱和標志.................................................................................................................................................. 2
（三）函數(shù)輸入方法.............................................................................................................................................. 2
1.“插入函數(shù)”對話框.................................................................................................................................. 2
2.編輯欄輸入.................................................................................................................................................. 3
二、函數(shù)速查一覽.......................................................................................................................................................... 3
(一)數(shù)據(jù)庫函數(shù)....................................................................................................................................................... 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
(二)日期與時間函數(shù)............................................................................................................................................... 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
3
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
(三)外部函數(shù)........................................................................................................................................................... 7
1.EUROCONVERT ................................................................................................................................................ 7
2.SQL.REQUEST ................................................................................................................................................ 7
(四)工程函數(shù)........................................................................................................................................................... 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
4
33.IMSIN........................................................................................................................................................ 10
34.IMSQRT...................................................................................................................................................... 10
35.IMSUB........................................................................................................................................................ 10
36.IMSUM........................................................................................................................................................ 10
37.OCT2BIN.................................................................................................................................................... 10
38.OCT2DEC.................................................................................................................................................... 10
39.OCT2HEX.................................................................................................................................................... 10
(五)財務函數(shù)......................................................................................................................................................... 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........................................................................................................................................................ 13
25.MDURATION ................................................................................................................................................ 13
26.MIRR.......................................................................................................................................................... 13
27.NOMINAL.................................................................................................................................................... 13
28.NPER.......................................................................................................................................................... 13
29.NPV............................................................................................................................................................ 13
30.ODDFPRICE ................................................................................................................................................ 13
31.ODDFYIELD ................................................................................................................................................ 14
32.ODDLPRICE ................................................................................................................................................ 14
33.ODDLYIELD ................................................................................................................................................ 14
34.PMT............................................................................................................................................................ 14
35.PPMT.......................................................................................................................................................... 14
36.PRICE........................................................................................................................................................ 14
37.PRICEDISC ................................................................................................................................................ 14
38.PRICEMAT .................................................................................................................................................. 15
5
39.PV.............................................................................................................................................................. 15
40.RATE.......................................................................................................................................................... 15
41.RECEIVED .................................................................................................................................................. 15
42.SLN............................................................................................................................................................ 15
43.SYD............................................................................................................................................................ 15
44.TBILLEQ.................................................................................................................................................... 15
45.TBILLPRICE .............................................................................................................................................. 15
46.TBILLYIELD .............................................................................................................................................. 15
47.VDB............................................................................................................................................................ 15
48.XIRR.......................................................................................................................................................... 16
49.XNPV.......................................................................................................................................................... 16