函数大全.docx
- 文档编号:8700142
- 上传时间:2023-02-01
- 格式:DOCX
- 页数:110
- 大小:93.01KB
函数大全.docx
《函数大全.docx》由会员分享,可在线阅读,更多相关《函数大全.docx(110页珍藏版)》请在冰豆网上搜索。
函数大全
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
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............................................................................................................................................
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 函数 大全