excel2003函数应用完全手册

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

1、Excel2003函数应用完全手册目录一、函数应用基础1.函数和公式(1)什么是函数(2)什么是公式2.函数的参数(1)常量(2)逻辑值(3)数组(4)错误值(5)单元格引用(6)嵌套函数3.函数输入方法(1)“插入函数”对话框(2)编辑栏输入二、函数速查一览(一)数据库函数1.DAVERAGE2.DCOUNT3.DCOUNTA4.DGET5.DMAX6.DMIN7.DPRODUCT8.DSTDEV9.DSTDEVP10.DSUM11.DVAR12.DVARP13.GETPIVOTDATA(二)日期与时

2、间函数1.DATE2.DATEVALUE3.DAY4.DAYS3605.EDATE6.EOMONTH7.HOUR8.MINUTE9.MONTH10.NETWORKDAYS11.NOW12.SECOND13.TIME14.TIMEVALUE15.TODAY16.WEEKDAY17.WEEKNUM18.WORKDAY19.YEAR20.YEARFRAC(三)外部函数1.EUROCONVERT2.SQL.REQUEST(四)工程函数1.BESSELI2.BESSELJ3.BESSELK4.BESSELY5.B

3、IN2DEC6.BIN2HEX7.BIN2OCT8.COMPLEX9.CONVERT10.DEC2BIN11.DEC2HEX12.DEC2OCT13.DELTA14.ERF15.ERFC16.GESTEP17.HEX2BIN18.HEX2DEC19.HEX2OCT20.IMABS21.IMAGINARY22.IMARGUMENT23.MCONJUGATE24.IMCOS25.IMDIV26.IMEXP27.IMLN28.IMLOG1029.IMLOG230.IMPOWER31.IMPRODUCT32.I

4、MREAL33.IMSIN34.IMSQRT35.IMSUB36.IMSUM37.OCT2BIN38.OCT2DEC39.OCT2HEX(五)财务函数1.ACCRINT2.ACCRINTM3.AMORDEGRC4.AMORLINC5.COUPDAYBS6.COUPDAYS7.COUPDAYSNC8.COUPNUM9.COUPPCD10.CUMIPMT11.CUMPRINC12.DB13.DDB14.DISC15.DOLLARDE16.DOLLARFR17.DURATION18.EFFECT19.FV20

5、.FVSCHEDULE21.INTRATE22.IPMT23.IRR24.ISPMT25.MDURATION26.MIRR27.NOMINAL28.NPER29.NPV30.ODDFPRICE31.ODDFYIELD32.ODDLPRICE33.ODDLYIELD34.PMT35.PPMT36.PRICE37.PRICEDISC38.PRICEMAT39.PV40.RATE41.RECEIVED42.SLN43.SYD44.TBILLEQ45.TBILLPRICE46.TBILLYIELD47.VDB4

6、8.XIRR49.XNPV50.YIELD51.YIELDDISC52.YIELDMAT(六)信息函数1.CELL2.ERROR.TYPE3.INFO4.IS类函数5.ISEVEN6.ISODD7.N8.NA9.TYPE(七)逻辑运算符1.AND2.FALSE3.IF4.NOT5.OR6.TRUE(八)查找和引用函数1.ADDRESS2.AREAS3.CHOOSE4.COLUMN5.COLUMNS6.HLOOKUP7.HYPERLINK8.INDEX9.INDIRECT10.LOOKUP11.MATCH

7、12.OFFSET13.ROW14.ROWS15.RTD16.TRANSPOSE17.VLOOKUP(九)数学和三角函数1.ABS2.ACOS3.ACOSH4.ASIN5.ASINH6.ATAN7.ATAN28.ATANH9.CEILING10.COMBIN11.COS12.COSH13.COUNTIF14.DEGREES15.EVEN16.EXP17.FACT18.FACTDOUBLE19.FLOOR20.GCD21.INT22.LCM23.LN24.LOG25.LOG1026.MDETERM27.M

8、INVERSE28.MMULT29.MOD30.MROUND31.MULTINOMIAL32.ODD33.PI34.POWER35.PRODUCT36.QUOTIENT37.RADIANS38.RAND39.RANDBETWEEN40.ROMAN41.ROUND42.ROUNDDOWN43.ROUNDUP44.SERIESSUM45.SIGN46.SIN47.SINH48.SQRT49.SQRTPIπ50.SUBTOTAL51.SUM52.