|
一、数据库函数（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条）
|
|
|
|
四、工程函数（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
|
ERROR.TYPE
|
INFO
|
IS 类
|
ISEVEN
|
|
ISODD
|
N
|
NA
|
TYPE
|
|
|
|
七、逻辑运算符（6条）
|
|
|
|
八、查找和引用函数（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
|
|
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
|
TRIMMEAN
|
TTEST
|
VAR
|
|
VARA
|
VARP
|
VARPA
|
WEIBULL
|
ZTEST
|
|
|
十一、文本和数据函数（28条）
|
|
ASC
|
CHAR
|
CLEAN
|
CODE
|
CONCATENATE
|
|
DOLLAR 或 RMB
|
EXACT
|
FIND
|
FINDB
|
FIXED
|
|
JIS
|
LEFT 或 LEFTB
|
LEN 或 LENB
|
LOWER
|
MID 或 MIDB
|
|
PHONETIC
|
PROPER
|
REPLACE 或 REPL
|
REPT
|
RIGHT 或 RIGHTB
|
|
SEARCH 或 SEARC
|
SUBSTITUTE
|
T
|
TEXT
|
TRIM
|
|
UPPER
|
value
|
WIDECHAR
|
|
|
|
