Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions
In This Topic
    Formula Functions
    In This Topic

    Spread WPF provides these built-in functions, listed alphabetically.

    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 COUPDAYBS COUPDAYS
    COUPDAYSNC COUPNCD COUPNUM
    COUPPCD COVAR CRITBINOM
    CUMIPMT CUMPRINC  

    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 ERROR.TYPE
    EURO EUROCONVERT EVEN
    EXACT EXP EXPONDIST

    FACT FACTDOUBLE FALSE
    FDIST FIND FINV
    FISHER FISHERINV FIXED
    FLOOR FORECAST FREQUENCY
    FTEST FV FVSCHEDULE
    GAMMADIST GAMMAINV GAMMALN
    GCD GEOMEAN GESTEP
    GROWTH HARMEAN HEX2BIN
    HEX2DEC HEX2OCT HLOOKUP
    HOUR HYPGEOMDIST  

    IF IFERROR IMABS
    IMAGINARY IMARGUMENT IMCONJUGATE
    IMCOS IMDIV IMEXP
    IMLN IMLOG2 IMLOG10
    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

    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 OFFSET
    PEARSON PERCENTILE PERCENTRANK
    PERMUT PI PMT
    POISSON POWER PPMT
    PRICE PRICEDISC PRICEMAT
    PROB PRODUCT PROPER
    PV QUARTILE QUOTIENT
    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 T
    TAN TANH TBILLEQ
    TBILLPRICE TBILLYIELD TDIST
    TEXT TIME TIMEVALUE
    TINV TODAY TRANSPOSE
    TREND TRIM TRIMMEAN
    TRUE TRUNC TTEST
    TYPE TTEST TYPE
    UPPER VALUE VAR
    VARA VARP VARPA
    VDB VLOOKUP WEEKDAY
    WEEKNUM WEIBULL WORKDAY
    XIRR XNPV YEAR
    YEARFRAC YIELD YIELDDISC
    YIELDMAT ZTEST