excel的全部函数举例介绍

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

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

2、函数（2条）EUROCONVERTSQL.REQUEST    四、工程函数（39条）BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSIN

3、IMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX 五、财务函数（52条）ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCHEDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICEODDFYIELDODDLPRI

4、CEODDLYIELDPMTPPMTPRICEPRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQTBILLPRICETBILLYIELDVDBXIRRXNPVYIELDYIELDDISCYIELDMAT   六、信息函数（9条）CELLERROR.TYPEINFOIS类ISEVENISODDNNATYPE七、逻辑运算符（6条）48ANDFALSEIFNOTORTRUE八、查找和引用函数（17条）ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYP

5、ERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTDTRANSPOSEVLOOKUP   九、数学和三角函数（60条）ABSACOSACOSHASINASINHATANATAN2ATANHCEILINGCOMBINCOSCOSHCOUNTIFDEGREESEVENEXPFACTFACTDOUBLEFLOORGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALODDPIPOWERPRODUCTQUOTIENTR

6、ADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC十、统计函数（80条）AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOU

7、NTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPER

8、CENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALLSTANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTEST十一、文本和数据函数（28条）ASCCHARCLEANC