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

WORKDAYS (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 (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)

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.ODDLYIELD (14)

34.PMT (14)

35.PPMT (14)

36.PRICE (14)

37.PRICEDISC (14)

38.PRICEMAT (15)

39.PV (15)

40.RATE (15)

41.RECEIVED (15)

42.SLN (15)

43.SYD (15)

44.TBILLEQ (15)

45.TBILLPRICE (15)

46.TBILLYIELD (15)

47.VDB (15)

48.XIRR (16)

49.XNPV (16)

50.YIELD (16)

51.YIELDDISC (16)

52.YIELDMAT (16)

(六)信息函数 (16)

1.CELL (16)

页脚

2.ERROR.TYPE (16)

(16)

4.IS 类函数 (17)

5.ISEVEN (17)

6.ISODD (17)

7.N (17)

8.NA (17)

9.TYPE (18)

(七)逻辑运算符 (18)

1.AND (18)

2.FALSE (18)

3.IF (18)

4.NOT (18)

5.OR (18)

6.TRUE (18)

(八)查找和引用函数 (19)

1.ADDRESS (19)

2.AREAS (19)

3.CHOOSE (19)

4.COLUMN (19)

5.COLUMNS (19)

页脚

6.HLOOKUP (19)

7.HYPERLINK (19)

8.INDEX (20)

9.INDIRECT (20)

10.LOOKUP (20)

11.MATCH (20)

12.OFFSET (21)

13.ROW (21)

14.ROWS (21)

15.RTD (21)

16.TRANSPOSE (21)

17.VLOOKUP (21)

(九)数学和三角函数 (21)

1.ABS (21)

2.ACOS (21)

3.ACOSH (22)

4.ASIN (22)

5.ASINH (22)

6.ATAN (22)

7.ATAN2 (22)

8.ATANH (22)

9.CEILING (22)

页脚

BIN (22)

11.COS (22)

12.COSH (23)

13.COUNTIF (23)

14.DEGREES (23)

15.EVEN (23)

16.EXP (23)

17.FACT (23)

18.FACTDOUBLE (23)

19.FLOOR (23)

20.GCD (23)

21.INT (23)

22.LCM (24)

23.LN (24)

24.LOG (24)

25.LOG10 (24)

26.MDETERM (24)

27.MINVERSE (24)

28.MMULT (24)

29.MOD (24)

30.MROUND (24)

31.MULTINOMIAL (25)

32.ODD (25)

页脚

33.PI (25)

34.POWER (25)

35.PRODUCT (25)

36.QUOTIENT (25)

37.RADIANS (25)

38.RAND (25)

39.RANDBETWEEN (25)

40.ROMAN (26)

41.ROUND (26)

42.ROUNDDOWN (26)

43.ROUNDUP (26)

44.SERIESSUM (26)

45.SIGN (26)

46.SIN (26)

47.SINH (26)

48.SQRT (26)

49.SQRTPI (27)

50.SUBTOTAL (27)

51.SUM (27)

52.SUMIF (27)

53.SUMPRODUCT (27)

54.SUMSQ (27)

55.SUMX2MY2 (27)

页脚

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说高考高中Excel-2003函数指导应用完全手册簿例范本在线全文阅读。