SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions
In This Topic
    Formula Functions
    In This Topic

    Spread provides these built-in functions, listed alphabetically.

    ABS ACCRINT ACCRINTM
    ACOS ACOSH ACOT
    ACOTH ADDRESS AGGREGATE
    AMORDEGRC AMORLINC AND
    ARABIC AREAS ASIN
    ASINH ATAN ATAN2
    ATANH AVEDEV AVERAGE
    AVERAGEA AVERAGEIF AVERAGEIFS
    BAHTTEXT BASE BESSELI
    BESSELJ BESSELK BESSELY
    BETADIST BETA.DIST BETAINV
    BETA.INV BIN2DEC BIN2HEX
    BIN2OCT BINOMDIST BINOM.DIST
    BINOM.DIST.RANGE BINOM.INV BITAND
    BITLSHIFT BITOR BITRSHIFT
    BITXOR CEILING CEILING.MATH
    CEILING.PRECISE 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

     

    DATE DATEDIF DATEVALUE
    DAVERAGE DAY DAYS
    DAYS360 DB 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 EURO
    EUROCONVERT EVEN EXACT
    EXP EXPONDIST EXPON.DIST

     

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

     

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

     

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

     

    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 RADIANS RAND
    RANDARRAY RANDBETWEEN RANK
    RANK.AVG RANK.EQ RATE
    RECEIVED REFRESH REPLACE
    REPLACEB REPT RIGHT
    RIGHTB ROMAN ROUND
    ROUNDDOWN ROUNDUP ROW
    ROWS RRI RSQ

     

    SEARCH SEARCHB SEC
    SECH SECOND SERIESSUM
    SEQUENCE SIGN SIN
    SINH SINGLE SKEW
    SKEW.P SLN SLOPE
    SMALL SORT SORTBY
    SQRT SQRTPI STANDARDIZE
    STDEV STDEVA STDEVP
    STDEV.P STDEVPA STDEV.S
    STEYX SUBSTITUTE SUBTOTAL
    SUM SUMIF SUMIFS
    SUMPRODUCT SUMSQ SUMX2MY2
    SUMX2PY2 SUMXMY2 SYD
    SWITCH T TAN
    TANH TBILLEQ TBILLPRICE
    TBILLYIELD TDIST T.DIST
    T.DIST.2T T.DIST.RT TEXT
    TEXTJOIN TIME TIMEVALUE
    TINV T.INV T.INV.2T
    TODAY TRANSPOSE TREND
    TRIM TRIMMEAN TRUE
    TRUNC TTEST T.TEST
    TYPE

     

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