没有合适的资源？快使用搜索试试~ 我知道了~
温馨提示
试读
142页
Excel2013函数速查手册-带完整书签 一、 财务函数（55 条） 13 1. ACCRINT 13 2. ACCRINTM 13 3. AMORDEGRC 13 4. AMORLINC 13 5. COUPDAYBS 14 6. COUPDAYS 14 7. COUPDAYSNC 14 8. COUPNCD 14 9. COUPNUM 14 10. COUPPCD 15 11. CUMIPMT 15 12. CUMPRINC 15 13. DB 15 14. DDB 15 15. DISC 15 16. DOLLARDE 16 17. DOLLARFR 16 18. DURATION 16 19. EFFECT 16 20. FV 16
资源推荐
资源详情
资源评论
EXCEL2013 中文版
函数速查手册
E.F.LEE
E.F.LEE
—1—
目录
一、 财务函数（55 条） .......................................................................................................... 13
1. ACCRINT ........................................................................................................................... 13
2. ACCRINTM ........................................................................................................................ 13
3. AMORDEGRC .................................................................................................................... 13
4. AMORLINC ........................................................................................................................ 13
5. COUPDAYBS ...................................................................................................................... 14
6. COUPDAYS ........................................................................................................................ 14
7. COUPDAYSNC ................................................................................................................... 14
8. COUPNCD ......................................................................................................................... 14
9. COUPNUM ........................................................................................................................ 14
10. COUPPCD ........................................................................................................................ 15
11. CUMIPMT ....................................................................................................................... 15
12. CUMPRINC...................................................................................................................... 15
13. DB ................................................................................................................................... 15
14. DDB ................................................................................................................................ 15
15. DISC ................................................................................................................................ 15
16. DOLLARDE ...................................................................................................................... 16
17. DOLLARFR ....................................................................................................................... 16
18. DURATION ...................................................................................................................... 16
19. EFFECT ............................................................................................................................ 16
20. FV ................................................................................................................................... 16
21. FVSCHEDULE .................................................................................................................. 17
22. INTRATE .......................................................................................................................... 17
23. IPMT ............................................................................................................................... 17
24. IRR .................................................................................................................................. 17
25. ISPMT ............................................................................................................................. 18
26. MDURATION ................................................................................................................... 18
27. MIRR ............................................................................................................................... 18
28. NOMINAL ....................................................................................................................... 18
29. NPER ............................................................................................................................... 19
30. NPV ................................................................................................................................. 19
31. ODDFPRICE ..................................................................................................................... 19
32. ODDFYIELD ..................................................................................................................... 19
33. ODDLPRICE ..................................................................................................................... 20
34. ODDLYIELD ...................................................................................................................... 20
35. PDURATION .................................................................................................................... 21
36. PMT ................................................................................................................................ 21
37. PPMT .............................................................................................................................. 21
38. PRICE .............................................................................................................................. 21
39. PRICEDISC ....................................................................................................................... 22
40. PRICEMAT ....................................................................................................................... 22
41. PV ................................................................................................................................... 22
EXCEL2013 中文版
函数速查手册
—2—
42. RATE ............................................................................................................................... 23
43. RECEIVED ........................................................................................................................ 23
44. RRI .................................................................................................................................. 23
45. SLN ................................................................................................................................. 23
46. SYD ................................................................................................................................. 24
47. TBILLEQ .......................................................................................................................... 24
48. TBILLPRICE ...................................................................................................................... 24
49. TBILLYIELD ...................................................................................................................... 24
50. VDB ................................................................................................................................. 25
51. XIRR ................................................................................................................................ 25
52. XNPV ............................................................................................................................... 25
53. YIELD .............................................................................................................................. 26
54. YIELDDISC ....................................................................................................................... 26
55. YIELDMAT ....................................................................................................................... 26
二、 逻辑函数（9 条） ............................................................................................................ 28
1. AND .................................................................................................................................. 28
2. FALSE ................................................................................................................................ 28
3. IF ....................................................................................................................................... 28
4. IFERROR ............................................................................................................................ 28
5. IFNA .................................................................................................................................. 29
6. NOT .................................................................................................................................. 29
7. OR ..................................................................................................................................... 29
8. TRUE ................................................................................................................................. 29
9. XOR ................................................................................................................................... 30
三、 文本函数（37 条） .......................................................................................................... 31
1. ASC ................................................................................................................................... 31
2. CHAR ................................................................................................................................ 31
3. CLEAN ............................................................................................................................... 31
4. CODE ................................................................................................................................ 31
5. CONCATENATE .................................................................................................................. 31
6. DOLLAR ............................................................................................................................. 32
7. EXACT ............................................................................................................................... 32
8. FIND .................................................................................................................................. 32
9. FINDB................................................................................................................................ 32
10. FIXED .............................................................................................................................. 33
11. LEFT ................................................................................................................................ 33
12. LEFTB .............................................................................................................................. 33
13. LEN ................................................................................................................................. 33
14. LENB ............................................................................................................................... 33
15. LOWER ............................................................................................................................ 34
16. MID ................................................................................................................................. 34
17. MIDB .............................................................................................................................. 34
E.F.LEE
—3—
18. NUMBERVALUE .............................................................................................................. 34
19. PHONETIC ....................................................................................................................... 35
20. PROPER........................................................................................................................... 35
21. REPLACE ......................................................................................................................... 35
22. REPLACEB ....................................................................................................................... 36
23. REPT ............................................................................................................................... 36
24. RIGHT ............................................................................................................................. 36
25. RIGHTB ........................................................................................................................... 36
26. RMB ................................................................................................................................ 37
27. SEARCH ........................................................................................................................... 37
28. SEARCHB ......................................................................................................................... 37
29. SUBSTITUTE .................................................................................................................... 37
30. T ...................................................................................................................................... 38
31. TEXT ................................................................................................................................ 38
32. TRIM ............................................................................................................................... 42
33. UNICHAR ........................................................................................................................ 42
34. UNICODE ........................................................................................................................ 42
35. UPPER ............................................................................................................................. 42
36. VALUE ............................................................................................................................. 42
37. WIDECHAR ...................................................................................................................... 42
四、 日期和时间函数（24 条） .............................................................................................. 44
1. DATE ................................................................................................................................. 44
2. DATEVALUE ....................................................................................................................... 44
3. DAY ................................................................................................................................... 45
4. DAYS ................................................................................................................................. 45
5. DAYS360 ........................................................................................................................... 45
6. EDATE ............................................................................................................................... 46
7. EOMONTH ........................................................................................................................ 46
8. HOUR ................................................................................................................................ 46
9. ISOWEEKNUM .................................................................................................................. 46
10. MINUTE .......................................................................................................................... 47
11. MONTH .......................................................................................................................... 47
12. NETWORKDAYS ............................................................................................................... 47
13. NETWORKDAYS.INTL ...................................................................................................... 47
14. NOW ............................................................................................................................... 48
15. SECOND .......................................................................................................................... 49
16. TIME ............................................................................................................................... 49
17. TIMEVALUE ..................................................................................................................... 49
18. TODAY ............................................................................................................................. 49
19. WEEKDAY ........................................................................................................................ 49
20. WEEKNUM ..................................................................................................................... 50
21. WORKDAY ....................................................................................................................... 50
22. WORKDAY.INTL ............................................................................................................... 51
EXCEL2013 中文版
函数速查手册
—4—
23. YEAR ............................................................................................................................... 52
24. YEARFRAC ....................................................................................................................... 52
五、 查找和引用函数（19 条） .............................................................................................. 53
1. ADDRESS ........................................................................................................................... 53
2. AREAS ............................................................................................................................... 53
3. CHOOSE ............................................................................................................................ 53
4. COLUMN ........................................................................................................................... 53
5. COLUMNS ......................................................................................................................... 54
6. FORMULATEXT ................................................................................................................. 54
7. GETPIVOTDATA ................................................................................................................. 54
8. HLOOKUP .......................................................................................................................... 54
9. HYPERLINK ........................................................................................................................ 55
10. INDEX ............................................................................................................................. 55
11. INDIRECT ........................................................................................................................ 56
12. LOOKUP .......................................................................................................................... 56
13. MATCH ............................................................................................................................ 57
14. OFFSET ............................................................................................................................ 57
15. ROW ............................................................................................................................... 58
16. ROWS ............................................................................................................................. 58
17. RTD ................................................................................................................................. 58
18. TRANSPOSE .................................................................................................................... 58
19. VLOOKUP ........................................................................................................................ 59
六、 数学和三角函数（75 条） .............................................................................................. 60
1. ABS ................................................................................................................................... 60
2. ACOS ................................................................................................................................. 60
3. ACOSH .............................................................................................................................. 60
4. ACOT ................................................................................................................................. 60
5. ACOTH .............................................................................................................................. 60
6. AGGREGATE ...................................................................................................................... 60
7. ARABIC ............................................................................................................................. 62
8. ASIN .................................................................................................................................. 62
9. ASINH ............................................................................................................................... 62
10. ATAN ............................................................................................................................... 63
11. ATAN2 ............................................................................................................................. 63
12. ATANH............................................................................................................................. 63
13. BASE ............................................................................................................................... 63
14. CEILING.MATH ................................................................................................................ 63
15. CEILING.PRECISE ............................................................................................................. 64
16. COMBIN .......................................................................................................................... 64
17. COMBINA ....................................................................................................................... 64
18. COS ................................................................................................................................. 65
19. COSH .............................................................................................................................. 65
剩余141页未读，继续阅读
资源评论
wei_lin
- 粉丝: 36
- 资源: 22
上传资源 快速赚钱
我的内容管理
展开
- 我的资源
快来上传第一个资源
我的收益 登录查看自己的收益
我的积分
登录查看自己的积分
我的C币
登录后查看C币余额
我的收藏 
我的下载 
下载帮助
前往需求广场，查看用户热搜
安全验证
文档复制为VIP权益，开通VIP直接复制
信息提交成功