Excel函数应用完全手册.doc

Excel 函数应用完全手册目录一、函数应用基础.1(一) 函数和公式.11. 什么是函数.12. 什么是公式.1(二) 函数的参数.11. 常量.12. 逻辑值.13. 数组.14. 错误值.15. 单元格引用.16. 嵌套函数.27. 名称和标志.2(三) 函数输入方法.21. “插入函数”对话框.22. 编辑栏输入.3二、 函数速查一览.3(一) 数据库函数.31.DAVERAGE.32.DCOUNT.33.DCOUNTA.34.DGET.35.DMAX.36.DMIN.37.DPRODUCT.38.DSTDEV.39.DSTDEVP.410.DSUM.411.DVAR.412.DVARP.413.GETPIVOTDATA.4(二) 日期与时间函数.41.DATE.42.DATEVALUE.43.DAY.44.DAYS360.55.EDATE.56.EOMONTH.57.HOUR.58.MINUTE.59.MONTH.510.NETWORKDAYS.511.NOW.612.SECOND.613.TIME.614.TIMEVALUE.615.TODAY.616.WEEKDAY.617.WEEKNUM.618.WORKDAY.619.YEAR.720.YEARFRAC.7(三) 外部函数.71.EUROCONVERT.72.SQL.REQUEST.7(四) 工程函数.71.BESSELI.72.BESSELJ.83.BESSELK.84.BESSELY.85.BIN2DEC.86.BIN2HEX.87.BIN2OCT.88.COMPLEX.89.CONVERT.810.DEC2BIN.811.DEC2HEX.812.DEC2OCT.813.DELTA.814.ERF.815.ERFC.916.GESTEP.917.HEX2BIN.918.HEX2DEC.919.HEX2OCT.920.IMABS.921.IMAGINARY.922.IMARGUMENT.923.MCONJUGATE.924.IMCOS.925.IMDIV.926.IMEXP.927.IMLN.928.IMLOG10.1029.IMLOG2.1030.IMPOWER.1031.IMPRODUCT.1032.IMREAL.1033.IMSIN.1034.IMSQRT.1035.IMSUB.1036.IMSUM.1037.OCT2BIN.1038.OCT2DEC.1039.OCT2HEX.10(五) 财务函数.101.ACCRINT.102.ACCRINTM.113.AMORDEGRC.114.AMORLINC.115.COUPDAYBS.116.COUPDAYS.117.COUPDAYSNC.118.COUPNUM.119.COUPPCD.1110.CUMIPMT.1111.CUMPRINC.1212.DB.1213.DDB.1214.DISC.1215.DOLLARDE.1216.DOLLARFR.1217.DURATION.1218.EFFECT.1219.FV.1220.FVSCHEDULE.1221.INTRATE.1322.IPMT