Spread Formula Reference
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 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 CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY
CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE
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 EURO
EUROCONVERT EVEN EXACT EXP
EXPON.DIST EXPONDIST F.DIST F.DIST.RT
F.INV F.INV.RT F.TEST FACT
FACTDOUBLE FALSE FDIST FILTERXML
FIND FINDB FINV FISHER
FISHERINV FIXED FLOOR FLOOR.MATH
FLOOR.PRECISE FORECAST FORECAST.ETS FORECAST.ETS.CONFINT
FORECAST.ETS.SEASONALITY FORECAST.ETS.STAT FORECAST.LINEAR FORMULATEXT
FREQUENCY FTEST FV FVSCHEDULE
GAMMA GAMMA.DIST GAMMA.INV GAMMADIST
GAMMAINV GAMMALN GAMMALN.PRECISE GAUSS
GCD GEOMEAN GESTEP GETPIVOTDATA
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 PHONETIC 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 RANDBETWEEN RANK
RANK.AVG RANK.EQ RATE RECEIVED
REGISTERID REPLACE REPLACEB REPT
RIGHT RIGHTB ROMAN ROUND
ROUNDDOWN ROUNDUP ROW ROWS
RRI RSQ RTD SEARCH
SEARCHB SEC SECH SECOND
SERIESSUM SHEET SHEETS SIGN
SIN SINH SKEW SKEW.P
SLN SLOPE SMALL 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 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.