常用函数完全手册完善版.docx

常用函数完全手册完善版.docx

《常用函数完全手册完善版.docx》由会员分享，可在线阅读，更多相关《常用函数完全手册完善版.docx（124页珍藏版）》请在冰豆网上搜索。

常用函数完全手册完善版

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.................................................................................................