[{"id":"7720ca38-fc98-4fd8-a3a5-3c0e730c3c72","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"247ded67-b050-4436-be40-fe7b0eeabef7","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"9a8c377f-1f1e-476e-b487-c2339da9bed3","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"5e8e6db2-89b9-4184-bbdc-301ee676869e","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"e04b598e-b0d8-4054-bdac-5143d90b3d51","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"edb028d0-a8cc-42b2-acda-42a5515729f0","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"2adde444-20a6-43d7-8896-2b445877327a","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"6ab8ced2-6c7a-41b6-b861-ba066bd40f40","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"0c34aedd-80a3-470b-a0f6-c327a4346be7","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"717a5892-fa23-499b-a61d-cff228943aaf","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"bd9be971-69fc-4793-ad6d-234be7a93048","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"a1e8d38f-43d8-4b3e-b747-3fbf7656fcd9","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"d6995fdf-76ee-421f-9e7a-3fb324d14bbb","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"64fa3155-4543-4acd-83b7-f9860fd46673","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"698413bd-0b16-4287-baec-644d98a411d1","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"7e4393a0-21ef-438b-981b-325b64db5baa","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]}]
        
(Showing Draft Content)

関数の一覧

ここでは、Spreadの備える組み込み関数をアルファベット順に一覧表示します。

ABS ACCRINT ACCRINTM
ACOS ACOSH ACOT
ACOTH ADDRESS AGGREGATE
AMORDEGRC AMORLINC AND
ARABIC AREAS 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 BINOMDIST BINOM.DIST
BINOM.DIST.RANGE BINOM.INV BITAND
BITLSHIFT BITOR BITRSHIFT
BITXOR CALCULATE CEILING
CEILING.MATH CEILING.PRECISE CHAR
CHIDIST CHIINV CHISQ.DIST
CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT
CHISQ.TEST CHITEST 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 CSC
CSCH CUMIPMT CUMPRINC
DATE DATEDIF DATEPART
DATEVALUE DAVERAGE DAY
DAYS DAYS360 DB
DCOUNT DCOUNTA DDB
DEC2BIN DEC2HEX DEC2OCT
DECIMAL DEGREES DELTA
DEVSQ DGET DISC
DMAX DMIN DOLLAR
DOLLARDE DOLLARFR DPRODUCT
DROP DSTDEV DSTDEVP
DSUM DURATION DVAR
DVARP EDATE EFFECT
ENCODEURL EOMONTH ERF
ERF.PRECISE ERF.PRECISE ERFC
ERFC.PRECISE ERROR.TYPE EURO
EUROCONVERT EVEN EXACT
EXP EXPAND EXPONDIST
EXPON.DIST
FACT FACTDOUBLE FALSE
FDIST F.DIST F.DIST.RT
FIND FINDB FINV
F.INV F.INV.RT FILTER
FILTERJSON FISHER FISHERINV
FIXED FLOOR FLOOR.MATH
FLOOR.PRECISE FORECAST FORMULATEXT
FREQUENCY FTEST F.TEST
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 IFS
IFNA IMABS IMAGINARY
IMARGUMENT IMCONJUGATE IMCOS
IMDIV IMEXP IMLN
IMLOG2 IMLOG10 IMPOWER
IMPRODUCT IMREAL IMCOSH
IMCOT IMCSC IMCSCH
IMSEC IMSECH IMSIN
IMSINH IMSQRT IMSUB
IMSUM IMTAN INDEX
INDIRECT INT INTERCEPT
INTRATE IPMT IRR
ISBLANK ISERR ISERROR
ISEVEN ISFORMULA ISLOGICAL
ISNA ISNONTEXT ISNUMBER
ISO.CEILING ISODD ISOWEEKNUM
ISPMT ISREF ISTEXT
KURT LARGE LCM
LEFT LEFTB LEN
LENB LINEST LN
LOG LOG10 LOGEST
LOGINV LOGNORMDIST LOGNORM.DIST
LOGNORM.INV LOOKUP LOWER
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 NEGBINOMDIST
NEGBINOM.DIST N NA
NETWORKDAYS NETWORKDAYS.INTL NOMINAL
NORMDIST NORM.DIST NORMINV
NORM.INV NORMSDIST NORM.S.DIST
NORMSINV NORM.S.INV NOT
NOW NPER NPV
OCT2BIN OCT2DEC OCT2HEX
ODD ODDFPRICE ODDFYIELD
ODDLPRICE ODDLYIELD OFFSET
OR OFFSET
PDURATION PEARSON PERCENTILE
PERCENTILE.EXC PERCENTILE.INC PERCENTRANK
PERCENTRANK.EXC PERCENTRANK.INC PERMUT
PERMUTATIONA PHI PI
PMT POISSON POISSON.DIST
POWER PPMT PRICE
PRICEDISC PRICEMAT PROB
PRODUCT PROPER PV
QUARTILE QUARTILE.EXC QUARTILE.INC
QUERY QUOTIENT RADIANS
RAND RANDBETWEEN RANK
RANK.AVG RANK.EQ RATE
RECEIVED REFRESH REMOVEFILTERS
REPLACE REPLACEB REPT
RIGHT RIGHTB ROMAN
ROUND ROUNDDOWN ROUNDUP
ROW ROWS RRI
RSQ
SEARCH SEARCHB SEC
SECH SECOND SERIESSUM
SIGN SIN SINH
SKEW SKEW.P SLN
SLOPE SMALL SQRT
SQRTPI STANDARDIZE STDEV
STDEVA STDEVP STDEV.P
STDEVPA STDEV.S STEYX
SUBSTITUTE SUBTOTAL SUM
SUMIF SUMIFS SUMPRODUCT
SUMSQ SUMX2MY2 SUMX2PY2
SUMXMY2 SYD SWITCH
T TAKE TAN
TANH TBILLEQ TBILLPRICE
TBILLYIELD TDIST T.DIST
T.DIST.2T T.DIST.RT TEXT
TEXTAFTER TEXTBEFORE TEXTJOIN
TEXTSPLIT TIME TIMEVALUE
TINV T.INV T.INV.2T
TOCOL TODAY TOROW
TRANSPOSE TREND TRIM
TRIMMEAN TRUE TRUNC
TTEST T.TEST TYPE
UPPER UNICHAR UNICODE
VALUE VAR VARA
VARP VAR.P VARPA
VAR.S VDB VLOOKUP
VSTACK WEBSERVICE WEEKDAY
WEEKNUM WEIBULL WEIBULL.DIST
WORKDAY WORKDAY.INTL WRAPCOLS
WRAPROWS XIRR XNPV
XOR YEAR YEARFRAC
YIELD YIELDDISC YIELDMAT
ZTEST Z.TEST