EXCEL函数表函数大全-资料

函 数 大 全一、数据库函数（13 条）DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期与时间函数（20 条）DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHNETWORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC 三、外部函数（2 条）EUROCONVERTSQL.REQUEST 四、工程函数（39 条）BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DEC OCT2HEX 五、财务函数（52 条）·ACCRINT·ACCRINTM·AMORDEGRC·AMORLINC·COUPDAYBS·COUPDAYS·COUPDAYSNC·COUPNUM·COUPPCD·CUMIPMT·CUMPRINC·DB·DDB·DISCDOLLARDE·DOLLARFR·DURATION·EFFECT·FV·FVSCHEDULE·INTRATE·IPMT·IRR·ISPMT·MDURATION·MIRR·NOMINAL·NPER·NPV·ODDFPRICE·ODDFYIELD·ODDLPRICE·ODDLYIELD·PMT·PPMT·PRICE·PRICEDISC·PRICEMAT·PV·RATE·RECEIVED·SLN·SYD·TBILLEQ·TBILLPRICE·TBILLYIELD·VDB·XIRR·XNPV·YIELD·YIELDDISC·YIELDMAT六、信息函数（9 条）·CELL ·ERROR.TYPE ·INFO ·IS 类 ·ISEVEN ·ISODD ·N·NA ·TYPE 七、逻辑运算符（6 条）·AND·FALSE·IF·NOT·OR·TRUE八、查找和引用函数（17 条）·ADDRESS·AREAS·CHOOSE·COLUMN·COLUMNS·HLOOKUPK·INDEX·INDIRECT·LOOKUP·MATCH·OFFSET·ROW·ROWS·RTD·TRANSPOSE·VLOOKUP九、数学和三角函数（60 条）·ABS·ACOS·ACOSH·ASIN·ASINH·ATAN·ATAN2·ATANH·CEILINGN·COS·COSH·COUNTIF·DEGREES·EVEN·EXP·FACTE·FLOOR·GCD·INT·LCM·LN·LOG·LOG10·MDETERM·MINVERSE·MMULT·MOD·MROUNDMULTINOMIAL·ODD·PI·POWER·PRODUCT·QUOTIENT·RADIANS·RANDN·ROMAN·ROUNDN·ROUNDUPM·SIGN·SIN·SINH·SQRT·SQRTPI·SUBTOTAL·SUM·SUMIFT·SUMSQ·SUMX2MY2·SUMX2PY2·SUMXMY2·TAN·TANH·TRUNC十、统计函数（80 条）·AVEDEV·AVERAGE·AVERAGEA·BETADIST·BETAINV·BINOMDIST·CHIDIST·CHIINV·CHITEST·CONFIDENCE·CORREL·COUNT·COUNTA·COUNTBLANK·COUNTIF·COVAR·CRITBINOM·DEVSQ·EXPONDIST·FDIST·FINV·FISHER·FISHERINV·FORECA...