WorkFine支持函数一览

序号首字母函数备注
1A
ABS
ACOS
ACOSH
ACOT
ACOTH
ADDRESS
AGGREGATE
ARABIC
AREAS
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
2BBASE
BETA.DIST
BETA.INV
BETADIST
BINOM.DIST
BINOM.DIST.RAN
BINOM.INV
BINOMDIST
3C
CEILING
CEILING.MATH
CEILING.PRECISE
CHAR
CHISO,DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHOOSE
CLEAN
CODE
COLUMN
COLUMNS
COMBIN
COMBINA
CONCATENATE
CONFIDENCE.NO
CONFIDENCE.T
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVAR
COVARIANCE.P
COVARIANCE.S
CRITBINOM
CSC
CSCH
CAMOUNT
4DDATE
DATEVALUE
DAY
DAYS
DAYS360
DECIMAL
DEGREES
DOLLAR
5EEDATE
EOMONTH
ERF
ERFC
EVEN
EXACT
EXP
EXPON.DIST
6FF.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FACT
FACTDOUBLE
FALSE
FIND
FISHER
FISHERINV
FIXED
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FORECAST
FORMULATEXT
FREQUENCY
7GGAMMA
GAMMA.DIST
GAMMA.INV
GAMMALN
GAUSS
GCD
GEOMEAN
8HHARMEAN
HLOOKUP
HOUR
HYPERLINK
9IIF
IFERROR
NDEX
INDIRECT
INT
INTERCEPT
SBLANK
ISERR
ISERROR
SEVEN
ISLOGICAL
ISNA
SNONTEXT
SNUMBER
ISO.CEILING
SODD
SOWEEKNUM
ISREF
STEXT
10KKURT
11LLARGE
LCM
LEFT
LEN
LINEST
LN
LOG
LOG10
LOGEST
LOGNORM.DIST
LOGNORM.INV
LOWER
12MMATCH
MAX
MDETERM
MEDIAN
MID
MIN
MINUTE
MINVERSE
MMULT
MOD
MODE.MULT
MODE.SNGL
MONTH
MROUND
MULTINOMIAL
MUNIT
13NN
NA
NEGBINOM.DIST
NEGBINOMDIST
NETWORKDAYS
NORM.DIST
NORM |NV
NORM.S.DIST
NORM.S.INV
NOT
NOW
14OODD
OFFSET
15PPEARSON
PERCENTLE
PERCENTILE.EXC
PERCENTILE,INC
PERCENTRANK
PERCENTRANK.E
PERCENTRANKI
PHI
PI
POISSON.DIST
POWER
PROB
PRODUCT
PROPER
16QQUARTILE
QUARTILE.EXC
QUARTILE.INC
QUOTIENT
17RRADIANS
RAND
RANDBETWEEN
RANK
RANKAVG
RANK.EQ
REPLACE
REPT
RIGHT
ROMAN
ROUNDUP
ROW
ROWS
RSQ
ROUNDDOWN
18SSEARCH
SEC
SECH
SECOND
SERIESSUM
SIGN
SIN
SINH
SLOPE
SMALL
SQRT
SQRTPI
STDEV.P
STDEV.S
STEYX
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
19TT
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
TAN
TANH
TEXT
TIME
TIMEVALUE
TODAY
TRANSPOSE
TRIM
TRIMMEAN
TRUE
20UUNICHAR
UNICODE
UPPER
21VVALUE
VAR.P
VAR.S
VLOOKUP
22WWEEKDAY
WEEKNUM
WORKDAY
23YYEAR
YEARFRAC
© 版权声明
THE END
喜欢就点赞吧
点赞7 分享
评论 抢沙发

请登录后发表评论

    暂无评论内容

随机帖子