PR

Excel2003/2007/2010/2013/2016/2016/2021・Office365関数対応一覧表(アルファベット順)

スポンサーリンク
2024.08.16
この記事は約33分で読めます。

 

Excel2003～2021/Office365関数一覧アルファベット順

※互換性のある関数を前後に同色で色付けして表示しているため、一部の関数はアルファベト順になっていない個所がありますがご了承ください。

何故Excel2003？と思われる方もいらっしゃるでしょうが、大きなシステム会社などになると、まだ使われている現場もありますのでまとめてみました。

使える関数だけとか、使えない関数だけはあるんですけど、全ての一覧が見当たらなかったので、今回作成しました！

※関数を検索する場合「Ctrl+F」を押下して検索窓を開き、関数名を入力して検索してください。

関数名 Excel 2003 Excel 2007 Excel 2010 Excel 2013 Excel 2016 Excel 2019 Excel 2021 office 365
ABS 〇 〇 〇 〇 〇 〇 〇 〇
ACCRINT 〇 〇 〇 〇 〇 〇 〇 〇
ACCRINTM 〇 〇 〇 〇 〇 〇 〇 〇
ACOS 〇 〇 〇 〇 〇 〇 〇 〇
ACOSH 〇 〇 〇 〇 〇 〇 〇 〇
ACOT × × × 〇 〇 〇 〇 〇
ACOTH × × × 〇 〇 〇 〇 〇
ADDRESS 〇 〇 〇 〇 〇 〇 〇 〇
AGGREGATE × × 〇 〇 〇 〇 〇 〇
AMORDEGRC 〇 〇 〇 〇 〇 〇 〇 〇
AMORLINC 〇 〇 〇 〇 〇 〇 〇 〇
AND 〇 〇 〇 〇 〇 〇 〇 〇
ARABIC × × × 〇 〇 〇 〇 〇
AREAS 〇 〇 〇 〇 〇 〇 〇 〇
ARRAYTOTEXT × × × × × × × 〇
ASC 〇 〇 〇 〇 〇 〇 〇 〇
ASIN 〇 〇 〇 〇 〇 〇 〇 〇
ASINH 〇 〇 〇 〇 〇 〇 〇 〇
ATAN 〇 〇 〇 〇 〇 〇 〇 〇
ATAN2 〇 〇 〇 〇 〇 〇 〇 〇
ATANH 〇 〇 〇 〇 〇 〇 〇 〇
AVEDEV 〇 〇 〇 〇 〇 〇 〇 〇
AVERAGE 〇 〇 〇 〇 〇 〇 〇 〇
AVERAGEA 〇 〇 〇 〇 〇 〇 〇 〇
AVERAGEIF × 〇 〇 〇 〇 〇 〇 〇
AVERAGEIFS × 〇 〇 〇 〇 〇 〇 〇
BAHTTEXT 〇 〇 〇 〇 〇 〇 〇 〇
BASE × × × 〇 〇 〇 〇 〇
BESSELI 〇 〇 〇 〇 〇 〇 〇 〇
BESSELJ 〇 〇 〇 〇 〇 〇 〇 〇
BESSELK 〇 〇 〇 〇 〇 〇 〇 〇
BESSELY 〇 〇 〇 〇 〇 〇 〇 〇
BETADIST 〇 〇 〇 〇 〇 〇 〇 〇
BETA.DIST × × 〇 〇 〇 〇 〇 〇
BETAINV 〇 〇 〇 〇 〇 〇 〇 〇
BETA.INV × × 〇 〇 〇 〇 〇 〇
BIN2DEC 〇 〇 〇 〇 〇 〇 〇 〇
BIN2HEX 〇 〇 〇 〇 〇 〇 〇 〇
BIN2OCT 〇 〇 〇 〇 〇 〇 〇 〇
BINOM.DIST.RANGE × × × 〇 〇 〇 〇 〇
BINOMDIST 〇 〇 〇 〇 〇 〇 〇 〇
BINOM.DIST × × 〇 〇 〇 〇 〇 〇
BITAND × × × 〇 〇 〇 〇 〇
BITLSHIFT × × × 〇 〇 〇 〇 〇
BITOR × × × 〇 〇 〇 〇 〇
BITRSHIFT × × × 〇 〇 〇 〇 〇
BITXOR × × × 〇 〇 〇 〇 〇
BYCOL × × × × × × × 〇
BYROW × × × × × × × 〇
CALL 〇 〇 〇 〇 〇 〇 〇 〇
CEILING.MATH × × × 〇 〇 〇 〇 〇
CEILING.PRECISE 〇 〇 〇 〇 〇 〇 〇 〇
CEILNG 〇 〇 〇 〇 〇 〇 〇 〇
CEILNG.MATH × × × 〇 〇 〇 〇 〇
CELL 〇 〇 〇 〇 〇 〇 〇 〇
CHAR 〇 〇 〇 〇 〇 〇 〇 〇
CHIDIST 〇 〇 〇 〇 〇 〇 〇 〇
CHISQ.DIST.RT × × 〇 〇 〇 〇 〇 〇
CHINV 〇 〇 〇 〇 〇 〇 〇 〇
CHISQ.INV.RT × × 〇 〇 〇 〇 〇 〇
CHISQ.DIST × × 〇 〇 〇 〇 〇 〇
CHISQ.INV × × 〇 〇 〇 〇 〇 〇
CHITEST 〇 〇 〇 〇 〇 〇 〇 〇
CHISQ.TEST × × 〇 〇 〇 〇 〇 〇
CHOOSE 〇 〇 〇 〇 〇 〇 〇 〇
CHOOSECOLS × × × × × × × 〇
CHOOSEROWS × × × × × × × 〇
CLEAN 〇 〇 〇 〇 〇 〇 〇 〇
CODE 〇 〇 〇 〇 〇 〇 〇 〇
COLUMN 〇 〇 〇 〇 〇 〇 〇 〇
COLUMNS 〇 〇 〇 〇 〇 〇 〇 〇
COMBIN 〇 〇 〇 〇 〇 〇 〇 〇
COMBINA × × × 〇 〇 〇 〇 〇
COMPLEX 〇 〇 〇 〇 〇 〇 〇 〇
CONCAT × × × × × 〇 〇 〇
CONCATENATE 〇 〇 〇 〇 〇 〇 〇 〇
CONFIDENCE 〇 〇 〇 〇 〇 〇 〇 〇
CONFIDENCE.NORM × × 〇 〇 〇 〇 〇 〇
CONFIDENCE.T × × 〇 〇 〇 〇 〇 〇
CONVERT 〇 〇 〇 〇 〇 〇 〇 〇
CORREL 〇 〇 〇 〇 〇 〇 〇 〇
COS 〇 〇 〇 〇 〇 〇 〇 〇
COSH 〇 〇 〇 〇 〇 〇 〇 〇
COT × × × 〇 〇 〇 〇 〇
COTH × × × 〇 〇 〇 〇 〇
COUNT 〇 〇 〇 〇 〇 〇 〇 〇
COUNTA 〇 〇 〇 〇 〇 〇 〇 〇
COUNTBLANK 〇 〇 〇 〇 〇 〇 〇 〇
COUNTIF 〇 〇 〇 〇 〇 〇 〇 〇
COUNTIFS × × 〇 〇 〇 〇 〇 〇
COUPDAYBS 〇 〇 〇 〇 〇 〇 〇 〇
COUPDAYS 〇 〇 〇 〇 〇 〇 〇 〇
COUPDAYSNC 〇 〇 〇 〇 〇 〇 〇 〇
COUPNCD 〇 〇 〇 〇 〇 〇 〇 〇
COUPNUM 〇 〇 〇 〇 〇 〇 〇 〇
COUPPCD 〇 〇 〇 〇 〇 〇 〇 〇
COVAR 〇 〇 〇 〇 〇 〇 〇 〇
COVARIANCE.P × × 〇 〇 〇 〇 〇 〇
COVARIANCE.S 〇 〇 〇 〇 〇 〇 〇 〇
CRITBINOM 〇 〇 〇 〇 〇 〇 〇 〇
BINOM.INV × × 〇 〇 〇 〇 〇 〇
CSC × × × 〇 〇 〇 〇 〇
CSCH × × × 〇 〇 〇 〇 〇
CUBEKPIMEMBER × 〇 〇 〇 〇 〇 〇 〇
CUBEMEMBER × 〇 〇 〇 〇 〇 〇 〇
CUBEMEMBERPROPERTY × 〇 〇 〇 〇 〇 〇 〇
CUBERANKEDMEMBER × 〇 〇 〇 〇 〇 〇 〇
CUBESET × 〇 〇 〇 〇 〇 〇 〇
CUBESETCOUNT × 〇 〇 〇 〇 〇 〇 〇
CUBEVALUE × 〇 〇 〇 〇 〇 〇 〇
CUMIPMT 〇 〇 〇 〇 〇 〇 〇 〇
CUMPRINC 〇 〇 〇 〇 〇 〇 〇 〇
DATE 〇 〇 〇 〇 〇 〇 〇 〇
DATEDIF × 〇 〇 〇 〇 〇 〇 〇
DATEVALUE 〇 〇 〇 〇 〇 〇 〇 〇
DAVERAGE 〇 〇 〇 〇 〇 〇 〇 〇
DAY 〇 〇 〇 〇 〇 〇 〇 〇
DAYS × × × 〇 〇 〇 〇 〇
DAYS360 〇 〇 〇 〇 〇 〇 〇 〇
DB 〇 〇 〇 〇 〇 〇 〇 〇
DBCS × × × 〇 〇 〇 〇 〇
DCOUNT 〇 〇 〇 〇 〇 〇 〇 〇
DCOUNTA 〇 〇 〇 〇 〇 〇 〇 〇
DDB 〇 〇 〇 〇 〇 〇 〇 〇
DEC2BIN 〇 〇 〇 〇 〇 〇 〇 〇
DEC2HEX 〇 〇 〇 〇 〇 〇 〇 〇
DEC2OCT 〇 〇 〇 〇 〇 〇 〇 〇
DECIMAL × × × 〇 〇 〇 〇 〇
DEGREES 〇 〇 〇 〇 〇 〇 〇 〇
DELTA 〇 〇 〇 〇 〇 〇 〇 〇
DEVSQ 〇 〇 〇 〇 〇 〇 〇 〇
DGET 〇 〇 〇 〇 〇 〇 〇 〇
DISC 〇 〇 〇 〇 〇 〇 〇 〇
DMAX 〇 〇 〇 〇 〇 〇 〇 〇
DMIN 〇 〇 〇 〇 〇 〇 〇 〇
DOLLAR 〇 〇 〇 〇 〇 〇 〇 〇
DOLLARDE 〇 〇 〇 〇 〇 〇 〇 〇
DOLLARFR 〇 〇 〇 〇 〇 〇 〇 〇
DROP × × × × × × × 〇
DSTDEV 〇 〇 〇 〇 〇 〇 〇 〇
DSTDEVP 〇 〇 〇 〇 〇 〇 〇 〇
DSUM 〇 〇 〇 〇 〇 〇 〇 〇
DURATION 〇 〇 〇 〇 〇 〇 〇 〇
DVAR 〇 〇 〇 〇 〇 〇 〇 〇
DVARP 〇 〇 〇 〇 〇 〇 〇 〇
EDATE 〇 〇 〇 〇 〇 〇 〇 〇
EFFECT 〇 〇 〇 〇 〇 〇 〇 〇
ENCODEURL × × × 〇 〇 〇 〇 〇
EOMONTH 〇 〇 〇 〇 〇 〇 〇 〇
ERF 〇 〇 〇 〇 〇 〇 〇 〇
ERF.PRECISE × × 〇 〇 〇 〇 〇 〇
ERFC 〇 〇 〇 〇 〇 〇 〇 〇
ERFC.PRECISE × × 〇 〇 〇 〇 〇 〇
ERROR.TYPE 〇 〇 〇 〇 〇 〇 〇 〇
EUROCONVERT 〇 〇 〇 〇 〇 〇 〇 〇
EVEN 〇 〇 〇 〇 〇 〇 〇 〇
EXACT 〇 〇 〇 〇 〇 〇 〇 〇
EXP 〇 〇 〇 〇 〇 〇 〇 〇
EXPAND × × × × × × × 〇
EXPONDIST 〇 〇 〇 〇 〇 〇 〇 〇
EXPON.DIST × × 〇 〇 〇 〇 〇 〇
F.DIST × × 〇 〇 〇 〇 〇 〇
F.INV × × 〇 〇 〇 〇 〇 〇
FTEST 〇 〇 〇 〇 〇 〇 〇 〇
F.TEST × × 〇 〇 〇 〇 〇 〇
FACT 〇 〇 〇 〇 〇 〇 〇 〇
FACTDOUBLE 〇 〇 〇 〇 〇 〇 〇 〇
FALSE 〇 〇 〇 〇 〇 〇 〇 〇
FDIST 〇 〇 〇 〇 〇 〇 〇 〇
F.DIST.RT × × 〇 〇 〇 〇 〇 〇
FILTER × × × × × × 〇 〇
FILTERXML × × × 〇 〇 〇 〇 〇
FIND 〇 〇 〇 〇 〇 〇 〇 〇
FINDB 〇 〇 〇 〇 〇 〇 〇 〇
FINV 〇 〇 〇 〇 〇 〇 〇 〇
F.INV.RT × × 〇 〇 〇 〇 〇 〇
FISHER 〇 〇 〇 〇 〇 〇 〇 〇
FISHERINV 〇 〇 〇 〇 〇 〇 〇 〇
FIXED 〇 〇 〇 〇 〇 〇 〇 〇
FLOOR 〇 〇 〇 〇 〇 〇 〇 〇
FLOOR.MATH × × × 〇 〇 〇 〇 〇
FLOOR.PRECISE × × 〇 〇 〇 〇 〇 〇
FORECAST 〇 〇 〇 〇 〇 〇 〇 〇
FORECAST.ETS × × × × 〇 〇 〇 〇
FORECAST.ETS.CONFINT × × × × 〇 〇 〇 〇
FORECAST.ETS.SEASONALITY × × × × 〇 〇 〇 〇
FORECAST.ETS.STAT × × × × 〇 〇 〇 〇
FORECAST.LINEAR × × × × 〇 〇 〇 〇
FORMULATEXT × × × 〇 〇 〇 〇 〇
FREQUENCY 〇 〇 〇 〇 〇 〇 〇 〇
FV 〇 〇 〇 〇 〇 〇 〇 〇
FVSCHEDULE 〇 〇 〇 〇 〇 〇 〇 〇
GAMMA × × × 〇 〇 〇 〇 〇
GAMMADIST 〇 〇 〇 〇 〇 〇 〇 〇
GAMMA.DIST × × 〇 〇 〇 〇 〇 〇
GAMMAINV 〇 〇 〇 〇 〇 〇 〇 〇
GAMMA.INV × × 〇 〇 〇 〇 〇 〇
GAMMALN 〇 〇 〇 〇 〇 〇 〇 〇
GAMMALN.PRECISE × × 〇 〇 〇 〇 〇 〇
GAUSS × × × 〇 〇 〇 〇 〇
GCD 〇 〇 〇 〇 〇 〇 〇 〇
GEOMEAN 〇 〇 〇 〇 〇 〇 〇 〇
GESTEP 〇 〇 〇 〇 〇 〇 〇 〇
GETPIVOTDATA × 〇 〇 〇 〇 〇 〇 〇
GROWTH 〇 〇 〇 〇 〇 〇 〇 〇
HARMEAN 〇 〇 〇 〇 〇 〇 〇 〇
HEX2BIN 〇 〇 〇 〇 〇 〇 〇 〇
HEX2DEC 〇 〇 〇 〇 〇 〇 〇 〇
HEX2OCT 〇 〇 〇 〇 〇 〇 〇 〇
HLOOKUP 〇 〇 〇 〇 〇 〇 〇 〇
HOUR 〇 〇 〇 〇 〇 〇 〇 〇
HSTACK × × × × × × × 〇
HYPERLINK 〇 〇 〇 〇 〇 〇 〇 〇
HYPGEOMDIST 〇 〇 〇 〇 〇 〇 〇 〇
HYPGEOM.DIST × × 〇 〇 〇 〇 〇 〇
IF 〇 〇 〇 〇 〇 〇 〇 〇
IFERROR × 〇 〇 〇 〇 〇 〇 〇
IFNA × × × 〇 〇 〇 〇 〇
IFS × × × × × 〇 〇 〇
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 × × × 〇 〇 〇 〇 〇
INDEX 〇 〇 〇 〇 〇 〇 〇 〇
INDIRECT 〇 〇 〇 〇 〇 〇 〇 〇
INFO 〇 〇 〇 〇 〇 〇 〇 〇
INT 〇 〇 〇 〇 〇 〇 〇 〇
INTERCEPT 〇 〇 〇 〇 〇 〇 〇 〇
INTRATE 〇 〇 〇 〇 〇 〇 〇 〇
IPMT 〇 〇 〇 〇 〇 〇 〇 〇
IRR 〇 〇 〇 〇 〇 〇 〇 〇
ISBLANK 〇 〇 〇 〇 〇 〇 〇 〇
ISERR 〇 〇 〇 〇 〇 〇 〇 〇
ISERROR 〇 〇 〇 〇 〇 〇 〇 〇
ISEVEN 〇 〇 〇 〇 〇 〇 〇 〇
ISFORMULA × × × 〇 〇 〇 〇 〇
ISLOGICAL 〇 〇 〇 〇 〇 〇 〇 〇
ISNA 〇 〇 〇 〇 〇 〇 〇 〇
ISNONTEXT 〇 〇 〇 〇 〇 〇 〇 〇
ISNUMBER 〇 〇 〇 〇 〇 〇 〇 〇
ISO.CEILING × × 〇 〇 〇 〇 〇 〇
ISODD 〇 〇 〇 〇 〇 〇 〇 〇
ISOMITTED × × × × × × × 〇
ISOWEEKNUM × × × 〇 〇 〇 〇 〇
ISPMT 〇 〇 〇 〇 〇 〇 〇 〇
ISREF 〇 〇 〇 〇 〇 〇 〇 〇
ISTEXT 〇 〇 〇 〇 〇 〇 〇 〇
JIS 〇 〇 〇 〇 〇 〇 〇 〇
KURT 〇 〇 〇 〇 〇 〇 〇 〇
LAMBDA × × × × × × × 〇
LARGE 〇 〇 〇 〇 〇 〇 〇 〇
LCM 〇 〇 〇 〇 〇 〇 〇 〇
LEFT 〇 〇 〇 〇 〇 〇 〇 〇
LEFTB 〇 〇 〇 〇 〇 〇 〇 〇
LEN 〇 〇 〇 〇 〇 〇 〇 〇
LENB 〇 〇 〇 〇 〇 〇 〇 〇
LET × × × × × × 〇 〇
LINEST 〇 〇 〇 〇 〇 〇 〇 〇
LN 〇 〇 〇 〇 〇 〇 〇 〇
LOG 〇 〇 〇 〇 〇 〇 〇 〇
LOG10 〇 〇 〇 〇 〇 〇 〇 〇
LOGEST 〇 〇 〇 〇 〇 〇 〇 〇
LOGINV 〇 〇 〇 〇 〇 〇 〇 〇
LOGNORM.INV × × 〇 〇 〇 〇 〇 〇
LOGNORMDIST 〇 〇 〇 〇 〇 〇 〇 〇
LOGNORM.DIST × × 〇 〇 〇 〇 〇 〇
LOOKUP 〇 〇 〇 〇 〇 〇 〇 〇
LOWER × × × × × × × 〇
MAKEARRAY × × × × × × × 〇
MAP × × × × × × × 〇
MATCH 〇 〇 〇 〇 〇 〇 〇 〇
MAX 〇 〇 〇 〇 〇 〇 〇 〇
MAXA 〇 〇 〇 〇 〇 〇 〇 〇
MAXIFS × × × × × 〇 〇 〇
MDETERM 〇 〇 〇 〇 〇 〇 〇 〇
MDURATION 〇 〇 〇 〇 〇 〇 〇 〇
MEDIAN 〇 〇 〇 〇 〇 〇 〇 〇
MID 〇 〇 〇 〇 〇 〇 〇 〇
MIDB 〇 〇 〇 〇 〇 〇 〇 〇
MIN 〇 〇 〇 〇 〇 〇 〇 〇
MINA 〇 〇 〇 〇 〇 〇 〇 〇
MINIFS × × × × × 〇 〇 〇
MINUTE 〇 〇 〇 〇 〇 〇 〇 〇
MINVERSE 〇 〇 〇 〇 〇 〇 〇 〇
MIRR 〇 〇 〇 〇 〇 〇 〇 〇
MMULT 〇 〇 〇 〇 〇 〇 〇 〇
MOD 〇 〇 〇 〇 〇 〇 〇 〇
MODE 〇 〇 〇 〇 〇 〇 〇 〇
MODE.SNGL × × 〇 〇 〇 〇 〇 〇
MODE.MULT × × 〇 〇 〇 〇 〇 〇
MONTH 〇 〇 〇 〇 〇 〇 〇 〇
MROUND 〇 〇 〇 〇 〇 〇 〇 〇
MULTINOMIAL 〇 〇 〇 〇 〇 〇 〇 〇
MUNIT × × × 〇 〇 〇 〇 〇
N 〇 〇 〇 〇 〇 〇 〇 〇
NA 〇 〇 〇 〇 〇 〇 〇 〇
NEGBINOMDIST 〇 〇 〇 〇 〇 〇 〇 〇
NEGBINOM.DIST × × 〇 〇 〇 〇 〇 〇
NETWORKDAYS 〇 〇 〇 〇 〇 〇 〇 〇
NETWORKDAYS.INTL × × 〇 〇 〇 〇 〇 〇
NOMINAL 〇 〇 〇 〇 〇 〇 〇 〇
NORMDIST 〇 〇 〇 〇 〇 〇 〇 〇
NORM.DIST × × 〇 〇 〇 〇 〇 〇
NORMINV 〇 〇 〇 〇 〇 〇 〇 〇
NORM.INV × × 〇 〇 〇 〇 〇 〇
NORMSDIST 〇 〇 〇 〇 〇 〇 〇 〇
NORM.S.DIST × × 〇 〇 〇 〇 〇 〇
NORMSINV 〇 〇 〇 〇 〇 〇 〇 〇
NORM.S.INV × × 〇 〇 〇 〇 〇 〇
NOT 〇 〇 〇 〇 〇 〇 〇 〇
NOW 〇 〇 〇 〇 〇 〇 〇 〇
NPER 〇 〇 〇 〇 〇 〇 〇 〇
NPV 〇 〇 〇 〇 〇 〇 〇 〇
NUMBERVALE 〇 〇 〇 〇 〇 〇 〇 〇
NUMBERVALUE × × × 〇 〇 〇 〇 〇
OCT2BIN 〇 〇 〇 〇 〇 〇 〇 〇
OCT2DEC 〇 〇 〇 〇 〇 〇 〇 〇
OCT2HEX 〇 〇 〇 〇 〇 〇 〇 〇
ODD 〇 〇 〇 〇 〇 〇 〇 〇
ODDFPRICE 〇 〇 〇 〇 〇 〇 〇 〇
ODDFYIELD 〇 〇 〇 〇 〇 〇 〇 〇
ODDLPRICE 〇 〇 〇 〇 〇 〇 〇 〇
ODDLYIELD 〇 〇 〇 〇 〇 〇 〇 〇
OFFSET 〇 〇 〇 〇 〇 〇 〇 〇
OR 〇 〇 〇 〇 〇 〇 〇 〇
PDURATION × × × 〇 〇 〇 〇 〇
PEARSON 〇 〇 〇 〇 〇 〇 〇 〇
PERCENTILE 〇 〇 〇 〇 〇 〇 〇 〇
PERCENTILE.INC × × 〇 〇 〇 〇 〇 〇
PERCENTILE.EXC × × 〇 〇 〇 〇 〇 〇
PERCENTRANK 〇 〇 〇 〇 〇 〇 〇 〇
PERCENTRANK.INC × × 〇 〇 〇 〇 〇 〇
PERCENTRANK.EXC × × 〇 〇 〇 〇 〇 〇
PERCENTRANK.INC × × 〇 〇 〇 〇 〇 〇
PERMUT 〇 〇 〇 〇 〇 〇 〇 〇
PERCENTRANK × × 〇 〇 〇 〇 〇 〇
PERMUTATIONA × × × 〇 〇 〇 〇 〇
PHI × × × 〇 〇 〇 〇 〇
PHONETIC 〇 〇 〇 〇 〇 〇 〇 〇
PI 〇 〇 〇 〇 〇 〇 〇 〇
PMT 〇 〇 〇 〇 〇 〇 〇 〇
POISSON 〇 〇 〇 〇 〇 〇 〇 〇
POISSON.DIST × × 〇 〇 〇 〇 〇 〇
POWER 〇 〇 〇 〇 〇 〇 〇 〇
PPMT 〇 〇 〇 〇 〇 〇 〇 〇
PRICE 〇 〇 〇 〇 〇 〇 〇 〇
PRICEDISC 〇 〇 〇 〇 〇 〇 〇 〇
PRICEMAT 〇 〇 〇 〇 〇 〇 〇 〇
PROB 〇 〇 〇 〇 〇 〇 〇 〇
PRODUCT 〇 〇 〇 〇 〇 〇 〇 〇
PROPER 〇 〇 〇 〇 〇 〇 〇 〇
PV 〇 〇 〇 〇 〇 〇 〇 〇
QUARTILE 〇 〇 〇 〇 〇 〇 〇 〇
QUARTILE.INC × × 〇 〇 〇 〇 〇 〇
QUARTILE.EXC × × 〇 〇 〇 〇 〇 〇
QUOTIENT 〇 〇 〇 〇 〇 〇 〇 〇
RADIANS 〇 〇 〇 〇 〇 〇 〇 〇
RAND 〇 〇 〇 〇 〇 〇 〇 〇
RANDARRAY × × × × × × 〇 〇
RANDBETWEEN 〇 〇 〇 〇 〇 〇 〇 〇
RANK 〇 〇 〇 〇 〇 〇 〇 〇
RANK.EQ × × 〇 〇 〇 〇 〇 〇
RANK.AVG × × 〇 〇 〇 〇 〇 〇
RATE 〇 〇 〇 〇 〇 〇 〇 〇
RECEIVED 〇 〇 〇 〇 〇 〇 〇 〇
REDUCE × × × × × × × 〇
REGISTER.ID 〇 〇 〇 〇 〇 〇 〇 〇
REPLACE 〇 〇 〇 〇 〇 〇 〇 〇
REPLACEB 〇 〇 〇 〇 〇 〇 〇 〇
REPT 〇 〇 〇 〇 〇 〇 〇 〇
RIGHT 〇 〇 〇 〇 〇 〇 〇 〇
RIGHTB 〇 〇 〇 〇 〇 〇 〇 〇
ROMAN 〇 〇 〇 〇 〇 〇 〇 〇
ROUND 〇 〇 〇 〇 〇 〇 〇 〇
ROUNDDOWN 〇 〇 〇 〇 〇 〇 〇 〇
ROUNDUP 〇 〇 〇 〇 〇 〇 〇 〇
ROW 〇 〇 〇 〇 〇 〇 〇 〇
ROWS 〇 〇 〇 〇 〇 〇 〇 〇
RRI × × × 〇 〇 〇 〇 〇
RSQ 〇 〇 〇 〇 〇 〇 〇 〇
RTD 〇 〇 〇 〇 〇 〇 〇 〇
SCAN × × × × × × × 〇
SEARCH 〇 〇 〇 〇 〇 〇 〇 〇
SEARCHB 〇 〇 〇 〇 〇 〇 〇 〇
SEC × × × 〇 〇 〇 〇 〇
SECH × × × 〇 〇 〇 〇 〇
SECOND 〇 〇 〇 〇 〇 〇 〇 〇
SEQUENCE × × × × × × 〇 〇
SERIESSUM 〇 〇 〇 〇 〇 〇 〇 〇
SHEET × × × 〇 〇 〇 〇 〇
SHEETS × × × 〇 〇 〇 〇 〇
SIGN 〇 〇 〇 〇 〇 〇 〇 〇
SIN 〇 〇 〇 〇 〇 〇 〇 〇
SINH 〇 〇 〇 〇 〇 〇 〇 〇
SKEW 〇 〇 〇 〇 〇 〇 〇 〇
SKEW.P × × × 〇 〇 〇 〇 〇
SLOPE 〇 〇 〇 〇 〇 〇 〇 〇
SLOPE 〇 〇 〇 〇 〇 〇 〇 〇
SMALL 〇 〇 〇 〇 〇 〇 〇 〇
SORT × × × × × × 〇 〇
SORTBY × × × × × × 〇 〇
SQRT 〇 〇 〇 〇 〇 〇 〇 〇
SQRTPI 〇 〇 〇 〇 〇 〇 〇 〇
STANDARDIZE 〇 〇 〇 〇 〇 〇 〇 〇
STDEV 〇 〇 〇 〇 〇 〇 〇 〇
STDEV.S × × 〇 〇 〇 〇 〇 〇
STDEVA 〇 〇 〇 〇 〇 〇 〇 〇
STDEVP 〇 〇 〇 〇 〇 〇 〇 〇
STDEV.P × × 〇 〇 〇 〇 〇 〇
STDEVPA 〇 〇 〇 〇 〇 〇 〇 〇
STEYX 〇 〇 〇 〇 〇 〇 〇 〇
SUBSTITUTE 〇 〇 〇 〇 〇 〇 〇 〇
SUBTOTAL 〇 〇 〇 〇 〇 〇 〇 〇
SUM 〇 〇 〇 〇 〇 〇 〇 〇
SUMIF 〇 〇 〇 〇 〇 〇 〇 〇
SUMIFS × 〇 〇 〇 〇 〇 〇 〇
SUMPRODUCT 〇 〇 〇 〇 〇 〇 〇 〇
SUMSQ 〇 〇 〇 〇 〇 〇 〇 〇
SUMX2MY2 〇 〇 〇 〇 〇 〇 〇 〇
SUMX2PY2 〇 〇 〇 〇 〇 〇 〇 〇
SUMXMY2 〇 〇 〇 〇 〇 〇 〇 〇
SWITCH × × × × × 〇 〇 〇
SYD 〇 〇 〇 〇 〇 〇 〇 〇
T 〇 〇 〇 〇 〇 〇 〇 〇
T.DIST × × 〇 〇 〇 〇 〇 〇
T.INV × × 〇 〇 〇 〇 〇 〇
TAKE × × × × × × × 〇
TAN 〇 〇 〇 〇 〇 〇 〇 〇
TANH 〇 〇 〇 〇 〇 〇 〇 〇
TBILLEQ 〇 〇 〇 〇 〇 〇 〇 〇
TBILLPRICE 〇 〇 〇 〇 〇 〇 〇 〇
TBILLYIELD 〇 〇 〇 〇 〇 〇 〇 〇
TDIST 〇 〇 〇 〇 〇 〇 〇 〇
T.DIST.2T × × 〇 〇 〇 〇 〇 〇
T.DIST.RT × × 〇 〇 〇 〇 〇 〇
TEXT 〇 〇 〇 〇 〇 〇 〇 〇
TEXTAFTER × × × × × × × 〇
TEXTBEFORE × × × × × × × 〇
TEXTJOIN × × × × × 〇 〇 〇
TEXTSPLIT × × × × × × × 〇
TIME 〇 〇 〇 〇 〇 〇 〇 〇
TIMEVALUE 〇 〇 〇 〇 〇 〇 〇 〇
TINV 〇 〇 〇 〇 〇 〇 〇 〇
T.INV.2T × × 〇 〇 〇 〇 〇 〇
TOCOL × × × × × × × 〇
TODAY 〇 〇 〇 〇 〇 〇 〇 〇
TOROW × × × × × × × 〇
TRANSPOSE 〇 〇 〇 〇 〇 〇 〇 〇
TREND 〇 〇 〇 〇 〇 〇 〇 〇
TRIM 〇 〇 〇 〇 〇 〇 〇 〇
TRIMMEAN 〇 〇 〇 〇 〇 〇 〇 〇
TRUNC 〇 〇 〇 〇 〇 〇 〇 〇
TTEST 〇 〇 〇 〇 〇 〇 〇 〇
T.TEST × × 〇 〇 〇 〇 〇 〇
TRUE 〇 〇 〇 〇 〇 〇 〇 〇
TYPE 〇 〇 〇 〇 〇 〇 〇 〇
UNICHAR × × × 〇 〇 〇 〇 〇
UNICODE × × × 〇 〇 〇 〇 〇
UNIQUE × × × × × × 〇 〇
UPPER 〇 〇 〇 〇 〇 〇 〇 〇
VALUE 〇 〇 〇 〇 〇 〇 〇 〇
VALUETOTEXT × × × × × × × 〇
VAR 〇 〇 〇 〇 〇 〇 〇 〇
VAR.S × × 〇 〇 〇 〇 〇 〇
VARA 〇 〇 〇 〇 〇 〇 〇 〇
VARP 〇 〇 〇 〇 〇 〇 〇 〇
VAR.P × × 〇 〇 〇 〇 〇 〇
VARPA 〇 〇 〇 〇 〇 〇 〇 〇
VDB 〇 〇 〇 〇 〇 〇 〇 〇
VLOOKUP 〇 〇 〇 〇 〇 〇 〇 〇
VSTACK × × × × × × × 〇
WEBSERVICE × × × 〇 〇 〇 〇 〇
WEEKDAY 〇 〇 〇 〇 〇 〇 〇 〇
WEEKNUM 〇 〇 〇 〇 〇 〇 〇 〇
WEIBULL 〇 〇 〇 〇 〇 〇 〇 〇
WEIBULL.DIST × × 〇 〇 〇 〇 〇 〇
WORKDAY 〇 〇 〇 〇 〇 〇 〇 〇
WORKDAY.INTL × × 〇 〇 〇 〇 〇 〇
WRAPCOLS × × × × × × × 〇
WRAPROWS × × × × × × × 〇
XIRR 〇 〇 〇 〇 〇 〇 〇 〇
XLOOKUP × × × × × × 〇 〇
XMATCH × × × × × × 〇 〇
XNPV 〇 〇 〇 〇 〇 〇 〇 〇
XOR × × × 〇 〇 〇 〇 〇
YEAR 〇 〇 〇 〇 〇 〇 〇 〇
YEARFRAO 〇 〇 〇 〇 〇 〇 〇 〇
YEN 〇 〇 〇 〇 〇 〇 〇 〇
YIELD 〇 〇 〇 〇 〇 〇 〇 〇
YIELDDISC 〇 〇 〇 〇 〇 〇 〇 〇
YIELDMAT 〇 〇 〇 〇 〇 〇 〇 〇
ZTEST 〇 〇 〇 〇 〇 〇 〇 〇
Z.TEST × × 〇 〇 〇 〇 〇 〇

関数一覧のダウンロード

Excelでダウンロードする際は「関数一覧Excel2003-Office365」のボタンをクリックしてください。

関数一覧Excel2003-Office365

 

↓当ブログは、ブログ村参加中です！　よろしかったらポチッと協力お願いします。↓

　　　　　　　　　　　　　　　　にほんブログ村 IT技術ブログ IT技術メモへ

スポンサーリンク

コメント

タイトルとURLをコピーしました