excel函数速查表

《excel函数速查表》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Excel函数速查表一、数据库函数DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期与时间函数DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHETIMEVaLUETODAYABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMO

2、CT2BINOCT2DECOCT2HEX五、财务函数ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCHEDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICEODDFYIELDODDLPRICEODDLYIELDPMTPPMTPRICEPRICEDISCPRICE

3、MATPVRATERECEIVEDSLNSYDTBILLEQTBILLPRICETBILLYIELDVDBXIRRXNPVYIELDYIELDDISCYIELDMAT六、信息函数CELLERROR.TYPEINFOIS类ISEVENISODDNNATYPE七、逻辑运算符ANDFALSEIFNOTORTRUE八、查找和引用函数ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROLNLOGLOG10MDETERMMINVERSEMMULTM

4、ODMROUNDMULTINOMIALODDPIPOANROUNDROUNDDOSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC十、统计函数AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDI

5、STFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEALL

6、STANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPABEXACTFINDFINDBFIXEDJISLEFT或LEFTBLEN或LENBLOID或MIDBPHOICPROPERREPLACE或REPLREPTRIGHT或RIGHTBSEARCH或SEARCSUBSTITUTETTEXTTRIMUPPERvalueWIDECHAR——..，。