ここでは、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