（按Ctrl+F搜索）
（本文来源于图老师网站，更多请访问https://m.tulaoshi.com/diannaorumen/） 一、数据库函数（13条）DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
（本文来源于图老师网站，更多请访问https://m.tulaoshi.com/diannaorumen/）DVAR
DVARP
GETPIVOTDATA
二、日期与时间函数（20条） DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHNETWORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC 三、外部函数（2条） EUROCONVERTSQL.REQUEST 四、工程函数（39条） BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX 五、财务函数（52条） ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCHEDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICEODDFYIELDODDLPRICEODDLYIELDPMTPPMTPRICEPRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQTBILLPRICETBILLYIELDVDBXIRRXNPVYIELDYIELDDISCYIELDMAT 六、信息函数（9条） CELLERROR.TYPEINFOIS 类ISEVENISODDNNATYPE 七、逻辑运算符（6条） ANDFALSEIFNOTORTRUE 八、查找和引用函数（17条） ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTDTRANSPOSEVLOOKUP 九、数学和三角函数（60条） ABSACOSACOSHASINASINHATANATAN2ATANHCEILINGCOMBINCOSCOSHCOUNTIFDEGREESEVENEXPFACTFACTDOUBLEFLOORGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC 十、统计函数（80条） AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALLSTANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTEST 十一、文本和数据函数（28条） ASCCHARCLEANCODECONCATENATEDOLLAR 或 RMBEXACTFINDFINDBFIXEDJISLEFT 或 LEFTBLEN 或 LENBLOWERMID 或 MIDBPHONETICPROPERREPLACE 或 REPLREPTRIGHT 或 RIGHTBSEARCH 或 SEARCSUBSTITUTETTEXTTRIMUPPERvalueWIDECHAR
