excel函數(shù)表(函數(shù)大全)

1、函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期與時間函數(shù)（20條）DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHWKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWKDAYYEARYEARF

2、RAC三、外部函數(shù)（2條）EUROCONVERTSQL.REQUEST四、工程函數(shù)（39條）BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIM

3、LNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX五、財務(wù)函數(shù)（52條）ACCRINTACCRINTMAMDEGRCAMLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCH

4、EDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICE十、統(tǒng)計函數(shù)（80條）AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHE

5、RFISHERINVFECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNMDISTNMSINVNMSDISTNMSINVPEARSONPERCENTILEPERCENTRANKP

6、ERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALLSTARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTEST十一、文本和數(shù)據(jù)函數(shù)（28條）CLEANCODECONCATENATEDOLLARRMBEXACTFINDFINDBFIXEDJISLEFTLEFTBLENLENBL