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 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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options