Excel 函数应用完全手册.docx
《Excel 函数应用完全手册.docx》由会员分享,可在线阅读,更多相关《Excel 函数应用完全手册.docx(139页珍藏版)》请在冰点文库上搜索。
Excel函数应用完全手册
Excel函数应用完全手册
目 录
一、函数应用基础......................................................................................................................................... 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.......................................................................