サポートされている数式関数
Contents
[
Hide
]
Aspose.Cells API はほとんどの標準関数およびExcelの組み込み数式をサポートしています。以下に、すべてのサポートされている関数をアルファベット順にご確認いただけます。
ランタイムでの設定、読み取り、および計算
Aspose.Cells の数式計算エンジンを使用して、以下の数式および関数の結果を設定、読み取り、および計算することができます。
A
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- AND
- AREAS
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
B
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
C
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONVERT
- CORREL
- COS
- COSH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CUMIPMT
- CUMPRINC
D
- DATE
- DATEDIF
- DATEVALUE
- DAVERAGE
- DAY
- DAYS
- DAYS360
- DB
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DEGREES
- DELTA
- DEVSQ
- DGET
- DISC
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
E
- EDATE
- EFFECT
- EOMONTH
- ERF
- ERFC
- ERROR.TYPE
- EVEN
- EXACT
- EXP
- EXPONDIST
F
- F.DIST
- F.DIST.RT
- F.INV.RT
- FACT
- FACTDOUBLE
- FDIST
- FILTER
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FLOOR.MATH
- FORECAST
- FORECAST.LINEAR
- FORMULATEXT
- FREQUENCY, FV
- FVSCHEDULE
- FALSE
G
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GCD
- GEOMEAN
- GETPIVOTDATA
- GESTEP
- GROWTH
H
- HARMEAN
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HLOOKUP
- HOUR
- HYPERLINK
- HYPGEOM.DIST
- HYPGEOMDIST
I
- IF
- IFERROR
- IFNA
- IFS
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- INDEX
- INDIRECT
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
K
- KURT
L
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LINEST
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORM.DIST
- LOGNORMDIST
- LOOKUP
- LOWER
M
- MATCH
- MAX
- MAXA
- MAXIFS
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINIFS
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MODE.MULT
- MODE.SNGL
- MONTH
- MROUND
- MULTINOMIAL
N
- N
- NA
- NEGBINOM.DIST
- NEGBINOMDIST
- NETWORKDAYS
- NETWORKDAYS.INTL
- NOMINAL
- NORM.DIST
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORM.INV
- NORMINV
- NORMSDIST
- NOT
- NOW
- NPER
- NPV
- NUMBERVALUE
O
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- OR
P
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PI
- PMT
- POISSON
- POISSON.DIST
- POWER
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- PV
Q
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- QUOTIENT
R
- RADIANS
- RAND
- RANDBETWEEN
- RANDARRAY
- RANK
- RANK.AVG
- RANK.EQ
- RATE
- RECEIVED
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- RSQ
S
- SEARCH
- SEARCHB
- SECOND
- SEQUENCE
- SERIESSUM
- SIGN
- SIN
- SINH
- SKEW
- SLN
- SLOPE
- SMALL
- SQRT
- SORTBY
- SQRTPI
- STANDARDIZE
- STDEV
- STDEV.P
- STDEV.S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUBSTITUTE
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- SWITCH
- SYD
T
- T
- T.DIST.2T
- T.DIST.RT
- T.INV.2T
- T.TEST
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTJOIN
- TIME
- TIMEVALUE
- TINV
- TODAY
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUNC
- TTEST
- TYPE
- TRUE
U
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
V
- VALUE
- VAR
- VAR.P
- VAR.S
- VARA
- VARP
- VARPA
- VDB
- VLOOKUP
W
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WIDECHAR
- WORKDAY
- WORKDAY.INTL
X
- XIRR
- XNPV
Y
- YEAR
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT
Z
- Z.TEST
- ZTEST