Show / Hide Table of Contents

    Supported Excel functions

    This is a list of all the standard Excel functions up to Excel 2019.

    Functions marked with strikeout are not implemented yet. To know if a specific spreadsheet has all the formulas supported by FlexCel, you can use the Validate Recalc demo

    Formulas on column "Array Enabled" mean that you can enter them inside an Array formula with a range argument (for example "if(a1:a10 < 3;…;….)") All formulas can be used inside Array Formulas, but only the ones on this list can be used with array arguments where they would expect a single value. By "Array formulas" we mean formulas you enter with Shift-Ctrl-Enter in Excel

    Supported built-in functions

    • Total built-in functions: 419
    • Implemented: 317 (76%)

    Built-in functions in 2003

    Financial

    Name Implemented Array enabled
    Db ✓
    Ddb ✓
    Fv ✓
    Ipmt ✓
    Irr ✓
    Ispmt
    Mirr ✓
    Nper ✓
    Npv ✓
    Pmt ✓
    PPmt ✓
    Pv ✓
    Rate ✓
    Sln ✓
    Syd ✓
    Vdb

    Date & Time

    Name Implemented Array enabled
    Date ✓ ✓
    DateValue ✓ ✓
    Day ✓ ✓
    Days360 ✓
    Hour ✓ ✓
    Minute ✓ ✓
    Month ✓ ✓
    Now ✓ ✓
    Second ✓ ✓
    Time ✓ ✓
    TimeValue ✓ ✓
    Today ✓ ✓
    WeekDay ✓ ✓
    Year ✓ ✓
    DateDif ✓ ✓

    Math & Trig

    Name Implemented Array enabled
    Abs ✓ ✓
    Acos ✓ ✓
    Acosh ✓ ✓
    Asin ✓ ✓
    Asinh ✓ ✓
    Atan ✓ ✓
    Atan2 ✓ ✓
    Atanh ✓ ✓
    Ceiling ✓ ✓
    Combin ✓ ✓
    Cos ✓ ✓
    Cosh ✓ ✓
    Degrees ✓ ✓
    Even ✓ ✓
    Exp ✓ ✓
    Fact ✓ ✓
    Floor ✓ ✓
    Int ✓ ✓
    Ln ✓ ✓
    Log ✓
    Log10 ✓ ✓
    Mdeterm
    Minverse
    Mmult ✓ ✓
    Mod ✓ ✓
    Odd ✓ ✓
    Pi ✓ ✓
    Power ✓ ✓
    Product ✓ ✓
    Radians ✓ ✓
    Rand ✓ ✓
    Roman ✓
    Round ✓ ✓
    Rounddown ✓ ✓
    Roundup ✓ ✓
    Sign ✓ ✓
    Sin ✓ ✓
    Sinh ✓ ✓
    Sqrt ✓ ✓
    Subtotal ✓
    Sum ✓ ✓
    SumX2MY2 ✓ ✓
    SumX2PY2 ✓ ✓
    SumXMY2 ✓ ✓
    Sumif ✓ ✓
    Sumproduct ✓ ✓
    Sumsq ✓ ✓
    Tan ✓ ✓
    Tanh ✓ ✓
    Trunc ✓

    Statistical

    Name Implemented Array enabled
    Avedev ✓ ✓
    Average ✓ ✓
    Averagea ✓ ✓
    Betadist
    Betainv
    Binomdist ✓
    Chidist ✓
    Chiinv ✓
    Chitest ✓ ✓
    Confidence ✓
    Correl ✓
    Count ✓ ✓
    Counta ✓ ✓
    Countblank ✓ ✓
    Countif ✓ ✓
    Covar ✓
    Critbinom
    Devsq ✓
    Expondist ✓
    Fdist
    Finv
    Fisher ✓ ✓
    Fisherinv ✓ ✓
    Forecast
    Frequency ✓ ✓
    Ftest
    Gammadist ✓
    Gammainv ✓
    Gammaln ✓ ✓
    Geomean ✓
    Growth
    Harmean ✓
    Hypgeomdist ✓
    Intercept ✓
    Kurt ✓
    Large ✓ ✓
    Linest
    Logest
    Loginv ✓
    Lognormdist ✓
    Max ✓ ✓
    Maxa ✓ ✓
    Median ✓ ✓
    Min ✓ ✓
    Mina ✓ ✓
    Mode ✓ ✓
    Negbinomdist ✓
    Normdist ✓
    Norminv ✓
    Normsdist ✓ ✓
    Normsinv ✓ ✓
    Pearson ✓ ✓
    Percentile ✓ ✓
    Percentrank ✓
    Permut ✓ ✓
    Poisson ✓
    Prob
    Quartile ✓ ✓
    Rank ✓
    Rsq ✓ ✓
    Skew ✓ ✓
    Slope ✓ ✓
    Small ✓ ✓
    Standardize ✓ ✓
    Stdev ✓
    Stdeva ✓
    Stdevp ✓
    Stdevpa ✓
    Steyx ✓ ✓
    Tdist
    Tinv
    Trend
    Trimmean
    Ttest
    Var ✓
    Vara ✓
    Varp ✓
    Varpa ✓
    Weibull ✓
    Ztest ✓

    Lookup & Reference

    Name Implemented Array enabled
    Address ✓ ✓
    Areas ✓
    Choose ✓ ✓
    Column ✓ ✓
    Columns ✓ ✓
    Hlookup ✓
    Hyperlink ✓
    Index ✓
    Indirect ✓ ✓
    Lookup ✓
    Match ✓ ✓
    Offset ✓ ✓
    Row ✓ ✓
    Rows ✓ ✓
    Transpose ✓ ✓
    Vlookup ✓

    Database

    Name Implemented Array enabled
    DAverage ✓
    DCount ✓
    DCounta ✓
    DGet ✓
    DMax ✓
    DMin ✓
    DProduct ✓
    DStdev ✓
    DStdevp ✓
    DSum ✓
    DVar ✓
    DVarp ✓
    Getpivotdata

    Text

    Name Implemented Array enabled
    Asc ✓ ✓
    Bahttext
    Char ✓ ✓
    Clean ✓ ✓
    Code ✓ ✓
    Concatenate ✓ ✓
    Dollar ✓
    Exact ✓
    Find ✓
    Fixed ✓
    Jis
    Left ✓ ✓
    Len ✓ ✓
    Lower ✓ ✓
    Mid ✓ ✓
    Phonetic
    Proper ✓ ✓
    Replace ✓ ✓
    Rept ✓
    Right ✓ ✓
    Search ✓ ✓
    Substitute ✓
    T ✓
    Text ✓
    Trim ✓ ✓
    Upper ✓ ✓
    Value ✓ ✓

    Logical

    Name Implemented Array enabled
    And ✓ ✓
    False ✓ ✓
    If ✓ ✓
    Not ✓ ✓
    Or ✓ ✓
    True ✓ ✓

    Information

    Name Implemented Array enabled
    Cell ✓
    Error.Type ✓ ✓
    Info
    Isblank ✓ ✓
    Iserr ✓ ✓
    Iserror ✓ ✓
    Islogical ✓ ✓
    Isna ✓ ✓
    Isnontext ✓ ✓
    Isnumber ✓ ✓
    Isref ✓
    Istext ✓ ✓
    N ✓
    Na ✓ ✓
    Type ✓ ✓
    • Total: 238
    • Implemented: 213 (89%)

    Added functions in Excel 2007

    Name Implemented Array enabled
    AccrInt ✓
    AccrIntM ✓
    AmorDegrc
    AmorLinc
    AverageIf ✓ ✓
    AverageIfs ✓ ✓
    BesselI
    BesselJ
    BesselK
    BesselY
    Bin2Dec ✓
    Bin2Hex ✓
    Bin2Oct ✓
    Complex
    Convert ✓
    CountIfs ✓ ✓
    CoupDayBs ✓
    CoupDays ✓
    CoupDaysNc ✓
    CoupNcd ✓
    CoupNum ✓
    CoupPcd ✓
    CumIPmt ✓
    CumPrinc ✓
    Dec2Bin ✓
    Dec2Hex ✓
    Dec2Oct ✓
    Delta ✓
    Disc
    DollarDe ✓
    DollarFr ✓
    Duration ✓
    EDate ✓
    Effect ✓
    EoMonth ✓
    Erf
    ErfC
    FactDouble ✓
    FVSchedule
    Gcd ✓ ✓
    GeStep ✓
    Hex2Bin ✓
    Hex2Dec ✓
    Hex2Oct ✓
    IfError ✓ ✓
    ImAbs
    Imaginary
    ImArgument
    ImConjugate
    ImCos
    ImDiv
    ImExp
    ImLn
    ImLog10
    ImLog2
    ImPower
    ImProduct
    ImReal
    ImSin
    ImSqrt
    ImSub
    ImSum
    IntRate
    IsEven ✓
    IsOdd ✓
    Lcm ✓ ✓
    MDuration ✓
    MRound ✓
    MultiNomial ✓ ✓
    NetworkDays ✓
    Nominal ✓
    Oct2Bin ✓
    Oct2Dec ✓
    Oct2Hex ✓
    OddFPrice
    OddFYield
    OddLPrice
    OddLYield
    Price
    PriceDisc
    PriceMat
    Quotient ✓
    RandBetween ✓
    Received
    SeriesSum ✓
    SqrtPi ✓
    SumIfs ✓ ✓
    TBillEq
    TBillPrice
    TBillYield
    WeekNum ✓
    WorkDay ✓
    Xirr ✓
    Xnpv ✓
    YearFrac ✓
    YieldDisc
    YieldMat
    • Total: 97
    • Implemented: 55 (57%)

    Added functions in Excel 2010

    Name Implemented Array enabled
    NETWORKDAYS.INTL ✓
    WORKDAY.INTL ✓
    AGGREGATE ✓
    CEILING.PRECISE ✓ ✓
    ISO.CEILING ✓ ✓
    CHISQ.DIST
    CHISQ.INV
    CONFIDENCE.T
    COVARIANCE.S
    ERF.PRECISE
    ERFC.PRECISE
    F.DIST
    F.INV
    FLOOR.PRECISE ✓
    GAMMALN.PRECISE
    MODE.MULT
    PERCENTILE.EXC ✓
    PERCENTRANK.EXC
    QUARTILE.EXC ✓
    RANK.AVG ✓ ✓
    T.DIST
    T.INV
    • Total: 22
    • Implemented: 9 (41%)

    Added functions in Excel 2013

    Name Implemented Array enabled
    DAYS ✓ ✓
    ISOWEEKNUM ✓ ✓
    BITAND ✓ ✓
    BITLSHIFT ✓ ✓
    BITOR ✓ ✓
    BITRSHIFT ✓ ✓
    BITXOR ✓ ✓
    IMCOSH
    IMCOT
    IMCSC
    IMCSCH
    IMSEC
    IMSECH
    IMSINH
    IMTAN
    PDURATION ✓ ✓
    RRI ✓ ✓
    ISFORMULA ✓ ✓
    SHEET ✓
    SHEETS ✓ ✓
    IFNA ✓ ✓
    XOR ✓ ✓
    FORMULATEXT ✓ ✓
    ACOT ✓ ✓
    ACOTH ✓ ✓
    ARABIC ✓ ✓
    BASE ✓ ✓
    CEILING.MATH ✓ ✓
    COMBINA ✓ ✓
    COT ✓ ✓
    COTH ✓ ✓
    CSC ✓ ✓
    CSCH ✓ ✓
    DECIMAL ✓ ✓
    FLOOR.MATH ✓ ✓
    ISO.CEILING ✓ ✓
    MUNIT ✓ ✓
    SEC ✓ ✓
    SECH ✓ ✓
    BINOM.DIST.RANGE
    GAMMA
    GAUSS
    PERMUTATIONA ✓ ✓
    PHI
    SKEW.P
    NUMBERVALUE
    UNICHAR ✓ ✓
    UNICODE ✓ ✓
    ENCODEURL
    FILTERXML
    WEBSERVICE
    • Total: 51
    • Implemented: 34 (67%)

    Added functions in Excel 2016

    Name Implemented Array enabled
    FORECAST.LINEAR
    FORECAST.ETS
    FORECAST.ETS.SEASONALITY
    FORECAST.ETS.CONFINT
    FORECAST.ETS.STAT
    TEXTJOIN ✓ ✓
    CONCAT ✓ ✓
    IFS ✓ ✓
    SWITCH ✓ ✓
    MINIFS ✓ ✓
    MAXIFS ✓ ✓
    • Total: 11
    • Implemented: 6 (55%)

    Renamed functions

    This is a list of the functions renamed in Excel.

    • Supported means that FlexCel understands the function and you can add it with the API.

    • Implemented for recalc means that FlexCel knows how to calculate the function.

    Note

    Normally, if a function renamed is implemented for recalc in FlexCel under the old name then it will also be implemented for recalc in the new name.

    But some renamed functions like Norm.S.Dist have a different list of. parameters. Those might not be implemented for recalc.

    Renamed functions in Excel 2010

    New name Old name Supported Implemented for recalc
    BETA.DIST BETADIST ✓
    BETA.INV BETAINV ✓
    BINOM.DIST BINOMDIST ✓ ✓
    BINOM.INV CRITBINOM ✓
    CHISQ.DIST.RT CHIDIST ✓ ✓
    CHISQ.INV.RT CHIINV ✓ ✓
    CHISQ.TEST CHITEST ✓ ✓
    CONFIDENCE.NORM CONFIDENCE ✓ ✓
    COVARIANCE.P COVAR ✓ ✓
    EXPON.DIST EXPONDIST ✓ ✓
    F.DIST.RT FDIST ✓
    F.INV.RT FINV ✓
    F.TEST FTEST ✓
    GAMMA.DIST GAMMADIST ✓ ✓
    GAMMA.INV GAMMAINV ✓ ✓
    HYPGEOM.DIST HYPGEOMDIST ✓
    LOGNORM.DIST LOGNORMDIST ✓
    LOGNORM.INV LOGINV ✓ ✓
    MODE.SNGL MODE ✓ ✓
    NEGBINOM.DIST NEGBINOMDIST ✓
    NORM.DIST NORMDIST ✓ ✓
    NORM.INV NORMINV ✓ ✓
    NORM.S.DIST NORMSDIST ✓
    NORM.S.INV NORMSINV ✓ ✓
    PERCENTILE.INC PERCENTILE ✓ ✓
    PERCENTRANK.INC PERCENTRANK ✓ ✓
    POISSON.DIST POISSON ✓ ✓
    QUARTILE.INC QUARTILE ✓ ✓
    RANK.EQ RANK ✓ ✓
    STDEV.P STDEVP ✓ ✓
    STDEV.S STDEV ✓ ✓
    T.DIST.2T TDIST ✓
    T.DIST.RT TDIST ✓
    T.INV.2T TINV ✓
    T.TEST TTEST ✓
    VAR.P VARP ✓ ✓
    VAR.S VAR ✓ ✓
    WEIBULL.DIST WEIBULL ✓ ✓
    Z.TEST ZTEST ✓ ✓
    • Total: 39
    • Implemented: 25 (64%)
    Back to top FlexCel Studio for the .NET Framework v6.24.0.0
    © 2002 - 2019 tmssoftware.com