实例介绍
【实例简介】excel2013函数速查
【实例截图】Excel2013函数速查手册(050612).pdf
【核心代码】
目 录 一、数学和三角函数（75 条）.............................................................................................11 1. ABS ................................................................................................................................11 2. ACOS..............................................................................................................................11 3. ACOSH ...........................................................................................................................11 4. ACOT..............................................................................................................................11 5. ACOTH ...........................................................................................................................11 6. ARABIC ..........................................................................................................................12 7. ASIN...............................................................................................................................12 8. ASINH ............................................................................................................................12 9. ATAN..............................................................................................................................12 10. ATAN2..........................................................................................................................12 11. ATANH..........................................................................................................................13 12. BASE ............................................................................................................................13 13. CEILING........................................................................................................................13 14. CEILING.MATH.............................................................................................................13 15. COMBIN.......................................................................................................................14 16. COMBINA ....................................................................................................................14 17. COS..............................................................................................................................14 18. COSH ...........................................................................................................................14 19. COT..............................................................................................................................15 20. COTH ...........................................................................................................................15 21. CSC ..............................................................................................................................15 22. CSCH............................................................................................................................15 23. DECIMAL......................................................................................................................15 24. DEGREES......................................................................................................................16 25. EVEN............................................................................................................................16 26. EXP ..............................................................................................................................16 27. FACT.............................................................................................................................16 28. FACTDOUBLE ...............................................................................................................16 29. FLOOR..........................................................................................................................17 30. FLOOR.MATH...............................................................................................................17 31. GCD .............................................................................................................................17 32. INT...............................................................................................................................17 33. LCM .............................................................................................................................18 34. LN ................................................................................................................................18 35. LOG..............................................................................................................................18 36. LOG10..........................................................................................................................18 37. MDETERM ...................................................................................................................18 38. MINVERSE ...................................................................................................................19 39. MMULT........................................................................................................................19 40. MOD............................................................................................................................19 EXCEL2013 Excel2013 函数速查手册 —2— 41. MROUND.....................................................................................................................19 42. MULTINOMIAL.............................................................................................................19 43. MUNIT.........................................................................................................................20 44. ODD.............................................................................................................................20 45. PI .................................................................................................................................20 46. POWER ........................................................................................................................20 47. PRODUCT.....................................................................................................................20 48. QUOTIENT ...................................................................................................................21 49. RADIANS......................................................................................................................21 50. RAND...........................................................................................................................21 51. RANDBETWEEN...........................................................................................................21 52. ROMAN .......................................................................................................................22 53. ROUND........................................................................................................................22 54. ROUNDDOWN.............................................................................................................22 55. ROUNDUP....................................................................................................................22 56. SEC...............................................................................................................................23 57. SECH............................................................................................................................23 58. SERIESSUM..................................................................................................................23 59. SIGN.............................................................................................................................23 60. SIN...............................................................................................................................23 61. SINH.............................................................................................................................24 62. SQRT............................................................................................................................24 63. SQRTPI.........................................................................................................................24 64. SUBTOTAL ....................................................................................................................24 65. SUM.............................................................................................................................24 66. SUMIF..........................................................................................................................25 67. SUMIFS ........................................................................................................................25 68. SUMPRODUCT.............................................................................................................25 69. SUMSQ........................................................................................................................26 70. SUMX2MY2 .................................................................................................................26 71. SUMX2PY2...................................................................................................................26 72. SUMXMY2 ...................................................................................................................26 73. TAN..............................................................................................................................26 74. TANH............................................................................................................................26 75. TRUNC .........................................................................................................................27 二、统计函数（89 条）.........................................................................................................28 1. AVEDEV..........................................................................................................................28 2. AVERAGE .......................................................................................................................28 3. AVERAGEA.....................................................................................................................28 4. AVERAGEIF ....................................................................................................................28 5. AVERAGEIFS...................................................................................................................29 6. BETADIST .......................................................................................................................29 7. BETAINV.........................................................................................................................29 E.F. LEE —3— 8. BINOMDIST....................................................................................................................30 9. BINOM.DIST.RANGE ......................................................................................................30 10. CHIDIST........................................................................................................................30 11. CHIINV.........................................................................................................................31 12. CHITEST .......................................................................................................................31 13. CONFIDENCE ...............................................................................................................31 14. CORREL........................................................................................................................31 15. COUNT.........................................................................................................................32 16. COUNTA.......................................................................................................................32 17. COUNTBLANK..............................................................................................................32 18. COUNTIF......................................................................................................................32 19. COUNTIFS ....................................................................................................................32 20. COVAR .........................................................................................................................33 21. CRITBINOM..................................................................................................................33 22. DEVSQ .........................................................................................................................33 23. EXPONDIST ..................................................................................................................33 24. FDIST ...........................................................................................................................34 25. FINV.............................................................................................................................34 26. FISHER .........................................................................................................................34 27. FISHERINV ...................................................................................................................34 28. FORECAST....................................................................................................................35 29. FREQUENCY.................................................................................................................35 30. FTEST ...........................................................................................................................35 31. GAMMA.......................................................................................................................35 32. GAMMADIST ...............................................................................................................35 33. GAMMAINV.................................................................................................................36 34. GAMMALN ..................................................................................................................36 35. GAUSS..........................................................................................................................36 36. GEOMEAN ...................................................................................................................36 37. GROWTH .....................................................................................................................37 38. HARMEAN ...................................................................................................................37 39. HYPGEOMDIST ............................................................................................................37 40. INTERCEPT...................................................................................................................37 41. KURT............................................................................................................................38 42. LARGE..........................................................................................................................38 43. LINEST..........................................................................................................................38 44. LOGEST ........................................................................................................................38 45. LOGINV........................................................................................................................39 46. LOGNORMDIST............................................................................................................39 47. MAX.............................................................................................................................39 48. MAXA ..........................................................................................................................39 49. MEDIAN.......................................................................................................................40 50. MIN..............................................................................................................................40 51. MINA ...........................................................................................................................40 EXCEL2013 Excel2013 函数速查手册 —4— 52. MODE ..........................................................................................................................40 53. NEGBINOMDIST...........................................................................................................40 54. NORMDIST...................................................................................................................41 55. NORMSINV..................................................................................................................41 56. NORMSDIST.................................................................................................................41 57. NORMSINV..................................................................................................................41 58. PEARSON.....................................................................................................................41 59. PERCENTILE .................................................................................................................42 60. PERCENTRANK.............................................................................................................42 61. PERMUT ......................................................................................................................42 62. PERMUTATIONA ..........................................................................................................42 63. PHI...............................................................................................................................43 64. POISSON......................................................................................................................43 65. PROB............................................................................................................................43 66. QUARTILE ....................................................................................................................43 67. RANK ...........................................................................................................................43 68. RSQ..............................................................................................................................44 69. SKEW...........................................................................................................................44 70. SKEW.P ........................................................................................................................44 71. SLOPE ..........................................................................................................................45 72. SMALL..........................................................................................................................45 73. STANDARDIZE ..............................................................................................................45 74. STDEV..........................................................................................................................45 75. STDEVA........................................................................................................................45 76. STDEVP........................................................................................................................46 77. STDEVPA......................................................................................................................46 78. STEYX...........................................................................................................................46 79. TDIST ...........................................................................................................................47 80. TINV.............................................................................................................................47 81. TREND .........................................................................................................................47 82. TRIMMEAN..................................................................................................................47 83. TTEST...........................................................................................................................48 84. VAR..............................................................................................................................48 85. VARA............................................................................................................................48 86. VARP............................................................................................................................48 87. VARPA..........................................................................................................................48 88. WEIBULL......................................................................................................................49 89. ZTEST ...........................................................................................................................49 三、文本和数据函数（31 条）.............................................................................................50 1. ASC ................................................................................................................................50 2. CHAR .............................................................................................................................50 3. CLEAN............................................................................................................................50 4. CODE .............................................................................................................................50 E.F. LEE —5— 5. CONCATENATE...............................................................................................................50 6. DOLLAR 或 RMB............................................................................................................51 7. EXACT ............................................................................................................................51 8. FIND...............................................................................................................................51 9. FINDB.............................................................................................................................51 10. FIXED ...........................................................................................................................52 11. JIS ................................................................................................................................52 12. LEFT 或 LEFTB..............................................................................................................52 13. LEN 或 LENB................................................................................................................52 14. LOWER.........................................................................................................................53 15. MID 或 MIDB...............................................................................................................53 16. NUMBERVALUE ...........................................................................................................53 17. PHONETIC....................................................................................................................53 18. PROPER........................................................................................................................54 19. REPLACE 或 REPLACEB................................................................................................54 20. REPT ............................................................................................................................54 21. RIGHT 或 RIGHTB ........................................................................................................54 22. SEARCH 或 SEARCHB...................................................................................................55 23. SUBSTITUTE.................................................................................................................55 24. T...................................................................................................................................55 25. TEXT.............................................................................................................................55 26. TRIM............................................................................................................................56 27. UPPER..........................................................................................................................56 28. UNICHAR .....................................................................................................................56 29. UNICODE .....................................................................................................................56 30. VALUE..........................................................................................................................56 31. WIDECHAR...................................................................................................................57 四、逻辑运算符（9 条） .......................................................................................................58 1. AND ...............................................................................................................................58 2. FALSE .............................................................................................................................58 3. IF....................................................................................................................................58 4. IFERROR.........................................................................................................................58 5. IFNA...............................................................................................................................59 6. NOT ...............................................................................................................................59 7. OR..................................................................................................................................59 8. TRUE..............................................................................................................................59 9. XOR................................................................................................................................60 五、查找和引用函数（18 条）.............................................................................................61 1. ADDRESS........................................................................................................................61 2. AREAS............................................................................................................................61 3. CHOOSE.........................................................................................................................61 4. COLUMN........................................................................................................................61 EXCEL2013 Excel2013 函数速查手册 —6— 5. COLUMNS......................................................................................................................62 6. FORMULATEXT ..............................................................................................................62 7. HLOOKUP.......................................................................................................................62 8. HYPERLINK.....................................................................................................................62 9. INDEX ............................................................................................................................63 10. INDIRECT .....................................................................................................................63 11. LOOKUP.......................................................................................................................63 12. MATCH.........................................................................................................................64 13. OFFSET.........................................................................................................................64 14. ROW ............................................................................................................................65 15. ROWS ..........................................................................................................................65 16. RTD..............................................................................................................................65 17. TRANSPOSE .................................................................................................................65 18. VLOOKUP.....................................................................................................................66 六、数据库函数（13 条）.....................................................................................................67 1. DAVERAGE.....................................................................................................................67 2. DCOUNT ........................................................................................................................67 3. DCOUNTA ......................................................................................................................67 4. DGET..............................................................................................................................67 5. DMAX ............................................................................................................................67 6. DMIN.............................................................................................................................67 7. DPRODUCT ....................................................................................................................68 8. DSTDEV..........................................................................................................................68 9. DSTDEVP........................................................................................................................68 10. DSUM ..........................................................................................................................68 11. DVAR............................................................................................................................68 12. DVARP..........................................................................................................................68 13. GETPIVOTDATA............................................................................................................69 七、日期时间类函数（22 条）.............................................................................................70 1. DATE ..............................................................................................................................70 2. DATEVaLUE ....................................................................................................................70 3. DAY ................................................................................................................................70 4. DAYS ..............................................................................................................................71 5. DAYS360 ........................................................................................................................71 6. EDATE ............................................................................................................................71 7. EOMONTH.....................................................................................................................71 8. HOUR.............................................................................................................................72 9. ISOWEEKNUM...............................................................................................................72 10. MINUTE .......................................................................................................................72 11. MONTH .......................................................................................................................72 12. NETWORKDAYS............................................................................................................73 13. NOW............................................................................................................................73 E.F. LEE —7— 14. SECOND.......................................................................................................................73 15. TIME ............................................................................................................................73 16. TIMEVaLUE ..................................................................................................................74 17. TODAY..........................................................................................................................74 18. WEEKDAY.....................................................................................................................74 19. WEEKNUM ..................................................................................................................74 20. WORKDAY....................................................................................................................75 21. YEAR ............................................................................................................................75 22. YEARFRAC....................................................................................................................76 八、外部函数（2 条）...........................................................................................................77 1. EUROCONVERT..............................................................................................................77 2. SQL.REQUEST ................................................................................................................77 九、工程函数（52 条）.........................................................................................................78 1. BESSELI ..........................................................................................................................78 2. BESSELJ..........................................................................................................................78 3. BESSELK .........................................................................................................................78 4. BESSELY..........................................................................................................................78 5. BIN2DEC ........................................................................................................................78 6. BIN2HEX ........................................................................................................................78 7. BIN2OCT ........................................................................................................................79 8. BITAND ..........................................................................................................................79 9. BITLSHIFT.......................................................................................................................79 10. BITOR...........................................................................................................................79 11. BITRSHIFT ....................................................................................................................80 12. BITXOR.........................................................................................................................80 13. COMPLEX.....................................................................................................................80 14. CONVERT.....................................................................................................................80 15. DEC2BIN ......................................................................................................................80 16. DEC2HEX......................................................................................................................81 17. DEC2OCT .....................................................................................................................81 18. DELTA...........................................................................................................................81 19. ERF...............................................................................................................................81 20. ERFC ............................................................................................................................81 21. GESTEP ........................................................................................................................81 22. HEX2BIN ......................................................................................................................82 23. HEX2DEC......................................................................................................................82 24. HEX2OCT .....................................................................................................................82 25. IMABS..........................................................................................................................82 26. IMAGINARY .................................................................................................................82 27. IMARGUMENT.............................................................................................................82 28. IMCOSH.......................................................................................................................82 29. IMCOT..........................................................................................................................83 EXCEL2013 Excel2013 函数速查手册 —8— 30. IMCSC..........................................................................................................................83 31. IMCSCH........................................................................................................................83 32. IMSEC ..........................................................................................................................83 33. IMSECH........................................................................................................................83 34. IMSINH ........................................................................................................................84 35. IMTAN..........................................................................................................................84 36. MCONJUGATE..............................................................................................................84 37. IMCOS..........................................................................................................................84 38. IMDIV ..........................................................................................................................84 39. IMEXP..........................................................................................................................84 40. IMLN............................................................................................................................84 41. IMLOG10 .....................................................................................................................85 42. IMLOG2 .......................................................................................................................85 43. IMPOWER....................................................................................................................85 44. IMPRODUCT ................................................................................................................85 45. IMREAL ........................................................................................................................85 46. IMSIN...........................................................................................................................85 47. IMSQRT........................................................................................................................85 48. IMSUB..........................................................................................................................86 49. IMSUM ........................................................................................................................86 50. OCT2BIN......................................................................................................................86 51. OCT2DEC .....................................................................................................................86 52. OCT2HEX .....................................................................................................................86 十、财务函数（54 条）.........................................................................................................87 1. ACCRINT ........................................................................................................................87 2. ACCRINTM.....................................................................................................................87 3. AMORDEGRC.................................................................................................................87 4. AMORLINC.....................................................................................................................87 5. COUPDAYBS...................................................................................................................88 6. COUPDAYS .....................................................................................................................88 7. COUPDAYSNC ................................................................................................................88 8. COUPNUM.....................................................................................................................88 9. COUPPCD.......................................................................................................................88 10. CUMIPMT....................................................................................................................89 11. CUMPRINC...................................................................................................................89 12. DB................................................................................................................................89 13. DDB .............................................................................................................................89 14. DISC .............................................................................................................................89 15. DOLLARDE ...................................................................................................................90 16. DOLLARFR....................................................................................................................90 17. DURATION ...................................................................................................................90 18. EFFECT.........................................................................................................................90 19. FV ................................................................................................................................90 E.F. LEE —9— 20. FVSCHEDULE ...............................................................................................................91 21. INTRATE.......................................................................................................................91 22. IPMT ............................................................................................................................91 23. IRR ...............................................................................................................................91 24. ISPMT ..........................................................................................................................91 25. MDURATION................................................................................................................91 26. MIRR............................................................................................................................92 27. NOMINAL ....................................................................................................................92 28. NPER............................................................................................................................92 29. NPV..............................................................................................................................92 30. ODDFPRICE..................................................................................................................92 31. ODDFYIELD..................................................................................................................93 32. ODDLPRICE..................................................................................................................93 33. ODDLYIELD...................................................................................................................93 34. PDURATION.................................................................................................................94 35. PMT .............................................................................................................................94 36. PPMT ...........................................................................................................................94 37. PRICE ...........................................................................................................................94 38. PRICEDISC....................................................................................................................94 39. PRICEMAT....................................................................................................................95 40. PV ................................................................................................................................95 41. RATE ............................................................................................................................95 42. RECEIVED.....................................................................................................................95 43. RRI ...............................................................................................................................95 44. SLN ..............................................................................................................................96 45. SYD ..............................................................................................................................96 46. TBILLEQ .......................................................................................................................96 47. TBILLPRICE...................................................................................................................96 48. TBILLYIELD ...................................................................................................................96 49. VDB..............................................................................................................................97 50. XIRR .............................................................................................................................97 51. XNPV............................................................................................................................97 52. YIELD ...........................................................................................................................97 53. YIELDDISC ....................................................................................................................97 54. YIELDMAT ....................................................................................................................98 十一、信息函数（10 条）.....................................................................................................99 1. CELL ...............................................................................................................................99 2. ERROR.TYPE...................................................................................................................99 3. INFO...............................................................................................................................99 4. IS 类函数.....................................................................................................................100 5. ISEVEN.........................................................................................................................100 6. ISFORMULA .................................................................................................................100 7. ISODD..........................................................................................................................101 EXCEL2013 Excel2013 函数速查手册 —10— 8. N..................................................................................................................................101 9. NA................................................................................................................................101 10. SHEET ........................................................................................................................101 11. SHEETS.......................................................................................................................101 12. TYPE...........................................................................................................................102 十二、WEB 函数（3 条） ...................................................................................................103 1. ENCODEURL.................................................................................................................103 2. FILTERXML ...................................................................................................................103 3. WEBSERVICE................................................................................................................103 Excel2013 函数索引（380 条）.........................................................................................104
好例子网口号：伸出你的我的手 — 分享！
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论