Excel2003函數(shù)應(yīng)用完全手冊.doc (554.5 KB)[local]1[/local]【資料名稱】：網(wǎng)絡(luò)優(yōu)化之excel函數(shù)使用大全

【資料作者】：nicle

【資料日期】：2011.07.25

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

一、函數(shù)應(yīng)用基礎(chǔ)......................................................................................................................................... 10
（一）函數(shù)和公式......................................................................................................................................... 10
1.什么是函數(shù)................................................................................................................................................. 10
2.什么是公式................................................................................................................................................. 10
（二）函數(shù)的參數(shù)..........................................................................................................................................10
1.常量............................................................................................................................................................. 10
2.邏輯值......................................................................................................................................................... 10
3.數(shù)組............................................................................................................................................................. 10
4.錯誤值......................................................................................................................................................... 10
5.單元格引用................................................................................................................................................. 10
6.嵌套函數(shù)..................................................................................................................................................... 10
7.名稱和標(biāo)志................................................................................................................................................. 10
（三）函數(shù)輸入方法..................................................................................................................................... 11
1.“插入函數(shù)”對話框................................................................................................................................. 11
2.編輯欄輸入................................................................................................................................................. 11
二、函數(shù)速查一覽..........................................................................................................................................11
(一)數(shù)據(jù)庫函數(shù).............................................................................................................................................. 12
1.DAVERAGE..................................................................................................................................................... 12
3.DCOUNTA....................................................................................................................................................... 12
4.DGET............................................................................................................................................................. 12
5.DMAX............................................................................................................................................................. 12
6.DMIN............................................................................................................................................................. 12
7.DPRODUCT..................................................................................................................................................... 12
8.DSTDEV......................................................................................................................................................... 13
9.DSTDEVP....................................................................................................................................................... 13
10.DSUM........................................................................................................................................................... 13
11.DVAR........................................................................................................................................................... 13
12.DVARP......................................................................................................................................................... 13
13.GETPIVOTDATA ......................................................................................................................................... 13
(二)日期與時間函數(shù)...................................................................................................................................... 13
1.DATE............................................................................................................................................................. 13
2.DATEVALUE ................................................................................................................................................. 14
3.DAY............................................................................................................................................................... 14
4.DAYS360....................................................................................................................................................... 14
5.EDATE........................................................................................................................................................... 14
6.EOMONTH....................................................................................................................................................... 14
7.HOUR............................................................................................................................................................. 15
8.MINUTE......................................................................................................................................................... 15
9.MONTH........................................................................................................................................................... 15
10.NETWORKDAYS ........................................................................................................................................... 15
11.NOW............................................................................................................................................................. 15
12.SECOND....................................................................................................................................................... 15
13.TIME........................................................................................................................................................... 16
14.TIMEVALUE ............................................................................................................................................... 16
15.TODAY......................................................................................................................................................... 16
16.WEEKDAY..................................................................................................................................................... 16
17.WEEKNUM..................................................................................................................................................... 16
18.WORKDAY..................................................................................................................................................... 16
19.YEAR........................................................................................................................................................... 17
20.YEARFRAC ................................................................................................................................................. 17
(三)外部函數(shù).................................................................................................................................................. 17
1.EUROCONVERT ............................................................................................................................................. 17
2.SQL.REQUEST ............................................................................................................................................. 17
(四)工程函數(shù).................................................................................................................................................. 18
1.BESSELI....................................................................................................................................................... 18
2.BESSELJ....................................................................................................................................................... 18
3.BESSELK....................................................................................................................................................... 18
4.BESSELY....................................................................................................................................................... 18
5.BIN2DEC....................................................................................................................................................... 18
6.BIN2HEX....................................................................................................................................................... 18
7.BIN2OCT....................................................................................................................................................... 18
8.COMPLEX....................................................................................................................................................... 18
9.CONVERT....................................................................................................................................................... 19
10.DEC2BIN..................................................................................................................................................... 19
11.DEC2HEX..................................................................................................................................................... 19
12.DEC2OCT..................................................................................................................................................... 19
13.DELTA......................................................................................................................................................... 19
14.ERF............................................................................................................................................................. 19
15.ERFC........................................................................................................................................................... 19
16.GESTEP....................................................................................................................................................... 19
17.HEX2BIN..................................................................................................................................................... 19
18.HEX2DEC..................................................................................................................................................... 20
19.HEX2OCT..................................................................................................................................................... 20
20.IMABS......................................................................................................................................................... 20
21.IMAGINARY ............................................................................................................................................... 20
22.IMARGUMENT ............................................................................................................................................. 20
23.MCONJUGATE ............................................................................................................................................. 20
24.IMCOS......................................................................................................................................................... 2
25.IMDIV.........................................................................................................................................................20
26.IMEXP......................................................................................................................................................... 20
27.IMLN........................................................................................................................................................... 21
28.IMLOG10................................................................................................................................................... 21
29.IMLOG2..................................................................................................................................................... 21
30.IMPOWER................................................................................................................................................... 21
31.IMPRODUCT ............................................................................................................................................. 21
32.IMREAL..................................................................................................................................................... 21
33.IMSIN....................................................................................................................................................... 21
34.IMSQRT..................................................................................................................................................... 21
35.IMSUB....................................................................................................................................................... 21
36.IMSUM....................................................................................................................................................... 22
37.OCT2BIN................................................................................................................................................... 22
38.OCT2DEC................................................................................................................................................... 22
39.OCT2HEX................................................................................................................................................... 22
(五)財(cái)務(wù)函數(shù)................................................................................................................................................ 22
1.ACCRINT..................................................................................................................................................... 22
2.ACCRINTM................................................................................................................................................... 22
3.AMORDEGRC ............................................................................................................................................... 22
4.AMORLINC................................................................................................................................................... 22
5.COUPDAYBS ............................................................................................................................................... 23