参考: カテゴリ別の Worksheets 関数

以下の表では、Worksheets 関数をカテゴリ別に一覧表示しています。"関数ライブラリ" パネルに関数を表示する場合、名前の左側にあるアイコンでカテゴリを識別できます。

Workday 管理者ガイドでは、Worksheets 固有の関数について説明します。Worksheets ユーザーガイドでは、Worksheets のすべての関数について説明します。

関数のタイプ	関数
配列	CHOOSECOLS CHOOSEROWS DROP EXPAND FILTER HSTACK MS.SORT MS.UNIQUE MS.UNIQUE2 RANDARRAY SEQUENCE SORTBY TAKE TOROW TOCOL VSTACK WRAPROWS WRAPCOLS XLOOKUP XMATCH
日付	CONVERTTZ DATE DATESBETWEEN DATESFROM DATETIME DATEVALUE DAY DAYNAME DAYS DAYS360 DUR2DAYS DUR2HOURS DUR2MILLISECONDS DUR2MINUTES DUR2SECONDS DUR2WEEKS DURATIONVALUE EDATE EOMONTH HOUR ISOWEEKNUM MINUTE MONTH MONTHNAME NETWORKDAYS NETWORKDAYS.INTL NOW NOWTZ SECOND TIME TIMEVALUE TODAY WD.DATEDIF WEEKDAY WEEKNUM WORKDAY WORKDAY.INTL YEAR YEARFRAC
エンジニアリング	BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT BITAND BITLSHIFT BITOR BITRSHIFT BITXOR COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA DIMENSIONS ERF ERF.PRECISE ERFC ERFC.PRECISE GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMCOSH IMCOT IMCOTH IMCSC IMCSCH IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSEC IMSECH IMSIN IMSINH IMSQRT IMSUB IMSUM IMTAN IMTANH OCT2BIN OCT2DEC OCT2HEX SETUNITS UNITS
財務	ACCRINT ACCRINTM AMORDEGRC AMORLINC BONDDURATION BONDMDURATION COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFYIELD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED RRI SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT
情報	ERROR.TYPE INFO ISBLANK ISBOOLEAN ISERR ISERROR ISEVEN ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE
リスト	WD.LIST.GET WD.LIST.LIST WD.LIST.SIZE
論理	AND FALSE IF IFEMPTY IFERROR IFNA NOT OR SWITCH TRUE XOR
ルックアップ	ADDRESS AREAS ARRAYAREA CHOOSE COLUMN COLUMNS FORMULATEXT HLOOKUP IN INDEX INDIRECT LOOKUP MATCH MATCHEXACT MHLOOKUP MVLOOKUP OFFSET ROW ROWS VLOOKUP WD.MVLOOKUP WD.VLOOKUP
数学	ABS ACOS ACOSH ACOT ARABIC ASIN ATAN ATAN2 ATANH BASE BASETONUM CBRT CEILING CEILING.MATH CEILING.PRECISE COMBIN COMBINA COS COSH COT COTH CSC CSCH DECIMAL DEGREES E EVEN EXP EXPM1 EXPONENT FACT FACTDOUBLE FLOOR FLOOR.MATH FLOOR.PRECISE GCD HYPOT INT ISO.CEILING ISOCEILING LCM LN LOG LOG10 LOG1P MAXIFS MDETERM MINIFS MOD MROUND MULTINOMIAL ODD パーセント PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN RANDCONST RINT ROMAN ROUND ROUNDDOWN ROUNDUP SEC SECH SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC WD.AVERAGEIFS WD.MAXIF WD.MAXIFS WD.MINIF WD.MINIFS WD.SUMIF WD.SUMIFS
行列	MIDENTITY MMULT MUNIT TRANSPOSE TRUNCATEMATRIX
その他	BYCOL 送信 CAPPEDVALUES CELL CLUSTER.KMEANS CLUSTER.KMEANS.CENTROIDS CORRELATE DISTINCTROWS DISTINCTROWS2 EMAIL GROUPBY HYPERLINK INSTANCE INSTANCE.DESCRIPTOR INSTANCE.ID 無視済 JOIN LAMBDA LET MA繰越 MAP MATCHCOMPOSITE MERGECOLUMNS MERGEROWS MI.COUNT MI.INDEX MINUS MS.GROUPBY MULTIINST NOTIFYIF NOTIFYIFS PIVOTBY 削減 REMOVECOLUMNS REMOVEROWS SCAN SELECT SORT SORT2 SORT3 TRIMCOLUMNS トリミング TRIMROWS UNIQUE UNIQUE2 URL URLTEXT WD.ARRANGECOLUMNS WD.ARRANGEROWS WD.EXCHANGE WD.GROUPBY WD.LIVEDATA WD.PIVOTBY WD.SLICE
演算子	ADD COMPARE DIVIDE EQ GT GTE LT LTE MULTIPLY NE POW SUBTRACT UMINUS UNARY_PERCENT UPLUS
統計	AGGREGATE AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BINOM.DIST BINOM.INV BINOMDIST BINOMINV CHIDIST CHISQ.DIST CHISQ.DIST.RT CHISQDIST CHISQDISTRT CONFIDENCE CONFIDENCE.NORM CONFIDENCE.T CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVARIANCE.P COVARIANCE.S COVARIANCEP COVARIANCES CRITBINOM DEVSQ EXPON.DIST EXPONDIST FISHER FISHERINV FORECAST FORECAST.WD.SEASONAL FREQUENCY GAMMALN GAMMALN.PRECISE GAUSS GEOMEAN GROWTH HARMEAN HYPGEOM.DIST HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGINV LOGNORM.DIST LOGNORM.INV LOGNORMDIST LOGNORMINV MAX MAXA MEDIAN MIN MINA MODE MODE.MULT MODE.SNGL NEGBINOM.DIST NEGBINOMDIST NORM.DIST NORM.INV NORM.S.DIST NORM.S.INV NORMDIST NORMINV NORMSDIST NORMSINV PEARSON PERCENTILE PERCENTILE.EXC PERCENTILE.INC PERCENTRANK PERCENTRANK.INC PERMUT PERMUTATIONA PHI POISSON POISSON.DIST QUARTILE QUARTILE.EXC QUARTILE.INC RANK RANK.AVG RANK.EQ RANKAVG RANKEQ RSQ SLOPE SMALL STANDARDIZE STDEV STDEV.P STDEV.S STDEVP STDEVS T.DIST T.DIST.RT T.INV TDIST TDISTRT TINV TRIMMEAN VAR VAR.P VARA VARP VARPA WD.AVERAGEIF WD.COUNTIF WD.COUNTIFS WEIBULL WEIBULL.DIST WEIBULLDIST Z.TEST ZTEST
テキスト	ARRAYTOTEXT ASC CHAR CLEAN CODE CONCAT CONCATENATE ENCODEURL EXACT FIND FIXED LEFT LEN LOWER MID MS.REGEXTRACT MS.REGEXREPLACE MS.REGEXTEST PROPER REGEXEXTRACT REGEXFIND REGEXMATCH REGEXPARSE REGEXREPLACE 評価 REPLACE REPT RIGHT SEARCH SPLIT SUBSTITUTE T TEXT TEXTAFTER TEXTBEFORE TEXTJOIN TEXTSPLIT TRIM UNICHAR UNICODE UPPER VALUE UEVALTOTEXT WD.HALFTOFULL WD.FULLTOHALF
テーブル	FLATTEN VALUEAT