excel函数详解(提高篇)

《excel函数详解(提高篇)》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、实用文案目录一、函数应用基础....1（一）函数和公式.......11.什么是函数.............12.什么是公式........1（二）函数的参数11.常量....12.逻辑值....13.数组......14.错误值....15.单元格引用....16.嵌套函数.....27.名称和标志2（三）函数输入方法.........21.“插入函数”对话框...........22.编辑栏输入...3二、函数速查一览...........3(一)数据库函数..31.DAVERAGE.......32.DCOUNT...........33.DCOUNTA.......

2、..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....

3、.......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(四)工程函数.......

4、.....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..

5、.......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.....10标准文档实用文案31.IMPRODUCT.1032.IMRE

6、AL.......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

7、.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...........1323.IRR.............13