Excel2010函数公式释义及示例大全

《Excel2010函数公式释义及示例大全》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Excel公式释义及示例大全（2010版）较之2007版新增函数：二、日期与时间NETWORKDAYS.INTLWORKDAY.INTL三、数学与三角函数AGGREGATECEILING.PRECISEFLOOR.PRECISE四、统计BETA.DISTBETA.INVBINOM.DISTBINOM.INVCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTCHISQ.TESTCONFIDENCE.NORMCONFIDENCE.TCOVARIANCE.PCOVARIANCE.SEXPON.DISTF.DISTF.DIST.RTF

2、.INVF.INV.RTF.TESTGAMMA.DISTGAMMA.INVGAMMALN.PRECISEHYPGEOM.DISTLOGNORM.DISTLOGNORM.INVMODE.MULTMODE.SNGLNEGBINOM.DISTNORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPERCENTILE.EXCPERCENTILE.INCPERCENTRANK.EXCPERCENTRANK.INCPOISSON.DISTQUARTILE.EXCQUARTILE.INCRANK.AVGRANK.EQSTDEV.PSTDEV.ST.DIST

3、T.DIST.2TT.DIST.RTT.INVT.INV.2TT.TESTVAR.PVAR.SWEIBULL.DISTZ.TEST十、工程ERF.PRECISEERFC.PRECISE-I-Excel公式释义及示例大全（2010版）目录一、财务...................................................................................................................................................................

4、...........1ACCRINT函数..............................................................................................................................................................1ACCRINTM函数...............................................................................................

5、............................................................2AMORDEGRC函数.......................................................................................................................................................3AMORLINC函数...................................................

6、........................................................................................................4COUPDAYBS函数.........................................................................................................................................................5COUPDAYS函数.....

7、......................................................................................................................................................6COUPDAYSNC函数..........................................................................................................................

8、.....