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

函数大全
一、数据库函数(13条)
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
GETPIVOTDATA
二、日期与时间函数(20条)
DATE
DATEVaLUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SECOND
TIME
TIMEVaLUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC
 
 
 
三、外部函数(2条)
EUROCONVERT

 
  
四、工程函数(39条)
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
MCONJUGATE
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSIN
IMSQRT
IMSUB
IMSUM
OCT2BIN
OCT2DEC
 OCT2HEX
 
五、财务函数(52条)
·ACCRINT
·ACCRINTM
·AMORDEGRC
·AMORLINC
·COUPDAYBS
·COUPDAYS
·COUPDAYSNC
·COUPNUM
·COUPPCD
·CUMIPMT
·CUMPRINC
·DB
·DDB
·DISC
DOLLARDE
·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
·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
·SUMXM