Basic Functions

SpreadJS supports the following basic functions for various ReportSheet calculations.

Supported Functions List
ABS	ACCRINT	ACCRINTM	ACOS	ACOSH	ACOT	ACOTH	ADDRESS
AMORDEGRC	AMORLINC	AND	ARABIC	AREASPARKLINE	ASC	ASIN	ASINH
ATAN	ATAN2	ATANH	AVEDEV	AVERAGE	AVERAGEA	AVERAGEIF	AVERAGEIFS
BAHTTEXT	BASE	BC_CODABAR	BC_CODE128	BC_CODE39	BC_CODE49	BC_CODE93	BC_DATAMATRIX
BC_EAN13	BC_EAN8	BC_GS1_128	BC_PDF417	BC_QRCODE	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	BOXPLOTSPARKLINE	BULLETSPARKLINE	CASCADESPARKLINE	CEILING	CEILING.MATH	CEILING.PRECISE	CHAR
CHIDIST	CHIINV	CHISQ.DIST	CHISQ.DIST.RT	CHISQ.INV	CHISQ.INV.RT	CHISQ.TEST	CHITEST
CLEAN	CODE	COLUMN	COLUMNS	COLUMNSPARKLINE	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	DAY	DAYS	DAYS360	DB	DBCS	DDB
DEC2BIN	DEC2HEX	DEC2OCT	DECIMAL	DEGREES	DELTA	DEVSQ	DISC
DOLLAR	DOLLARDE	DOLLARFR	DURATION	EDATE	EFFECT	ENCODEURL	EOMONTH
ERF	ERF.PRECISE	ERFC	ERFC.PRECISE	ERROR.TYPE	EURO	EUROCONVERT	EVEN
EXACT	EXP	EXPON.DIST	EXPONDIST	F.DIST	F.DIST.RT	F.INV	F.INV.RT
F.TEST	FACT	FACTDOUBLE	FALSE	FDIST	FIND	FINDB	FINV
FISHER	FISHERINV	FIXED	FLOOR	FLOOR.MATH	FLOOR.PRECISE	FORECAST	FORMULATEXT
FTEST	FV	FVSCHEDULE	GAMMA	GAMMA.DIST	GAMMA.INV	GAMMADIST	GAMMAINV
GAMMALN	GAMMALN.PRECISE	GAUGEKPISPARKLINE	GAUSS	GCD	GEOMEAN	GESTEP	GROWTH
HARMEAN	HBARSPARKLINE	HEX2BIN	HEX2DEC	HEX2OCT	HISTOGRAMSPARKLINE	HOUR	HYPERLINK
HYPGEOM.DIST	HYPGEOMDIST	IF	IFERROR	IFNA	IFS	IMABS	IMAGE
IMAGINARY	IMARGUMENT	IMCONJUGATE	IMCOS	IMCOSH	IMCOT	IMCSC	IMCSCH
IMDIV	IMEXP	IMLN	IMLOG10	IMLOG2	IMPOWER	IMPRODUCT	IMREAL
IMSEC	IMSECH	IMSIN	IMSINH	IMSQRT	IMSUB	IMSUM	IMTAN
INT	INTERCEPT	INTRATE	IPMT	IRR	ISBLANK	ISERR	ISERROR
ISEVEN	ISFORMULA	ISLOGICAL	ISNA	ISNONTEXT	ISNUMBER	ISO.CEILING	ISODD
ISOMITTED	ISOWEEKNUM	ISPMT	ISTEXT	JIS	KURT	LAMBDA	LARGE
LCMLCM	LEFT	LEFTB	LEN	LENB	LET	LINESPARKLINE	LN
LOG	LOG10	LOGINV	LOGNORM.DIST	LOGNORM.INV	LOGNORMDIST	LOWER	MAX
MAXA	MAXIFS	MDURATION	MEDIAN	MID	MIDB	MIN	MINA
MINIFS	MINUTE	MIRR	MOD	MODE	MODE.MULT	MODE.SNGL	MONTH
MONTHSPARKLINE	MROUND	MULTINOMIAL	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	OBJECT	OCT2BIN
OCT2DEC	OCT2HEX	ODD	ODDFPRICE	ODDFYIELD	ODDLPRICE	ODDLYIELD	OR
PARETOSPARKLINE	PDURATION	PEARSON	PERCENTILE	PERCENTILE.EXC	PERCENTILE.INC	PERCENTRANK	PERCENTRANK.EXC
PERCENTRANK.INC	PERMUT	PERMUTATIONA	PHI	PI	PIESPARKLINE	PMT	POISSON
POISSON.DIST	POWER	PPMT	PRICE	PRICEDISC	PRICEMAT	PROB	PRODUCT
PROPER	PROPERTY	PV	QUARTILE	QUARTILE.EXC	QUARTILE.INC	QUOTIENT	RADIANS
RAND	RANGEBLOCKSPARKLINE	RANK	RANK.AVG	RANK.EQ	RATE	RECEIVED	REDUCE
REFRESH	REPLACE	REPLACEB	REPT	RIGHT	RIGHTB	ROMAN	ROUND
ROUNDDOWN	ROUNDUP	ROW	ROWS	RRI	RSQ	SCAN	SCATTERSPARKLINE
SEARCH	SEARCHB	SEC	SECH	SECOND	SERIESSUM	SHEET	SHEETS
SIGN	SIN	SINH	SJS.ENDWITH	SJS.REGEXEXTRACT	SJS.REGEXMATCH	SJS.REGEXREPLACE	SJS.STARTWITH
SJS.UUID	SKEW	SKEW.P	SLN	SLOPE	SMALL	SPREADSPARKLINE	SQRT
SQRTPI	STACKEDSPARKLINE	STANDARDIZE	STDEV	STDEV.P	STDEV.S	STDEVA	STDEVP
STDEVPA	STEYX	SUBSTITUTE	SUM	SUMIF	SUMIFS	SUMPRODUCT	SUMSQ
SUMX2MY2	SUMX2PY2	SUMXMY2	SWITCH	SYD	T	T.DIST	T.DIST.2T
T.DIST.RT	T.INV	T.INV.2T	T.TEST	TAN	TANH	TBILLEQ	TBILLPRICE
TBILLYIELD	TDIST	TEXT	TEXTAFTER	TEXTBEFORE	TEXTJOIN	TEXTSPLIT	TIME
TIMEVALUE	TINV	TODAY	TRIM	TRIMMEAN	TRUE	TRUNC	TTEST
UNICHAR	UNICODE	UPPER	VALUE	VAR	VAR.P	VAR.S	VARA
VARISPARKLINE	VARP	VARPA	VBARSPARKLINE	VDB	WEBSERVICE	WEEKDAY	WEEKNUM
WEIBULL	WEIBULL.DIST	WINLOSSSPARKLINE	WORKDAY	WORKDAY.INTL	XIRR	XNPV	XOR
YEAR	YEARFRAC	YEARSPARKLINE	YIELD	YIELDDISC	YIELDMAT	Z.TEST	ZTEST