Excel函数汇总

Excel增强2016版本和截至2020年6月份的WPS版本进行的对比。现版本的Excel最新版本应该也没多多少个新的公式，有的话可以自行稍做整理。

Excel函数汇总

Excel2016版本和截至2020年6月份的WPS版本进行的对比出于其他原因，标成绿色3种函数没有进行练习对比

数学与三角函数74 ABSACOSACOSHACOTACOTHAGGREGATEARABICASINASINHATANATAN2ATANHBASECEILING.MATHCOMBINCOMBINACOSCOSHCOTCOTHCSCCSCHDECIMALDEGREESEVENEXPFACTFACTDOUBLEFLOOR.MATHGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALMUNITODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSECSECHSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMIFSSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC

统计108 AVEDEVAVERAGEAVERAGEAAVERAGEIFAVERAGEIFSBETA.DISTBETA.INVBINOM.DISTBINOM.DIST.RANGEBINOM.INVCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTCHISQ.TESTCONFIDENCE.NORMCONFIDENCE.TCORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOUNTIFSCOVARIANCE.PCOVARIANCE.SDEVSQEXPON.DISTF.DISTF.DIST.RTF.INVF.INV.RTF.TESTFISHERFISHERINVFORECAST.ETSFORECAST.ETS.CONFINTFORECAST.ETS.SEASONALITYFORECAST.ETS.STATFORECAST.LINEARFREQUENCYGAMMAGAMMA.DISTGAMMA.INVGAMMALNGAMMALN.PRECISEGAUSSGEOMEANGROWTHHARMEANHYPGEOM.DISTINTERCEPTKURTLARGELINESTLOGESTLOGNORM.DISTLOGNORM.INVMAXMAXAMEDIANMINMINAMODE.MULTMODE.SNGLNEGBINOM.DISTNORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPEARSONPERCENTILE.EXCPERCENTILE.INCPERCENTRANK.EXCPERCENTRANK.INCPERMUTPERMUTATIONAPHIPOISSON.DISTPROBQUARTILE.EXCQUARTILE.INCPANK.AVGPANK.EQRSQSKEWSKEW.PSLOPESMALLSTANDARDIZESTDEV.PSTDEV.SSTDEVASTDEVPASTEYXT.DISTT.DIST.2TT.DIST.RTT.INVT.INV.2TT.TESTTRENDTRIMMEANVAR.PVAR.SVARAVARPAWEIBULL.DISTZ.TEST

工程54 BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTBITANDBITLSHIFTBITORBITRSHIFTBITXORCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERF.PRECISEERFCERFC.PRECISEGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMCOSHIMCOTIMCSCIMCSCHIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSECIMSECHIMSINIMSINHIMSQRTIMSUBIMSUMIMTANOCT2BINOCT2DECOCT2HEX  

多维数据集77CUBEKPIMEMBERCUBEMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESETCUBESETCOUNTCUBEVALUE  

兼容性410BETADISTBETAINVBINOMDISTCEILINGCHIDISTCHIINVCHITESTCONFIDENCECOVARCRITBINOMEXPONDISTFDISTFINVFLOORFORECASTFTESTGAMMADISTGAMMAINVHYPGEOMDISTLOGINVLOGNORMDISTMODENEGBINOMDISTNORMDISTNORMINVNORMSDISTNORMSINVPERCENTILEPERCENTRANKPOISSONQUARTILERANKSTDEVSTDEVPTDISTTINVTTESTVARVARPWEIBULLZTEST  

WEB33ENCODEURLFILTERXMLWEBSERVICE  

Office函数总数464WPS函数总数419Office有wps没有45  主题附有网盘Excel版链接