Formula Functions

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	ADDRESS	AMORDEGRC	AMORLINC
AND	ASIN	ASINH	ATAN
ATAN2	ATANH	AVEDEV	AVERAGE
AVERAGEA	AVERAGEIF	AVERAGEIFS	BESSELI
BESSELJ	BESSELK	BESSELY	BETADIST
BETAINV	BIN2DEC	BIN2HEX	BIN2OCT
BINOMDIST	CEILING	CHAR	CHIDIST
CHIINV	CHITEST	CHOOSE	CLEAN
CODE	COLUMN	COLUMNS	COMBIN
COMPLEX	CONCATENATE	CONFIDENCE	CONVERT
CORREL	COS	COSH	COUNT
COUNTA	COUNTBLANK	COUNTIF	COUNTIFS
COUPDAYS	COUPDAYBS	COUPDAYSNC	COUPNCD
COUPNUM	COUPPCD	COVAR	CRITBINOM
CUMIPMT	CUMPRINC

Functions D to G

DATE	DATEDIF	DATEVALUE	DAVERAGE
DAY	DAYS360	DB	DCOUNT
DCOUNTA	DDB	DEC2BIN	DEC2HEX
DEC2OCT	DEGREES	DELTA	DEVSQ
DGET	DISC	DMAX	DMIN
DOLLAR	DOLLARDE	DOLLARFR	DPRODUCT
DSTDEV	DSTDEVP	DSUM	DURATION
DVAR	DVARP	EDATE	EFFECT
EOMONTH	ERF	ERFC	ERRORTYPE
EURO	EUROCONVERT	EVEN	EXACT
EXP	EXPONDIST	FACT	FACTDOUBLE
FALSE	FDIST	FIND	FINV
FINV	FISHERINV	FIXED	FLOOR
FORECAST	FREQUENCY	FTEST	FV
FVSCHEDULE	GAMMADIST	GAMMAINV	GAMMALN
GCD	GEOMEAN	GESTEP	GROWTH

Functions H to L

HARMEAN	HEX2BIN	HEX2DEC	HEX2OCT
HLOOKUP	HOUR	HYPGEOMDIST	IF
IFERROR	IMABS	IMAGINARY	IMARGUMENT
IMCONJUGATE	IMCOS	IMDIV	IMEXP
IMLN	IMLOG10	IMLOG2	IMPOWER
IMPRODUCT	IMREAL	IMSIN	IMSQRT
IMSUB	IMSUM	INDEX	INT
INTERCEPT	INTRATE	IPMT	IRR
ISBLANK	ISERR	ISERROR	ISEVEN
ISLOGICAL	ISNA	ISNONTEXT	ISNUMBER
ISODD	ISPMT	ISREF	ISTEXT
KURT	LARGE	LCM	LEFT
LEN	LINEST	LN	LOG
LOG10	LOGEST	LOGINV	LOGNORMDIST
LOOKUP	LOWER

Functions M to Q

MATCH	MAX	MAXA	MDETERM
MDURATION	MEDIAN	MID	MIN
MINA	MINUTE	MINVERSE	MIRR
MMULT	MOD	MODE	MONTH
MROUND	MULTINOMIAL	N	NA
NEGBINOMDIST	NETWORKDAYS	NOMINAL	NORMDIST
NORMINV	NORMSDIST	NORMSINV	NOT
NOW	NPER	NPV	OCT2BIN
OCT2DEC	OCT2HEX	ODD	ODDFPRICE
ODDFYIELD	ODDLPRICE	ODDLYIELD	OFFSET
OR	PEARSON	PERCENTILE	PERCENTRANK
PERMUT	PI	PMT	POISSON
POWER	PPMT	PRICE	PRICEDISC
PRICEMAT	PROB	PRODUCT	PROPER
PV	QUARTILE	QUOTIENT

Functions R to S

RADIANS	RAND	RANDBETWEEN	RANK
RATE	RECEIVED	REPLACE	REPT
RIGHT	ROMAN	ROUND	ROUNDDOWN
ROUNDUP	ROW	ROWS	RSQ
SEARCH	SECOND	SERIESSUM	SIGN
SIN	SINH	SKEW	SLN
SLOPE	SMALL	SQRT	SQRTPI
STANDARDIZE	STDEV	STDEVA	STDEVP
STDEVPA	STEYX	SUBSTITUTE	SUBTOTAL
SUM	SUMIF	SUMIFS	SUMPRODUCT
SUMSQ	SUMX2MY2	SUMX2PY2	SUMXMY2
SYD

Functions T to Z

T	TAN	TANH	TBILLEQ
TBILLPRICE	TBILLYIELD	TDIST	TEXT
TIME	TIMEVALUE	TINV	TODAY
TRANSPOSE	TREND	TRIM	TRIMMEAN
TRUE	TRUNC	TTEST	TYPE
UPPER	VALUE	VAR	VARA
VARP	VARPA	VDB	VLOOKUP
WEEKDAY	WEEKNUM	WEIBULL	WORKDAY
XIRR	XNPV	YEAR	YEARFRAC
YIELD	YIELDDISC	YIELDMAT	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.