【資料名稱】：wu

【資料作者】：wu

【資料日期】：2010

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

EXCEL中常用函數(shù)，包括操作說明，自己覺得很實用！
一、函數(shù)應(yīng)用基礎(chǔ)......................................................................................................................................... 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
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
33.IMSIN..........................................................................................................................................……........... 10
34.IMSQRT......................................................................................................................................…............... 10
35.IMSUB..........................................................................................................................................….…......... 10
36.IMSUM..............................................................................................................................................…........ 10
37.OCT2BIN...........................................................................................................................................…........ 10
38.OCT2DEC........................................................................................................................................….......... 10
39.OCT2HEX........................................................................................................................................….......... 10

(五)財務(wù)函數(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
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
50.YIELD.............................................................................................................................….......................... 16
51.YIELDDISC ...................................................................................................................….......................... 16
52.YIELDMAT ...........................