excel2003函数应用手册

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

1、目录一、函数应用基础.....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

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

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

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

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

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

7、INC...…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.ISPMT..……..1325.MDURATION..….1326.MIRR...……...1327.NOMIN

8、AL….1328.NPER...……...1329.NPV.……1330.ODDFPRICE…...1331.ODDFYIELD...….1432.O