Excel函数速查表

来源:百度文库 编辑:神马文学网 时间:2024/03/29 16:22:21
一、数据库函数
DAVERAGEDCOUNTDCOUNTADGETDMAXDMIN
DPRODUCTDSTDEVDSTDEVPDSUMDVARDVARP
GETPIVOTDATA
二、日期与时间函数
DATEDATEVaLUEDAYDAYS360EDATEEOMONTH
HOURMINUTEMONTHNETWORKDAYSNOWSECOND
TIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAY
YEARYEARFRAC
三、外部函数
EUROCONVERTSQL.REQUEST
四、工程函数
BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEX
BIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCT
DELTAERFERFCGESTEPHEX2BINHEX2DEC
HEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOS
IMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWER
IMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUM
OCT2BINOCT2DECOCT2HEX
五、财务函数
ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYS
COUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDB
DDBDISCDOLLARDEDOLLARFRDURATIONEFFECT
FVFVSCHEDULEINTRATEIPMTIRRISPMT
MDURATIONMIRRNOMINALNPERNPVODDFPRICE
ODDFYIELDODDLPRICEODDLYIELDPMTPPMTPRICE
PRICEDISCPRICEMATPVRATERECEIVEDSLN
SYDTBILLEQTBILLPRICETBILLYIELDVDBXIRR
XNPVYIELDYIELDDISCYIELDMAT
六、信息函数
CELLERROR.TYPEINFOIS类ISEVENISODD
NNATYPE
七、逻辑运算符
ANDFALSEIFNOTORTRUE
八、查找和引用函数
ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUP
HYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSET
ROWROWSRTDTRANSPOSEVLOOKUP
九、数学和三角函数
ABSACOSACOSHASINASINHATAN
ATAN2ATANHCEILINGCOMBINCOSCOSH
COUNTIFDEGREESEVENEXPFACTFACTDOUBLE
FLOORGCDINTLCMLNLOG
LOG10MDETERMMINVERSEMMULTMODMROUND
MULTINOMIALODDPIPOWERPRODUCTQUOTIENT
RADIANSRANDRANDBETWEENROMANROUNDROUNDDOWN
ROUNDUPSERIESSUMSIGNSINSINHSQRT
SQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQ
SUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC
十、统计函数
AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDIST
CHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNT
COUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQ
EXPONDISTFDISTFINVFISHERFISHERINVFORECAST
FREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEAN
GROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGE
LINESTLOGESTLOGINVLOGNORMDISTMAXMAXA
MEDIANMINMINAMODENEGBINOMDISTNORMDIST
NORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANK
PERMUTPOISSONPROBQUARTILERANKRSQ
SKEWSLOPESMALLSTANDARDIZESTDEVSTDEVA
STDEVPSTDEVPASTEYXTDISTTINVTREND
TRIMMEANTTESTVARVARAVARPVARPA
WEIBULLZTEST
十一、文本和数据函数
ASCCHARCLEANCODECONCATENATEDOLLAR 或 RMB
EXACTFINDFINDBFIXEDJISLEFT 或 LEFTB
LEN 或 LENBLOWERMID 或 MIDBPHONETICPROPERREPLACE 或 REPL
REPTRIGHT 或 RIGHTBSEARCH 或 SEARCSUBSTITUTETTEXT
TRIMUPPERvalueWIDECHAR