函数应用完全手册.doc

1Excel 2003函数应用完全手册张迎新 著二四年二月二日一、函数应用基. 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. 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.MONTH. 510.NETWORKDAYS . . . . . . 5311.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. 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.IMAGINARY . 922.IMARGUMENT . . . . . . 923.MCONJUGATE . . . . . . 924.IMCOS. 925.IMDIV. 926.IMEXP. 927.IMLN. 928.IMLOG10. 1029.IMLOG2. 1030.IMPOWER. 1031.IMPRODUCT . . . 1032.IMREAL. 10433.IMSIN. 1034.IMSQRT. 1035.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.CUMPRINC . 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.NOMINAL. 1328.NPER. 1329.NPV. 1330.ODDFPRICE . . . . . . . . 1331.ODDFYIELD . . . 1432.ODDLPRICE . . . 1433.ODDLYIELD . . . 1434.PMT. . . 1435.PPMT. . 1436.PRICE. . 1437.PRICEDISC . . . . . 1438.PRICEMAT . . 15539.PV. . 1540.RATE. 1541.RECEIVED . . 1542.SLN. . 1543.SYD. . 1544.TBILLEQ. . 1545.TBILLPRICE . . . . . 1546.TBILLYIELD . . . . . 1547.VDB. . . . . . . 1548.XIRR. . . . . 1649.XNPV. . . . . 1650.YIELD. . . . 1651.YIELDDISC . . . . . . 1652.YIELDMAT . . . . 16(六)信息函数. 161.CELL. . . . . 162.ERROR.TYPE . . . . . . 163.INFO. . 164.IS 类函数. . 175.ISEVEN. . . . 176.ISODD. . 177.N. . 178.NA. . 179.TYPE. . . . 18(七)逻辑运算符. 181.AND. 182.FALSE. . . 183.IF. 184.NOT. 185.OR. 186.TRUE. 18(八)查找和引用函数. . . . . . . 191.ADDRESS. 192.AREAS. 193.CHOOSE. 194.COLUMN. 195.COLUMNS. 196.HLOOKUP. 197.HYPERLINK . 198.INDEX. . 209.INDIRECT. 2010.LOOKUP. 2011.MATCH. 2012.OFFSET. 2113.ROW. 2114.ROWS. 21615.RTD. 2116.TRANSPOSE . . . . . . . 2117.VLOOKUP. 21(九)数学和三角函数. . . . . . 211.ABS. 212.ACOS. 213.ACOSH. 224.ASIN. 225.ASINH. 226.ATAN. 227.ATAN2. 228.ATANH. 229.CEILING. 2210.COMBIN. 2211.COS. 2212.COSH. 2313.COUNTIF. 2314.DEGREES. 2315.EVEN. 2316.EXP. 2317.FACT. 2318.FACTDOUBLE . . . . . . . .2319.FLOOR. 2320.GCD. 2321.INT. 2322.LCM. 2423.LN. 2424.LOG. 2425.LOG10. 2426.MDETERM. 2427.MINVERSE . 2428.MMULT. 2429.MOD. 2430.MROUND. 2431.MULTINOMIAL . 2532.ODD. 2533.PI. . 2534.POWER. 2535.PRODUCT. 2536.QUOTIENT . 2537.RADIANS. 2538.RAND. 2539.RANDBETWEEN . 2540.ROMAN. 2641.ROUND. 2642.ROUNDDOWN . . . . . . . . 26743.ROUNDUP. 2644.SERIESSUM . . . . . . . . 2645.SIGN. 2646.SIN. 2647.SINH. 2648.SQRT. 2649.SQRTPI. 2750.SUBTOTAL . 2751.SUM. 2752.SUMIF. 2753.SUMPRODUCT . . . . . . . . 2754.SUMSQ. 2755.SUMX2MY2 . 2756.SUMX2PY2 . 2757.SUMXMY2. 2858.TAN. 2860.TRUNC. 28(十)统计函数. 281.AVEDEV. 282.AVERAGE. 283.AVERAGEA. 284.BETADIST. 285.BETAINV. 286.BINOMDIST . 297.CHIDIST. 298.CHIINV. 299.CHITEST. 2910.CONFIDENCE . . . . . . . . 2911.CORREL. 2912.COUNT. 2913.COUNTA. 3014.COUNTBLANK . . . . . . . . 3015.COUNTIF. 3016.COVAR. 3017.CRITBINOM . . . . . . . 3018.DEVSQ. . 3019.EXPONDIST . . . . . . . . 3020.FDIST. 3021.FINV. 3022.FISHER. 3123.FISHERINV . . . . . . . . 3124.FORECAST . . 3125.FREQUENCY . . . . . . . . 3126.FTEST. . 3127.GAMMADIST . . . . . . . . 3128.GAMMAINV . . 31829.GAMMALN. 3130.GEOMEA