EXCEL函数表(最全的函数大全).docx

一、数据库函数(13条)函 数 大 全DAVERAGEDPRODUCTGETPIVOTDATADCOUNTDSTDEVDCOUNTA DGETDSTDEVP DSUMDMAXDVARDMINDVARP二、日期与时间函数(20条)WORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC三、外部函数(2条)、工程函数(39条)PLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX五、财务函数(52条)•SLNSYDTBIIIFQTBILLPRICETBILLYIELDVDBXIRRXNPVYIFIDYIFEDISCYIFEMAT六、信息函数(9条)、逻辑运算符(6条)ANDFALSEIFNOTOR TRUE八、查找和引用函数(17条)ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYPERLINK■INDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTDTRANSPOSEVLOOKUP九、数学和三角函数(60条)CDINTLCMLNLOGLOG1OMDETERMMINVERSEMIMULTMODMROUNDMULTINOMIALODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSERIESSUMSIGN•SINSINHSQRTSQRTPISUBTOTALSUM•SUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC十、统计函数(80条)AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALL•STANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTEST十一、文本和数据函数(28条)ICPROPERREPLACEREPLREPTRIGHTRIGHTBSEARCHSEARCSUBSTITUTETTEXTTRIMUPPERVALUEWIDECHARCriteria为一组包含给定条件的单元格Criteria为一组包含给定条件的单元格Criteria为一组包含给定条件的单元格Criteria为一组包含给定条件的单元格Criteria为一组包含给定条件的单元格Criteria为一组包含给定条件的单元格一、数据库函数(13条)DAVERAGE【用途】返回数据库或数据清单中满足指定条件的列中数值的平均值。【语法】DAVERAGE(databasefield,criteria)【参数】Da