Collapse All Expand All

Spread provides these built-in functions, listed alphabetically.

ABS	ACCRINT	ACCRINTM
ACOS	ACOSH	ADDRESS
AMORDEGRC	AMORLINC	AND
ASIN	ASINH	ATAN
ATAN2	ATANH	AVEDEV
AVERAGE	AVERAGEA	AVERAGEIF
AVERAGEIFS	BESSELI	BESSELJ
BESSELK	BESSELY	BETADIST
BETA.DIST	BETAINV	BETA.INV
BIN2DEC	BIN2HEX	BIN2OCT
BINOMDIST	BINOM.DIST	BINOM.INV
CEILING	CEILING.PRECISE	CHAR
CHIDIST	CHIINV	CHISQ.DIST
CHISQ.DIST.RT	CHISQ.INV	CHISQ.INV.RT
CHISQ.TEST	CHITEST	CHOOSE
CLEAN	CODE	COLUMN
COLUMNS	COMBIN	COMPLEX
CONCATENATE	CONFIDENCE	CONFIDENCE.NORM
CONFIDENCE.T	CONVERT	CORREL
COS	COSH	COUNT
COUNTA	COUNTBLANK	COUNTIF
COUNTIFS	COUPDAYBS	COUPDAYS
COUPDAYSNC	COUPNCD	COUPNUM
COUPPCD	COVAR	COVARIANCE.P
COVARIANCE.S	CRITBINOM	CUMIPMT
CUMPRINC

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	ERF.PRECISE	ERFC
ERFC.PRECISE	ERROR.TYPE	EURO
EUROCONVERT	EVEN	EXACT
EXP	EXPONDIST	EXPON.DIST

 

FACT	FACTDOUBLE	FALSE
FDIST	F.DIST	F.DIST.RT
FIND	FINV	F.INV
F.INV.RT	FISHER	FISHERINV
FIXED	FLOOR	FLOOR.PRECISE
FORECAST	FREQUENCY	FTEST
F.TEST	FV	FVSCHEDULE
GAMMADIST	GAMMA.DIST	GAMMAINV
GAMMA.INV	GAMMALN	GAMMALN.PRECISE
GCD	GEOMEAN	GESTEP
GROWTH	HARMEAN	HEX2BIN
HEX2DEC	HEX2OCT	HLOOKUP
HOUR	HYPGEOMDIST	HYPGEOM.DIST

IF	IFERROR	IMABS
IMAGINARY	IMARGUMENT	IMCONJUGATE
IMCOS	IMDIV	IMEXP
IMLN	IMLOG2	IMLOG10
IMPOWER	IMPRODUCT	IMREAL
IMSIN	IMSQRT	IMSUB
IMSUM	INDEX	INDIRECT
INT	INTERCEPT	INTRATE
IPMT	IRR	ISBLANK
ISERR	ISERROR	ISEVEN
ISLOGICAL	ISNA	ISNONTEXT
ISNUMBER	ISO.CEILING	ISODD
ISPMT	ISREF	ISTEXT
KURT	LARGE	LCM
LEFT	LEN	LINEST
LN	LOG	LOG10
LOGEST	LOGINV	LOGNORMDIST
LOGNORM.DIST	LOGNORM.INV	LOOKUP
LOWER

MATCH	MAX	MAXA
MDETERM	MDURATION	MEDIAN
MID	MIN	MINA
MINUTE	MINVERSE	MIRR
MMULT	MOD	MODE
MODE.MULT	MODE.SNGL	MONTH
MROUND	MULTINOMIAL	NEGBINOMDIST
NEGBINOM.DIST	N	NA
NETWORKDAYS	NETWORKDAYS.INTL	NOMINAL
NORMDIST	NORM.DIST	NORMINV
NORM.INV	NORMSDIST	NORM.S.DIST
NORMSINV	NORM.S.INV	NOT
NOW	NPER	NPV
OCT2BIN	OCT2DEC	OCT2HEX
ODD	ODDFPRICE	ODDFYIELD
ODDLPRICE	ODDLYIELD	OFFSET
OR	OFFSET

PEARSON	PERCENTILE	PERCENTILE.EXC
PERCENTILE.INC	PERCENTRANK	PERCENTRANK.EXC
PERCENTRANK.INC	PERMUT	PI
PMT	POISSON	POISSON.DIST
POWER	PPMT	PRICE
PRICEDISC	PRICEMAT	PROB
PRODUCT	PROPER	PV
QUARTILE	QUARTILE.EXC	QUARTILE.INC
QUOTIENT	RADIANS	RAND
RANDBETWEEN	RANK	RANK.AVG
RANK.EQ	RATE	RECEIVED
REFRESH	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	STDEV.P	STDEVPA
STDEV.S	STEYX	SUBSTITUTE
SUBTOTAL	SUM	SUMIF
SUMIFS	SUMPRODUCT	SUMSQ
SUMX2MY2	SUMX2PY2	SUMXMY2
SYD	T	TAN
TANH	TBILLEQ	TBILLPRICE
TBILLYIELD	TDIST	T.DIST
T.DIST.2T	T.DIST.RT	TEXT
TIME	TIMEVALUE	TINV
T.INV	T.INV.2T	TODAY
TRANSPOSE	TREND	TRIM
TRIMMEAN	TRUE	TRUNC
TTEST	T.TEST	TYPE

UPPER	VALUE	VAR
VARA	VARP	VAR.P
VARPA	VAR.S	VDB
VLOOKUP	WEEKDAY	WEEKNUM
WEIBULL	WEIBULL.DIST	WORKDAY
WORKDAY.INTL	XIRR	XNPV
YEAR	YEARFRAC	YIELD
YIELDDISC	YIELDMAT	ZTEST
Z.TEST

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.