EXCEL函数表最全的函数大全.doc

函数大全一、数据库函数(13条)DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期与时间函数(20条)WORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC   三、外部函数(2条)   四、工程函数(39条)PLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DEC 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··INFO·IS类·ISEVEN·ISODD·N·NA·TYPE七、逻辑运算符(6条)·AND·FALSE·IF·NOT·OR·TRUE八、查找和引用函数(17条)·ADDRESS·AREAS·CHOOSE·COLUMN·COLUMNS·HLOOKUP·HYPERLINK·INDEX·INDIRECT·LOOKUP·MATCH·OFFSET·ROW·ROWS·RTD·TRANSPOSE·VLOOKUP九、数学和三角函数(60条)·ABS·ACOS·ACOSH·ASIN·ASINH·ATAN·ATAN2·ATANH·BIN·COS·COSH·COUNTIF·DEGREES·EVEN·EXP·FACT·FACTDOUBLE·FLOOR·GCD·INT·LCM·LN·LOG·LOG10·MDETERM·MINVERSE·MMULT·MOD·MROUNDMULTINOMIAL·ODD·PI·POWER·PRODUCT·QUOTIENT·RADIANS·RAND·RANDBETWEEN·ROMAN·ROUND·ROUNDDOWN·ROUNDUP·SERIESSUM·SIGN·SIN·SINH·SQRT·SQRTPI·SUBTOTAL·SUM·SUMIF·SUMPRODUCT·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·FORECAST·FREQUENCY·FTEST·GAMMADIST·GAMMAINV·GAMMALN·GEOMEAN·GROWTH·HARMEAN·HYPGEOMDIST·INTERCEPT·KURT·LARGE·LINEST·LOGEST·LOGINV·LOGNORMDIST·MAX·MAXA·MEDIAN·MIN·MINA·MODE·NEGBINOMDIST·NORMDIST·NORMSINV·NORMSDIST·NORMSINV·PEARSON·PERCENTILE·PERCENTRANK·PERMUT·POISSON·PROB·QUARTILE·RANK·RSQ·SKEW·SLOPE·SMALL·STANDARDIZE·STDEV·STDEVA·STDEVP·STDEVPA·STEYX·TDIST·TINV·TREND·