Excel2010公式释义及示例大全.pdf

《Excel2010公式释义及示例大全.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Excel公式释义及示例大全2010版林屹针对MicrosoftOfficeExcel2010，对所有涉及公式进行梳理，方便用户查阅使用。Excel公式释义及示例大全（2010版）较之2007版新增函数：二、日期与时间NETWORKDAYS.INTLWORKDAY.INTL三、数学与三角函数AGGREGATECEILING.PRECISEFLOOR.PRECISE四、统计BETA.DISTBETA.INVBINOM.DISTBINOM.INVCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTCHISQ

2、.TESTCONFIDENCE.NORMCONFIDENCE.TCOVARIANCE.PCOVARIANCE.SEXPON.DISTF.DISTF.DIST.RTF.INVF.INV.RTF.TESTGAMMA.DISTGAMMA.INVGAMMALN.PRECISEHYPGEOM.DISTLOGNORM.DISTLOGNORM.INVMODE.MULTMODE.SNGLNEGBINOM.DISTNORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPERCENTILE.EXCPERCENTILE.INCPERCEN

3、TRANK.EXCPERCENTRANK.INCPOISSON.DISTQUARTILE.EXCQUARTILE.INCRANK.AVGRANK.EQSTDEV.PSTDEV.ST.DISTT.DIST.2TT.DIST.RTT.INVT.INV.2TT.TESTVAR.PVAR.SWEIBULL.DISTZ.TEST十、工程ERF.PRECISEERFC.PRECISE-I-Excel公式释义及示例大全（2010版）目录一、财务.......................................................

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

5、...............1ACCRINTM函数...........................................................................................................................................................2AMORDEGRC函数...............................................................................

6、........................................................................3AMORLINC函数...........................................................................................................................................................4COUPDAYBS函数......................

7、...................................................................................................................................5COUPDAYS函数..................................................................................................................................

8、.........................6COUPDAYSNC函数..........................................................