Excel函数应用完全手册1.docx

Excel函数应用完全手册1.docx

《Excel函数应用完全手册1.docx》由会员分享，可在线阅读，更多相关《Excel函数应用完全手册1.docx（159页珍藏版）》请在冰点文库上搜索。

Excel函数应用完全手册1

Excel2003

函数应用完全手册

张迎新著

二〇〇四年二月二日

1

目录

一、函数应用基础..........................................................................................................................................................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

2

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