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...........................................................................................................................................….