WorkFine支持函数一览

首字母函数
A
ABS
ACOS
ACOSH
ACOT
ACOTH
ADDRESS
AGGREGATE
ARABIC
AREAS
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BBASE
BETA.DIST
BETA.INV
BETADIST
BINOM.DIST
BINOM.DIST.RAN
BINOM.INV
BINOMDIST
C
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
DDATE
DATEVALUE
DAY
DAYS
DAYS360
DECIMAL
DEGREES
DOLLAR
EEDATE
EOMONTH
ERF
ERFC
EVEN
EXACT
EXP
EXPON.DIST
FF.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
GGAMMA
GAMMA.DIST
GAMMA.INV
GAMMALN
GAUSS
GCD
GEOMEAN
HHARMEAN
HLOOKUP
HOUR
HYPERLINK
IIF
IFERROR
NDEX
INDIRECT
INT
INTERCEPT
SBLANK
ISERR
ISERROR
SEVEN
ISLOGICAL
ISNA
SNONTEXT
SNUMBER
ISO.CEILING
SODD
SOWEEKNUM
ISREF
STEXT
KKURT
LLARGE
LCM
LEFT
LEN
LINEST
LN
LOG
LOG10
LOGEST
LOGNORM.DIST
LOGNORM.INV
LOWER
MMATCH
MAX
MDETERM
MEDIAN
MID
MIN
MINUTE
MINVERSE
MMULT
MOD
MODE.MULT
MODE.SNGL
MONTH
MROUND
MULTINOMIAL
MUNIT
NN
NA
NEGBINOM.DIST
NEGBINOMDIST
NETWORKDAYS
NORM.DIST
NORM |NV
NORM.S.DIST
NORM.S.INV
NOT
NOW
OODD
OFFSET
PPEARSON
PERCENTLE
PERCENTILE.EXC
PERCENTILE,INC
PERCENTRANK
PERCENTRANK.E
PERCENTRANKI
PHI
PI
POISSON.DIST
POWER
PROB
PRODUCT
PROPER
QQUARTILE
QUARTILE.EXC
QUARTILE.INC
QUOTIENT
RRADIANS
RAND
RANDBETWEEN
RANK
RANKAVG
RANK.EQ
REPLACE
REPT
RIGHT
ROMAN
ROUNDUP
ROW
ROWS
RSQ
ROUNDDOWN
SSEARCH
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
TT
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
UUNICHAR
UNICODE
UPPER
VVALUE
VAR.P
VAR.S
VLOOKUP
WWEEKDAY
WEEKNUM
WORKDAY
YYEAR
YEARFRAC
© 版权声明
THE END
喜欢就点赞吧
点赞7 分享