excel常用函数完全手册.docx
《excel常用函数完全手册.docx》由会员分享，可在线阅读，更多相关《excel常用函数完全手册.docx（124页珍藏版）》请在冰豆网上搜索。
excel常用函数完全手册
Excel2003
函数应用完全手册
二〇〇四年二月二日
目录
一、函数应用基础.........................................................................................................................................................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
（二）日期与时间函数..............................................................................................................................................4
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
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......................................................................................................................
升级会员 