excel函数详解(提高篇)

1目录一、函数应用基础....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.......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.........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.....10231.IMPRODUCT.1032.IMREAL.......1033.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...1539.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...........2039.INDIRECT.....2010.LOOKUP.......2011.MATCH.........2012.OFFSET.......2113.ROW.............2114.ROWS...........2115.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.2643.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.30418.DEVSQ.........3019.EXPONDIST.3020.FDIST.........3021.FINV...........3022.FISHER.......3123.FISHERINV.3124.FORECAST...3125.FREQUENCY.3126.FTEST.........3127.GAMMADIST.3128.GAMMAINV...3129.GAMMALN.....3130.GEOMEAN.....3131.GROWTH.......3232.HARMEAN.....3233.HYPGEOMDIST...........3234.INTERCEPT.3235.KURT...........3236.LARGE.........3237.LINEST.......3238.LOGEST.......3339.LOGINV.......3340