《函数应用手册》word版

《《函数应用手册》word版》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

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.EOMONT

3、H......…....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

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

5、C....……...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.I

6、MLOG2……..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

7、.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…….121

8、9.FV......……....1220.FVSCHEDULE....…...1221.INTRATE....…….1322.IPMT.....…….1323.IRR…….1324.ISPMT..……..1325.MDURATION..….1326.MIRR...……...1327.NOMINAL….1328.NPER...……...1329.NPV.……1330.ODDFPRICE…...1331.ODDFYIELD...….1432.O