excel2003函数应用完全手册

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

1、Excel2003函数应用完全手册53目录一、函数应用基础1（一）函数和公式11什么是函数12、什么是公式1（二）.函数的参数11、常量12、逻辑值13、数组14、错误值15、单元格引用16、嵌套函数27、名称和标志2（三）函数输入方法21、“插入函数”对话框22、编辑栏输入3二、函数速查一览3(一)数据库函数31.DAVERAGE32.DCOUNT33.DCOUNTA34.DGET35.DMAX36.DMIN37.DPRODUCT48.DSTDEV49.DSTDEVP410.DSUM411.DVAR412.DVARP413.GETPIVO

2、TDATA4(二)日期与时间函数41.DATE42.DATEVALUE43.DAY54.DAYS36055.EDATE56.EOMONTH57.HOUR58.MINUTE69.MONTH610.NETWORKDAYS611.NOW612.SECOND613.TIME614.TIMEVALUE615.TODAY75316.WEEKDAY717.WEEKNUM718.WORKDAY719.YEAR720.YEARFRAC7(三)外部函数81.EUROCONVERT82.SQL.REQUEST8(四)工程函数81.BESSELI82.BESSEL

3、J83.BESSELK84.BESSELY85.BIN2DEC96.BIN2HEX97.BIN2OCT98.COMPLEX99.CONVERT910.DEC2BIN911.DEC2HEX912.DEC2OCT913.DELTA914.ERF915.ERFC1016.GESTEP1017.HEX2BIN1018.HEX2DEC1019.HEX2OCT1020.IMABS1021.IMAGINARY1022.IMARGUMENT1023.MCONJUGATE1024.IMCOS1025.IMDIV1026.IMEXP1127.IMLN1128.

4、IMLOG101129.IMLOG21130.IMPOWER1131.IMPRODUCT1132.IMREAL1133.IMSIN1134.IMSQRT1135.IMSUB1135、IMSUM1136.OCT2BIN1137.OCT2DEC125338.OCT2HEX12(五)财务函数121.ACCRINT122.ACCRINTM123.AMORDEGRC124.AMORLINC125.COUPDAYBS126.COUPDAYS127.COUPDAYSNC138.COUPNUM139.COUPPCD1310.CUMIPMT1311.CUMP

5、RINC1312.DB1313.DDB1314.DISC1315.DOLLARDE1416.DOLLARFR1417.DURATION1418.EFFECT1419.FV1420.FVSCHEDULE1421.INTRATE1422.IPMT1423.IRR1424.ISPMT1525.MDURATION1526.MIRR1527.NOMINAL1528.NPER1529.NPV1530.ODDFPRICE1531.ODDFYIELD1532.ODDLPRICE1633.ODDLYIELD1634.PMT1635.PPMT1636.PRIC

6、E1637.PRICEDISC1638.PRICEMAT1639.PV16(六)信息函数171.CELL172.ERROR.TYPE173.INFO174.IS类函数175.ISEVEN18536.ISODD18语法：ISODD(number)187.N188.NA189.TYPE18(七)逻辑运算符181.AND182.FALSE183.IF194.NOT195.OR196.TRUE19(八)查找和引用函数191.ADDRESS192.AREAS203.CHOOSE204.COLUMN205.COLUMNS206.HLOOKUP207.H

7、YPERLINK208.INDEX219.INDIRECT2110.LOOKUP2111.MATCH2112.OFFSET2213.ROW2214.ROWS2215.RTD2216.TRANSPOSE2217.VLOOKUP22(九)数学和三角函数231.ABS232.ACOS233.ACOSH234.ASIN235.ASINH236.ATAN237.ATAN2238.ATANH239.CEILING2410.COMBIN2411.COS2412.COSH2413.COUNTIF2414.DEGREES2415.EVEN2416.EXP25

8、5317.FACT2518.FACTDOUBLE2519.FLOOR2520.GCD2521.INT2522.LCM2523.LN2524.LOG2625.LOG102626.M