Spread.NET 15 Formula Reference
In This Topic
    Formula Functions
    In This Topic

    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 ANCHORARRAY
    AND ARABIC AREAS ARRAYTOTEXT
    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 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 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 FILTER
    FILTERXML FIND FINDB FINV
    FISHER FISHERINV FIXED FLOOR
    FLOOR.MATH FLOOR.PRECISE FORECAST FORECAST.LINEAR
    FORMULATEXT FREQUENCY FTEST FV
    FVSCHEDULE GAMMA GAMMA.DIST GAMMA.INV
    GAMMADIST GAMMAINV GAMMALN GAMMALN.PRECISE
    GAUSS GCD GEOMEAN GESTEP
    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 LET 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 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 RANDARRAY RANDBETWEEN
    RANK RANK.AVG RANK.EQ RATE
    RECEIVED REPLACE REPLACEB REPT
    RIGHT RIGHTB ROMAN ROUND
    ROUNDDOWN ROUNDUP ROW ROWS
    RRI RSQ RTD SEARCH
    SEARCHB SEC SECH SECOND
    SERIESSUM SEQUENCE SHEET SHEETS
    SIGN SIN SINH SINGLE
    SKEW SKEW.P SLN SLOPE
    SMALL SORT SORTBY 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 UNIQUE UPPER USDOLLAR
    VALUE VALUETOTEXT VAR VAR.P
    VAR.S VARA VARP VARPA
    VDB VLOOKUP WEBSERVICE WEEKDAY
    WEEKNUM WEIBULL WEIBULL.DIST WORKDAY
    WORKDAY.INTL XIRR XLOOKUP XMATCH
    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.