欢迎来到天天文库
浏览记录
ID:21129348
大小:538.50 KB
页数:48页
时间:2018-10-19
《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
此文档下载收益归作者所有