Excel2003常用函数完全手册（完善版）.doc

Excel 2003
函数应用完全手册
二〇〇四年二月二日

目 录
一、函数应用基础......................................................................................................................................... 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...........................................................................................................................................….