(按Ctrl+F搜索)
一、数据库函数(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
|
|
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
|
|
TEXT
|
TRIM
|
UPPER
|
value
|
WIDECHAR
|
|
|
|
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 86345@qq.com 举报,一经查实,本站将立刻删除。