Spread.NET provides these built-in functions, listed alphabetically.

For a list of functions by type, refer to Categories of Functions.

Functions A to C

ABS	ACCRINT	ACCRINTM	ACOS
ACOSH	ACOT	ACOTH	ADDRESS
AGGREGATE	AMORDEGRC	AMORLINC	AND
ARABIC	AREAS	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	CALL
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

Functions D to 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	EUROCONVERT
EVEN	EXACT	EXP	EXPON.DIST
EXPONDIST	F.DIST	F.DIST.RT	F.INV
F.INV.RT	F.TEST	FACT	FACTDOUBLE
FALSE	FDIST	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

Functions H to 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	ISOWEEKNUM	ISPMT	ISREF
ISTEXT	JIS	KURT	LARGE
LCM	LEFT	LEFTB	LEN
LENB	LINEST	LN	LOG
LOG10	LOGEST	LOGINV	LOGNORM.DIST
LOGNORM.INV	LOGNORMDIST	LOOKUP	LOWER

Functions M to Q

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

Functions R to S

RADIANS	RAND	RANDARRAY	RANDBETWEEN
RANK	RANK.AVG	RANK.EQ	RATE
RECEIVED	REPLACE	REPLACEB	REPT
RIGHT	RIGHTB	ROMAN	ROUND
ROUNDDOWN	ROUNDUP	ROW	ROWS
RRI	RSQ	RTD	SEARCH
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

Functions T to 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	VAR	VAR.P	VAR.S
VARA	VARP	VARPA	VDB
VLOOKUP	WEBSERVICE	WEEKDAY	WEEKNUM
WEIBULL	WEIBULL.DIST	WORKDAY	WORKDAY.INTL
XIRR	XNPV	XOR	YEAR
YEARFRAC	YIELD	YIELDDISC	YIELDMAT
Z.TEST	ZTEST

For more information on how to use these functions, refer to the Formula Overview, and to the chapter on Managing Formulas in the product Developers Guide.

Return to the Formula Reference.