FarPoint Spread for Windows Forms Product Tour

Spread's powerful Calc Engine includes over 300 built-in functions, supports cross-sheet formula referencing, and gives you the ability to define your own custom functions.

With formulas, you can

Specify a cell reference

Use a circular reference

Nest functions

Recalculate and update formulas automatically

Allow the user to enter formulas

Create and use a custom name

Create and use a custom function

Following are the included functions:

Database Functions
DAVERAGE	DCOUNT	DCOUNTA	DGET
DMAX	DMIN	DPRODUCT	DSTDEV
DSTDEVP	DSUM	DVAR	DVARP
Date and Time Functions
DATE	DATEDIF	DATEVALUE	DAY
DAYS360	EDATE	EOMONTH	HOUR
MINUTE	MONTH	NETWORKDAYS	NOW
SECOND	TIME	TIMEVALUE	TODAY
WEEKDAY	WEEKNUM	WORKDAY	YEAR
YEARFRAC
Engineering Functions
BESSELI	BESSELJ	BESSELK	BESSELY
BIN2DEC	BIN2HEX	BIN2OCT	COMPLEX
CONVERT	DEC2BIN	DEC2HEX	DEC2OCT
DELTA	ERF	ERFC	GESTEP
HEX2BIN	HEX2DEC	HEX2OCT	IMABS
IMAGINARY	IMARGUMENT	IMCONJUGATE	IMCOS
IMDIV	IMEXP	IMLN	IMLOG10
IMLOG2	IMPOWER	IMPRODUCT	IMREAL
IMSIN	IMSQRT	IMSUB	IMSUM
OCT2BIN	OCT2DEC	OCT2HEX
Financial Functions
ACCRINT	ACCRINTM	AMORDEGRC	AMORLINC
COUPDAYS	COUPDAYBS	COUPDAYSNC	COUPNCD
COUPNUM	COUPPCD	CUMIPMT	CUMPRINC
DB	DDB	DISC	DOLLAR
DOLLARDE	DOLLARFR	DURATION	EFFECT
EURO	EUROCONVERT	FV	FVSCHEDULE
INTRATE	IPMT	IRR	ISPMT
MDURATION	MIRR	NOMINAL	NPER
NPV	ODDFPRICE	ODDFYIELD	ODDLPRICE
ODDLYIELD	PMT	PPMT	PRICE
PRICEDISC	PRICEMAT	PV	RATE
RECEIVED	SLN	SYD	TBILLEQ
TBILLPRICE	TBILLYIELD	VDB	XIRR
XNPV	YIELD	YIELDDISC	YIELDMAT
Information Functions
COUNTBLANK	ERRORTYPE	ISBLANK	ISERR
ISERROR	ISEVEN	ISLOGICAL	ISNA
ISNONTEXT	ISNUMBER	ISODD	ISREF
ISTEXT	N	NA	TYPE
Logical Functions
AND	FALSE	IF	NOT
OR	TRUE
Look Up Functions
ADDRESS	CHOOSE	COLUMN	COLUMNS
HLOOKUP	INDEX	LOOKUP	OFFSET
ROW	ROWS	TRANSPOSE	VLOOKUP
Math and Trigonometry Functions
ABS	ACOS	ACOSH	ASIN
ASINH	ATAN	ATAN2	ATANH
CEILING	COMBIN	COS	COSH
COUNTIF	DEGREES	EVEN	EXP
FACT	FACTDOUBLE	FLOOR	GCD
INT	LCM	LN	LOG
LOG10	MDETERM	MINVERSE	MMULT
MOD	MROUND	MULTINOMIAL	ODD
PI	POWER	PRODUCT	QUOTIENT
RADIANS	RAND	RANDBETWEEN	ROMAN
ROUND	ROUNDDOWN	ROUNDUP	SERIESSUM
SIGN	SIN	SINH	SQRT
SQRTPI	SUBTOTAL	SUM	SUMIF
SUMPRODUCT	SUMSQ	SUMX2MY2	SUMX2PY2
SUMXMY2	TAN	TANH	TRUNC
Statistical Functions
AVEDEV	AVERAGE	AVERAGEA	BETADIST
BETAINV	BINOMDIST	CHIDIST	CHIINV
CHITEST	CONFIDENCE	CORREL	COUNT
COUNTA	COVAR	CRITBINOM	DEVSQ
EXPONDIST	FDIST	FINV	FISHER
FISHERINV	FORECAST	FREQUENCY	FTEST
GAMMADIST	GAMMAINV	GAMMALN	GEOMEAN
GROWTH	HARMEAN	HYPGEOMDIST	INTERCEPT
KURT	LARGE	LINEST	LOGEST
LOGINV	LOGNORMDIST	MAX	MAXA
MEDIAN	MIN	MINA	MODE
NEGBINOMDIST	NORMDIST	NORMINV	NORMSDIST
NORMSINV	PEARSON	PERCENTILE	PERCENTRANK
PERMUT	POISSON	PROB	QUARTILE
RANK	RSQ	SKEW	SLOPE
SMALL	STANDARDIZE	STDEV	STDEVA
STDEVP	STDEVPA	STEYX	TDIST
TINV	TREND	TRIMMEAN	TTEST
VAR	VARA	VARP	VARPA
WEIBULL	ZTEST
Text Functions
CHAR	CLEAN	CODE	CONCATENATE
DOLLAR	EXACT	FIND	FIXED
LEFT	LEN	LOWER	MID
PROPER	REPLACE	REPT	RIGHT
SUBSTITUTE	T	TRIM	UPPER
VALUE