《Excel 2003函数应用完全手册》
作者：张迎新
内容简介：
Excel 函数即是预先定义, 执行计算, 分析等处理数据任务的特殊公式. 以常用的求和函数SUM 为例, 它的语法是"SUM (number1, number2,)". 其中"SUM" 称为函数名称, 一个函数只有唯一的一个名称, 它决定了函数的功能和用途.
目 录
一、函数应用基础......................................................................................................................................................... 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
2
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
3
33.IMSIN....................................................................................................................................................... 10
34.IMSQRT..................................................................................................................................................... 10
35.IMSUB....................................................................................................................................................... 10
