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

種類別の関数一覧については、「関数の種類」を参照してください。

関数 A から C

ABS	ACCRINT	ACCRINTM	ACOS
ACOSH	ACOT	ACOTH	ADDRESS
AGGREGATE	AMORDEGRC	AMORLINC	ANCHORARRAY
AND	ARABIC	AREAS	ARRAYTOTEXT
ASC	ASIN	ASINH	ATAN
ATAN2	ATANH	AVEDEV	AVERAGE
AVERAGEA	AVERAGEIF	AVERAGEIFS	BAHTTEXT
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	BYCOL	BYROW	CEILING
CEILING.MATH	CEILING.PRECISE	CELL	CHAR
CHIDIST	CHIINV	CHISQ.DIST	CHISQ.DIST.RT
CHISQ.INV	CHISQ.INV.RT	CHISQ.TEST	CHITEST
CHOOSE	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

関数 D から G

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	DPRODUCT	DSTDEV
DSTDEVP	DSUM	DURATION	DVAR
DVARP	EDATE	EFFECT	ENCODEURL
EOMONTH	ERF	ERF.PRECISE	ERFC
ERFC.PRECISE	ERROR.TYPE	ERRORTYPE	EVEN
EXACT	EXP	EXPON.DIST	EXPONDIST
F.DIST	F.DIST.RT	F.INV	F.INV.RT
F.TEST	FACT	FACTDOUBLE	FALSE
FDIST	FIELDVALUE	FILTER	FILTERXML
FIND	FINDB	FINV	FISHER
FISHERINV	FIXED	FLOOR	FLOOR.MATH
FLOOR.PRECISE	FORECAST	FORECAST.LINEAR	FORMULATEXT
FREQUENCY	FTEST	FV	FVSCHEDULE
GAMMA	GAMMA.DIST	GAMMA.INV	GAMMADIST
GAMMAINV	GAMMALN	GAMMALN.PRECISE	GAUSS
GCD	GEOMEAN	GESTEP	GROWTH

関数 H から L

HARMEAN	HEX2BIN	HEX2DEC	HEX2OCT
HLOOKUP	HOUR	HYPERLINK	HYPGEOM.DIST
HYPGEOMDIST	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	LET	LEN	LENB
LINEST	LN	LOG	LOG10
LOGEST	LOGINV	LOGNORM.DIST	LOGNORM.INV
LOGNORMDIST	LOOKUP	LOWER

関数 M から Q

MAKEARRAY	MAP	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	MUNIT	N	NA
NEGBINOM.DIST	NEGBINOMDIST	NETWORKDAYS	NETWORKDAYS.INTL
NOMINAL	NORM.DIST	NORM.INV	NORM.S.DIST
NORM.S.INV	NORMDIST	NORMINV	NORMSDIST
NORMSINV	NOT	NOW	NPER
NPV	NUMBERVALUE	OCT2BIN	OCT2DEC
OCT2HEX	ODD	ODDFPRICE	ODDFYIELD
ODDLPRICE	ODDLYIELD	OFFSET	OR
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	QUOTIENT

関数 R から S

RADIANS	RAND	RANDARRAY	RANDBETWEEN
RANK	RANK.AVG	RANK.EQ	RATE
RECEIVED	REDUCE	REPLACE	REPLACEB
REPT	RIGHT	RIGHTB	ROMAN
ROUND	ROUNDDOWN	ROUNDUP	ROW
ROWS	RRI	RSQ	RTD
SEARCH	SCAN	SEARCHB	SEC
SECH	SECOND	SERIESSUM	SEQUENCE
SHEET	SHEETS	SIGN	SIN
SINH	SINGLE	SKEW	SKEW. P
SLN	SLOPE	SMALL	SORT
SORTBY	SQRT	SQRTPI	STANDARDIZE
STDEV	STDEV.P	STDEV.S	STDEVA
STDEVP	STDEVPA	STEYX	SUBSTITUTE
SUBTOTAL	SUM	SUMIF	SUMIFS
SUMPRODUCT	SUMSQ	SUMX2MY2	SUMX2PY2
SUMXMY2	SWITCH	SYD

関数 T から Z

T	T.DIST	T.DIST.2T	T.DIST.RT
T.INV	T.INV.2T	T.TEST	TAN
TANH	TBILLEQ	TBILLPRICE	TBILLYIELD
TDIST	TEXT	TEXTJOIN	TIME
TIMEVALUE	TINV	TODAY	TRANSPOSE
TREND	TRIM	TRIMMEAN	TRUE
TRUNC	TTEST	TYPE	UNICHAR
UNICODE	UNIQUE	UPPER	USDOLLAR
VALUE	VALUETOTEXT	VAR	VAR.P
VAR.S	VARA	VARP	VARPA
VDB	VLOOKUP	WEBSERVICE	WEEKDAY
WEEKNUM	WEIBULL	WEIBULL.DIST	WORKDAY
WORKDAY.INTL	XIRR	XLOOKUP	XMATCH
XNPV	XOR	YEAR	YEARFRAC
YIELD	YIELDDISC	YIELDMAT	Z.TEST
ZTEST

各関数の詳しい使用方法については、「数式の概要」を参照してください。