Excel函数应用完全手册.doc资源-CSDN下载

62 浏览量 2025-06-14 12:47:12 上传评论收藏 462KB DOC 举报

资源推荐

资源详情

资源评论

Excel 2023

函数应用完全手册

二〇〇四年二月二日

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

........................................................................................................................…..................... 7

(四)工程函数..................................................................................................................................................... 7

1.BESSELI.......................................................................................................................................…….............. 7

2.BESSELJ........................................................................................................................................……............. 8

3.BESSELK.............................................................................................................................……....................... 8

4.BESSELY......................................................................................................................................……............... 8

5.BIN2DEC....................................................................................................................................……................. 8

6.BIN2HEX..................................................................................................................................……................... 8

7.BIN2OCT...................................................................................................................................……................... 8

8 PLEX................................................................................................................................…....................... 8

9.CONVERT.................................................................................................................................…….................... 8

10.DEC2BIN................................................................................................................................…….................... 8

11.DEC2HEX...............................................................................................................................…….................... 8

12.DEC2OCT.................................................................................................................................…….................. 8

13.DELTA......................................................................................................................................…….................. 8

14.ERF...........................................................................................................................................…….................. 8

15.ERFC........................................................................................................................................……................. 9

16.GESTEP....................................................................................................................................…….................. 9

17.HEX2BIN..................................................................................................................................……................. 9

18.HEX2DEC..................................................................................................................................……................. 9

19.HEX2OCT..................................................................................................................................……................. 9

20.IMABS........................................................................................................................................……................ 9

21.IMAGINARY ..............................................................................................................................…................... 9

22.IMARGUMENT .....................................................................................................................…........................ 9

23.MCONJUGATE .....................................................................................................................…........................ 9

24.IMCOS.....................................................................................................................................……................... 9

25.IMDIV....................................................................................................................................…….................... 9

26.IMEXP...............................................................................................................................……......................... 9

27.IMLN......................................................................................................................................…….................... 9

28.IMLOG10............................................................................................................................……...................... 10

29.IMLOG2..............................................................................................................................……...................... 10

30.IMPOWER...............................................................................................................................…….................. 10

31.IMPRODUCT .........................................................................................................................…...................... 10

32.IMREAL......................................................................................................................................….............. 10

33.IMSIN..........................................................................................................................................……........... 10

34.IMSQRT......................................................................................................................................…............... 10

35.IMSUB..........................................................................................................................................….…......... 10

36.IMSUM..............................................................................................................................................…........ 10

37.OCT2BIN...........................................................................................................................................…........ 10

38.OCT2DEC........................................................................................................................................….......... 10

39.OCT2HEX........................................................................................................................................….......... 10

(五)财务函数................................................................................................................................................... 10

1.ACCRINT.................................................................................................................................…................... 10

2.ACCRINTM.......................................................................................................................….......................... 11

3.AMORDEGRC ..................................................................................................................….......................... 11

4.AMORLINC.......................................................................................................................….......................... 11

5.COUPDAYBS ................................................................................................................................................. 11

6.COUPDAYS........................................................................................................................…......................... 11

7.COUPDAYSNC ............................................................................................................................................... 11

8.COUPNUM.........................................................................................................................….......................... 11

9.COUPPCD.........................................................................................................................…........................... 11

10.CUMIPMT......................................................................................................................…............................ 11

11.CUMPRINC ...................................................................................................................…............................ 12

12.DB...................................................................................................................................……........................ 12

13.DDB....................................................................................................................................……..................... 12

14.DISC..........................................................................................................................................…….............. 12

15.DOLLARDE ............................................................................................................................…................... 12

16.DOLLARFR ............................................................................................................................…................... 12

17.DURATION .............................................................................................................................…................... 12

18.EFFECT....................................................................................................................................……............... 12

19.FV..................................................................................................................................................…….......... 12

20.FVSCHEDULE ..........................................................................................................................…................. 12

21.INTRATE..................................................................................................................................……............... 13