Excel関数の一覧
カテゴリごとにまとめています。関数名をえらぶと、構文・使用例・対応バージョン・その関数を使うレシピが見られます。
検索・行列（39件）
論理（20件）
数学・三角（79件）
- SUM
- SUMIF
- SUMIFS
- ROUND
- ROUNDUP
- ROUNDDOWN
- INT
- MOD
- ABS
- SUBTOTAL
- AGGREGATE
- RAND
- RANDBETWEEN
- SEQUENCE
- SUMPRODUCT
- TRUNC
- CEILING
- FLOOR
- MROUND
- PRODUCT
- POWER
- SQRT
- QUOTIENT
- LCM
- GCD
- PI
- ACOS
- ACOSH
- ACOT
- ACOTH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BASE
- COMBIN
- COMBINA
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DECIMAL
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- ISO.CEILING
- CEILING.MATH
- FLOOR.MATH
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- RANDARRAY
- MMULT
- MUNIT
- ODD
- RADIANS
- ROMAN
- ARABIC
- SEC
- SECH
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRTPI
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- MULTINOMIAL
統計（143件）
- COUNTIF
- COUNTIFS
- AVERAGE
- RANK.EQ
- COUNTA
- COUNTBLANK
- MAX
- MIN
- LARGE
- SMALL
- MEDIAN
- AVERAGEIF
- AVERAGEIFS
- COUNT
- MAXA
- MINA
- AVEDEV
- AVERAGEA
- BETADIST
- BETA.DIST
- BETAINV
- BETA.INV
- BINOMDIST
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- CHIDIST
- CHISQ.DIST
- CHISQ.DIST.RT
- CHIINV
- CHISQ.INV
- CHISQ.INV.RT
- CHITEST
- CHISQ.TEST
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CORREL
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- DEVSQ
- EXPONDIST
- EXPON.DIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FDIST
- FINV
- FISHER
- FISHERINV
- FORECAST
- FORECAST.LINEAR
- FREQUENCY
- GAMMA
- GAMMADIST
- GAMMA.DIST
- GAMMAINV
- GAMMA.INV
- GAMMALN
- GAMMALN.PRECISE
- GAUSS
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- HYPGEOM.DIST
- INTERCEPT
- KURT
- LINEST
- LOGEST
- LOGNORM.DIST
- LOGNORMDIST
- LOGNORM.INV
- LOGINV
- MODE
- MODE.MULT
- MODE.SNGL
- NEGBINOMDIST
- NEGBINOM.DIST
- NORM.DIST
- NORMDIST
- NORM.INV
- NORMINV
- NORM.S.DIST
- NORMSDIST
- NORM.S.INV
- NORMSINV
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- POISSON
- POISSON.DIST
- PROB
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- RANK
- RANK.AVG
- RSQ
- SKEW
- SKEW.P
- SLOPE
- STANDARDIZE
- STDEV
- STDEV.P
- STDEV.S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- T.DIST
- T.DIST.2T
- T.DIST.RT
- TDIST
- T.INV
- T.INV.2T
- TINV
- T.TEST
- TTEST
- TREND
- TRIMMEAN
- VAR
- VAR.P
- VAR.S
- VARA
- VARP
- VARPA
- WEIBULL
- WEIBULL.DIST
- Z.TEST
- MAXIFS
- MINIFS
- FORECAST.ETS
日付・時刻（25件）
文字列操作（40件）
情報（21件）
財務（53件）
- FV
- PMT
- IPMT
- PPMT
- NPER
- RATE
- PV
- NPV
- IRR
- XIRR
- XNPV
- MIRR
- SLN
- SYD
- DB
- DDB
- VDB
- ISPMT
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- MDURATION
- EFFECT
- NOMINAL
- FVSCHEDULE
- INTRATE
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PRICE
- PRICEDISC
- PRICEMAT
- RECEIVED
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- YIELD
- YIELDDISC
- YIELDMAT
エンジニアリング（54件）
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- OCT2BIN
- OCT2DEC
- OCT2HEX