Excel2003函数手册(已排版)

《Excel2003函数手册(已排版)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Excel2003函数应用完全手册转自网络二〇一一年一月整理64目录（在页码上按住Ctrl并单击鼠标可以跟踪链接）一、函数应用基础1（一）函数和公式11.什么是函数12.什么是公式1（二）函数的参数11.常量12.逻辑值13.数组14.错误值25.单元格引用26.嵌套函数27.名称和标志2（三）函数输入方法31.“插入函数”对话框32.编辑栏输入3二、函数速查一览3(一)数据库函数31.DAVERAGE32.DCOUNT43.DCOUNTA44.DGET45.DMAX46.DMIN47.DPRODUCT48.DSTDEV49.DSTDEVP410.DSUM411

2、.DVAR512.DVARP513.GETPIVOTDATA5(二)日期与时间函数51.DATE52.DATEVALUE53.DAY54.DAYS36065.EDATE66.EOMONTH67.HOUR68.MINUTE79.MONTH710.NETWORKDAYS711.NOW76412.SECOND713.TIME714.TIMEVALUE815.TODAY816.WEEKDAY817.WEEKNUM818.WORKDAY819.YEAR820.YEARFRAC9(三)外部函数91.EUROCONVERT92.SQL.REQUEST9(四)工程函数101.B

3、ESSELI102.BESSELJ103.BESSELK104.BESSELY105.BIN2DEC106.BIN2HEX107.BIN2OCT108.COMPLEX109.CONVERT1010.DEC2BIN1111.DEC2HEX1112.DEC2OCT1113.DELTA1114.ERF1115.ERFC1116.GESTEP1117.HEX2BIN1118.HEX2DEC1119.HEX2OCT1220.IMABS1221.IMAGINARY1222.IMARGUMENT1223.MCONJUGATE1224.IMCOS1225.IMDIV1226.I

4、MEXP1227.IMLN1228.IMLOG101229.IMLOG21230.IMPOWER1331.IMPRODUCT1332.IMREAL136433.IMSIN1334.IMSQRT1335.IMSUB1336.IMSUM1337.OCT2BIN1338.OCT2DEC1339.OCT2HEX13(五)财务函数131.ACCRINT132.ACCRINTM143.AMORDEGRC144.AMORLINC145.COUPDAYBS146.COUPDAYS147.COUPDAYSNC148.COUPNUM159.COUPPCD1510.CUMIPMT15

5、11.CUMPRINC1512.DB1513.DDB1514.DISC1515.DOLLARDE1516.DOLLARFR1617.DURATION1618.EFFECT1619.FV1620.FVSCHEDULE1621.INTRATE1622.IPMT1623.IRR1624.ISPMT1725.MDURATION1726.MIRR1727.NOMINAL1728.NPER1729.NPV1730.ODDFPRICE1731.ODDFYIELD1832.ODDLPRICE1833.ODDLYIELD1834.PMT1835.PPMT1836.PRICE183

6、7.PRICEDISC196438.PRICEMAT1939.PV1940.RATE1941.RECEIVED1942.SLN1943.SYD1944.TBILLEQ2045.TBILLPRICE2046.TBILLYIELD2047.VDB2048.XIRR2049.XNPV2050.YIELD2051.YIELDDISC2052.YIELDMAT21(六)信息函数211.CELL212.ERROR.TYPE213.INFO214.IS类函数215.ISEVEN226.ISODD227.N228.NA229.TYPE23(七)逻辑运算符231.AND232.F

7、ALSE233.IF234.NOT235.OR246.TRUE24(八)查找和引用函数241.ADDRESS242.AREAS243.CHOOSE244.COLUMN255.COLUMNS256.HLOOKUP257.HYPERLINK258.INDEX259.INDIRECT2610.LOOKUP2611.MATCH2612.OFFSET276413.ROW2714.ROWS2715.RTD2716.TRANSPOSE2717.VLOOKUP28(九)数学和三角函数281.ABS282.ACOS283.ACOSH284.ASIN285.ASINH286.ATA

8、N297.ATAN229