((完整版))EXCEL函数表(最全的函数大全)-推荐文档.pdf

函数大全

一、数据库函数（13条）

DAVERAGEDCOUNTDCOUNTADGETDMAXDMIN

DPRODUCTDSTDEVDSTDEVPDSUMDVARDVARP

GETPIVOTDATA

二、日期与时间函数（20条）

DATEDATEVaLUEDAYDAYS360EDATEEOMONTH

HOURMINUTEMONTHNETWORKDAYSNOWSECOND

TIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAY

YEARYEARFRAC

三、外部函数（2条）

EUROCONVERTSQL.REQUEST

四、工程函数（39条）

BESSELIBESSELJBESSELKBESSELYBIN2DEC

BIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BIN

DEC2HEXDEC2OCTDELTAERFERFC

GESTEPHEX2BINHEX2DECHEX2OCTIMABS

IMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIV

IMEXPIMLNIMLOG10IMLOG2IMPOWER

IMPRODUCTIMREALIMSINIMSQRTIMSUB

IMSUMOCT2BINOCT2DECOCT2HEX

五、财务函数（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

1
六、信息函数（9条）

·CELL·ERROR.TYPE·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·CEILING·COMBIN·COS·COSH

·COUNTIF·DEGREES·EVEN·EXP·FACT·FACTDOUBLE

·FLOOR·GCD·INT·LCM·LN·LOG

·LOG10·MDETERM·MINVERSE·MMULT·MOD·MROUND

MULTINOMIAL·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·