Excel函数大全宝典.docx
《Excel函数大全宝典.docx》由会员分享，可在线阅读，更多相关《Excel函数大全宝典.docx（91页珍藏版）》请在冰豆网上搜索。
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
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..............................................................................................................
升级会员 