ダッシュボード・自在モードで利用できる関数について

利用方法

MicrosoftOfficeのExcel関数のと同じような挙動を致します。
公開されているドキュメントとともに併せてご活用ください。

Excelにあって使えない関数(確認済みのもののみ抜粋)

‘VLOOKUP’

利用できる関数の一覧

‘ABS’, ‘ACCRINT’, ‘ACOS’, ‘ACOSH’, ‘ACOT’, ‘ACOTH’, ‘ADD’, ‘AGGREGATE’, ‘AND’, ‘ARABIC’,
‘ARGS2ARRAY’, ‘ASIN’, ‘ASINH’, ‘ATAN’, ‘ATAN2’, ‘ATANH’, ‘AVEDEV’, ‘AVERAGE’, ‘AVERAGEA’,
‘AVERAGEIF’, ‘AVERAGEIFS’, ‘BASE’, ‘BESSELI’, ‘BESSELJ’, ‘BESSELK’, ‘BESSELY’, ‘BETA.DIST’,
‘BETA.INV’, ‘BETADIST’, ‘BETAINV’, ‘BIN2DEC’, ‘BIN2HEX’, ‘BIN2OCT’, ‘BINOM.DIST’,
‘BINOM.DIST.RANGE’, ‘BINOM.INV’, ‘BINOMDIST’, ‘BITAND’, ‘BITLSHIFT’, ‘BITOR’, ‘BITRSHIFT’,
‘BITXOR’, ‘CEILING’, ‘CEILINGMATH’, ‘CEILINGPRECISE’, ‘CHAR’, ‘CHISQ.DIST’, ‘CHISQ.DIST.RT’,
‘CHISQ.INV’, ‘CHISQ.INV.RT’, ‘CHOOSE’, ‘CHOOSE’, ‘CLEAN’, ‘CODE’, ‘COLUMN’, ‘COLUMNS’,
‘COMBIN’, ‘COMBINA’, ‘COMPLEX’, ‘CONCATENATE’, ‘CONFIDENCE’, ‘CONFIDENCE.NORM’, ‘CONFIDENCE.T’,
‘CONVERT’, ‘CORREL’, ‘COS’, ‘COSH’, ‘COT’, ‘COTH’, ‘COUNT’, ‘COUNTA’, ‘COUNTBLANK’, ‘COUNTIF’,
‘COUNTIFS’, ‘COUNTIN’, ‘COUNTUNIQUE’, ‘COVARIANCE.P’, ‘COVARIANCE.S’, ‘CSC’, ‘CSCH’, ‘CUMIPMT’,
‘CUMPRINC’, ‘DATE’, ‘DATEVALUE’, ‘DAY’, ‘DAYS’, ‘DAYS360’, ‘DB’, ‘DDB’, ‘DEC2BIN’, ‘DEC2HEX’,
‘DEC2OCT’, ‘DECIMAL’, ‘DEGREES’, ‘DELTA’, ‘DEVSQ’, ‘DIVIDE’, ‘DOLLAR’, ‘DOLLARDE’, ‘DOLLARFR’,
‘E’, ‘EDATE’, ‘EFFECT’, ‘EOMONTH’, ‘EQ’, ‘ERF’, ‘ERFC’, ‘EVEN’, ‘EXACT’, ‘EXP’, ‘EXPON.DIST’,
‘EXPONDIST’, ‘F.DIST’, ‘F.DIST.RT’, ‘F.INV’, ‘F.INV.RT’, ‘FACT’, ‘FACTDOUBLE’, ‘FALSE’,
‘FDIST’, ‘FDISTRT’, ‘FIND’, ‘FINV’, ‘FINVRT’, ‘FISHER’, ‘FISHERINV’, ‘FIXED’, ‘FLATTEN’,
‘FLOOR’, ‘FORECAST’, ‘FREQUENCY’, ‘FV’, ‘FVSCHEDULE’, ‘GAMMA’, ‘GAMMA.DIST’, ‘GAMMA.INV’,
‘GAMMADIST’, ‘GAMMAINV’, ‘GAMMALN’, ‘GAMMALN.PRECISE’, ‘GAUSS’, ‘GCD’, ‘GEOMEAN’, ‘GESTEP’,
‘GROWTH’, ‘GTE’, ‘HARMEAN’, ‘HEX2BIN’, ‘HEX2DEC’, ‘HEX2OCT’, ‘HOUR’, ‘HTML2TEXT’,
‘HYPGEOM.DIST’, ‘HYPGEOMDIST’, ‘IF’, ‘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’, ‘INT’, ‘INTERCEPT’, ‘INTERVAL’, ‘IPMT’, ‘IRR’, ‘ISBINARY’, ‘ISBLANK’,
‘ISEVEN’, ‘ISLOGICAL’, ‘ISNONTEXT’, ‘ISNUMBER’, ‘ISODD’, ‘ISODD’, ‘ISOWEEKNUM’, ‘ISPMT’,
‘ISTEXT’, ‘JOIN’, ‘KURT’, ‘LARGE’, ‘LCM’, ‘LEFT’, ‘LEN’, ‘LINEST’, ‘LN’, ‘LOG’, ‘LOG10’,
‘LOGEST’, ‘LOGNORM.DIST’, ‘LOGNORM.INV’, ‘LOGNORMDIST’, ‘LOGNORMINV’, ‘LOWER’, ‘LT’, ‘LTE’,
‘MATCH’, ‘MAX’, ‘MAXA’, ‘MEDIAN’, ‘MID’, ‘MIN’, ‘MINA’, ‘MINUS’, ‘MINUTE’, ‘MIRR’, ‘MOD’,
‘MODE.MULT’, ‘MODE.SNGL’, ‘MODEMULT’, ‘MODESNGL’, ‘MONTH’, ‘MROUND’, ‘MULTINOMIAL’, ‘MULTIPLY’,
‘NE’, ‘NEGBINOM.DIST’, ‘NEGBINOMDIST’, ‘NETWORKDAYS’, ‘NOMINAL’, ‘NORM.DIST’, ‘NORM.INV’,
‘NORM.S.DIST’, ‘NORM.S.INV’, ‘NORMDIST’, ‘NORMINV’, ‘NORMSDIST’, ‘NORMSINV’, ‘NOT’, ‘NOW’,
‘NPER’, ‘NPV’, ‘NUMBERS’, ‘NUMERAL’, ‘OCT2BIN’, ‘OCT2DEC’, ‘OCT2HEX’, ‘ODD’, ‘OR’, ‘PDURATION’,
‘PEARSON’, ‘PERCENTILEEXC’, ‘PERCENTILEINC’, ‘PERCENTRANKEXC’, ‘PERCENTRANKINC’, ‘PERMUT’,
‘PERMUTATIONA’, ‘PHI’, ‘PI’, ‘PMT’, ‘POISSON.DIST’, ‘POISSONDIST’, ‘POW’, ‘POWER’, ‘PPMT’,
‘PROB’, ‘PRODUCT’, ‘PROPER’, ‘PV’, ‘QUARTILE.EXC’, ‘QUARTILE.INC’, ‘QUARTILEEXC’, ‘QUARTILEINC’,
‘QUOTIENT’, ‘RADIANS’, ‘RAND’, ‘RANDBETWEEN’, ‘RANK.AVG’, ‘RANK.EQ’, ‘RANKAVG’, ‘RANKEQ’,
‘RATE’, ‘REFERENCE’, ‘REGEXEXTRACT’, ‘REGEXMATCH’, ‘REGEXREPLACE’, ‘REPLACE’, ‘REPT’, ‘RIGHT’,
‘ROMAN’, ‘ROUND’, ‘ROUNDDOWN’, ‘ROUNDUP’, ‘ROW’, ‘ROWS’, ‘RRI’, ‘RSQ’, ‘SEARCH’, ‘SEC’, ‘SECH’,
‘SECOND’, ‘SERIESSUM’, ‘SIGN’, ‘SIN’, ‘SINH’, ‘SKEW’, ‘SKEW.P’, ‘SKEWP’, ‘SLN’, ‘SLOPE’, ‘SMALL’,
‘SPLIT’, ‘SPLIT’, ‘SQRT’, ‘SQRTPI’, ‘STANDARDIZE’, ‘STDEV.P’, ‘STDEV.S’, ‘STDEVA’, ‘STDEVP’,
‘STDEVPA’, ‘STDEVS’, ‘STEYX’, ‘SUBSTITUTE’, ‘SUBTOTAL’, ‘SUM’, ‘SUMIF’, ‘SUMIFS’, ‘SUMPRODUCT’,
‘SUMSQ’, ‘SUMX2MY2’, ‘SUMX2PY2’, ‘SUMXMY2’, ‘SWITCH’, ‘SYD’, ‘T’, ‘T.DIST’, ‘T.DIST.2T’,
‘T.DIST.RT’, ‘T.INV’, ‘T.INV.2T’, ‘TAN’, ‘TANH’, ‘TBILLEQ’, ‘TBILLPRICE’, ‘TBILLYIELD’,
‘TDIST’, ‘TDIST2T’, ‘TDISTRT’, ‘TEXT’, ‘TIME’, ‘TIMEVALUE’, ‘TINV’, ‘TINV2T’, ‘TODAY’, ‘TRANSPOSE’,
‘TREND’, ‘TRIM’, ‘TRIMMEAN’, ‘TRUE’, ‘TRUNC’, ‘UNICHAR’, ‘UNICODE’, ‘UNIQUE’, ‘UPPER’, ‘VALUE’,
‘VAR.P’, ‘VAR.S’, ‘VARA’, ‘VARP’, ‘VARPA’, ‘VARS’, ‘WEEKDAY’, ‘WEEKNUM’, ‘WEIBULL.DIST’,
‘WEIBULLDIST’, ‘WORKDAY’, ‘XIRR’, ‘XNPV’, ‘XOR’, ‘YEAR’, ‘YEARFRAC’

このエントリーをはてなブックマークに追加

サポートページで解決できない場合

お問い合わせ

お客様のトラブルを効率よく解決するため、お問い合わせ前にこちらをご一読ください