当前位置:文档之家 > Excel 2003常用函数完全手册(完善版)

Excel 2003常用函数完全手册(完善版)

Excel 2003

函数应用完全手册二〇〇四年二月二日目录

一、函数应用基础 (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.DA VERAGE. 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.DV AR (4)

12.DV ARP (4)

13.GETPIVOTDATA. 4

(二)日期与时间函数 (4)

1.DATE (4)

2.DATEV ALUE (4)

3.DAY (4)

4.DAYS360 (5)

5.EDATE (5)

6.EOMONTH (5)

7.HOUR (5)

8.MINUTE (5)

9.MONTH. 5

http://www.doczj.com/doc/7e84c917866fb84ae45c8df4.html WORKDAYS ..... 5 11.NOW (6)

12.SECOND (6)

13.TIME (6)

14.TIMEV ALUE (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.BESSEL Y (8)

5.BIN2DEC (8)

6.BIN2HEX (8)

7.BIN2OCT (8)

http://www.doczj.com/doc/7e84c917866fb84ae45c8df4.html 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.MCONJUGA TE (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.CU
MIPMT (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.INTRA TE (13)

22.IPMT (13)

23.IRR (13)

24.ISPMT (13)

25.MDURATION (13)

26.MIRR (13)

27.NOMINAL (13)

28.NPER (13)

29.NPV (13)

30.ODDFPRICE (13)

31.ODDFYIELD (14)

32.ODDLPRICE (14)

33.ODDL YIELD (14)

34.PMT (14)

35.PPMT (14)

下载Word文档免费下载:

Excel 2003常用函数完全手册(完善版)下载

(共62页)