欢迎来到天天文库
浏览记录
ID:2077134
大小:479.00 KB
页数:62页
时间:2017-11-14
《excel 2003常用函数完全手册》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、Excel2003函数应用完全手册二〇〇四年二月二日目录62一、函数应用基础.....1(一)函数和公式...11.什么是函数…...12.什么是公式…...1(二)函数的参数....11.常量…....12.逻辑值…13.数组…..14.错误值....…..15.单元格引用.…...16.嵌套函数...….....27.名称和标志..…....2(三)函数输入方法.21.“插入函数”对话框.…..22.编辑栏输入...…..3二、函数速查一览3(一)数据库函数...31.DAVERAGE.32.DCOUNT.…...33.DCOUNTA.....…...34.DGET
2、………...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
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.……...84.BESSELY..…
4、….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.IMA
5、GINARY….....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.
6、…..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…
7、…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.NOMINAL….1328.NPER...……...1329.NPV.……136230.ODDFPRICE…
此文档下载收益归作者所有