Spread.NET 14 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 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 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.