欢迎来到天天文库
浏览记录
ID:51688498
大小:350.00 KB
页数:85页
时间:2020-03-15
《excel函数详解(提高篇).doc》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
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.MI
3、NUTE...........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.....
5、........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.I
6、MPRODUCT.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.COUPDAYS
7、NC.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...........1323.IRR.............1324.ISPM
8、T....
此文档下载收益归作者所有