excel的全部函数举例介绍

《excel的全部函数举例介绍》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、-Excel函数用途、参数、用法速查表（按Ctrl+F搜索）一、数据库函数（13条）DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期与时间函数（20条）DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHNETWORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC三、外部函数（2条）EUROCONVERTSQL.R

2、EQUEST    四、工程函数（39条）BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX 五、财务函数（

3、52条）ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCHEDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICEODDFYIELDODDLPRICEODDLYIELDPMTPPMTPRICEPRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQT

4、BILLPRICETBILLYIELDVDBXIRRXNPVYIELDYIELDDISCYIELDMAT   六、信息函数（9条）CELLERROR.TYPEINFOIS类ISEVENISODDNNATYPE----七、逻辑运算符（6条）ANDFALSEIFNOTORTRUE八、查找和引用函数（17条）ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTDTRANSPOSEVLOOKUP   九、数学和三角函数（60条）ABSACOSACO

5、SHASINASINHATANATAN2ATANHCEILINGCOMBINCOSCOSHCOUNTIFDEGREESEVENEXPFACTFACTDOUBLEFLOORGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQSUMX

6、2MY2SUMX2PY2SUMXMY2TANTANHTRUNC十、统计函数（80条）AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTIN

7、TERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALLSTANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTES

8、T十一、文本和数据函数（28条）----ASCCHA