一、数据库函数（13条）DAVERAGEDPRODUCTGETPIVOTDATA二、日期与时间函数（20条）DATEHOURTIMEYEARDATEVaLUEMINUTETIMEVaLUEYEARFRAC三、外部函数（2条）EUROCONVERTSQLREQUEST四、工程函数（39条）BESSELIBIN2OCTDELTAHEX2OCTIMDIVIMPRODUCTOCT2BINBESSELJCOMPLEXERFIMABSIMEXPIMREALOCT2DECBESSELKCONVERTERFCIMAGINARYIMLNIMSINOCT2HEX五、财务函数（52条）ACCRINTCOUPDAYSNCDDBFVMDURATIONODDFYIELDPRICEDISCSYDXNPVACCRINTMCOUPNUMDISCFVSCHEDULEMIRRODDLPRICEPRICEMATTBILLEQYIELDAMORDEGRCCOUPPCDDOLLARDEINTRATENOMINALODDLYIELDPVTBILLPRICEYIELDDISCAMORLINCCUMIPMTDOLLARFRIPMTNPERPMTRATETBILLYIELDYIELDMATCOUPDAYBSCUMPRINCDURATIONIRRNPVPPMTRECEIVEDVDBCOUPDAYSDBEFFECTISPMTODDFPRICEPRICESLNXIRRBESSELYDEC2BINGESTEPIMARGUMENTIMLOG10IMSQRTBIN2DECDEC2HEXHEX2BINMCONJUGATEIMLOG2IMSUBBIN2HEXDEC2OCTHEX2DECIMCOSIMPOWERIMSUMDAYMONTHTODAYDAYS360NETWORKDAYSWEEKDAYEDATENOWWEEKNUMEOMONTHSECONDWORKDAYDCOUNTDSTDEVDCOUNTADSTDEVPDGETDSUMDMAXDVARDMINDVARP
六、信息函数（9条）CELLNERRORTYPENAINFOTYPE七、逻辑运算符（6条）ANDFALSEIFNOTORTRUE类ISISEVENISODD
八、查找和引用函数（17条）ADDRESSHYPERLINKROWAREASINDEXROWSCHOOSEINDIRECTRTDCOLUMNLOOKUPTRANSPOSECOLUMNSMATCHVLOOKUPHLOOKUPOFFSET
九、数学和三角函数（60条）ABSACOSACOSHASINASINHATAN1
fATAN2COUNTIFFLOORLOG10MULTINOMIALRADIANSROUNDUPSQRTPISUMX2MY2
ATANHDEGREESGCDMDETERMODDRANDSERIESSUMSUBTOTALSUMX2PY2
CEILINGEVENINTMINVERSEPIRANDBETWEENSIGNSUMSUMXMY2
COMBINEXPLCMMMULTPOWERROMANSINSUMIFTAN
COSFACTLNMODPRODUCTROUNDSINHSUMPRODUCTTANH
COSHFACTDOUBLELOGMROUNDQUOTIENTROUNDDOWNSQRTSUMSQTRUNC
十、统计函数（80条）AVEDEVCHIDISTCOUNTAEXPONDISTFREQUENCYGROWTHLINESTMEDIANNORMSINVPERMUTSKEWSTDEVPTRIMMEANWEIBULLAVERAGECHIINVCOUNTBLANKFDISTFTESTHARMEANLOGESTMINNORMSDISTPOISSONSLOPESTDEVPATTESTZTEST十一、文本和数据函数（28条）ASCEXACTLEN或LENBREPTTRIMCHARFINDLOWERCLEANFINDBMID或MIDBCODEFIXEDPHONETICCONCATENr