Table of Contents

Supported Excel functions

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

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: 455
  • Implemented: 353 (78%)

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: 214 (90%)

Added functions in Excel 2007

Name Implemented Array enabled
ACCRINT ✓
ACCRINTM ✓
AMORDEGRC
AMORLINC
AVERAGEIF ✓ ✓
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC ✓
BIN2HEX ✓
BIN2OCT ✓
COMPLEX
CONVERT ✓
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 ✓
TBILLEQ
TBILLPRICE
TBILLYIELD
WEEKNUM ✓
WORKDAY ✓
XIRR ✓
XNPV ✓
YEARFRAC ✓
YIELDDISC
YIELDMAT
  • Total: 94
  • Implemented: 52 (55%)

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: 35 (69%)

Added functions in Excel 2016

Name Implemented Array enabled
FORECAST.LINEAR
FORECAST.ETS
FORECAST.ETS.SEASONALITY
FORECAST.ETS.CONFINT
FORECAST.ETS.STAT
SWITCH ✓ ✓
  • Total: 6
  • Implemented: 1 (17%)

Added functions in Excel 2019

Name Implemented Array enabled
AVERAGEIFS ✓ ✓
COUNTIFS ✓ ✓
SUMIFS ✓ ✓
TEXTJOIN ✓ ✓
CONCAT ✓ ✓
IFS ✓ ✓
MINIFS ✓ ✓
MAXIFS ✓ ✓
  • Total: 8
  • Implemented: 8 (100%)

Added functions in Office 2021

Name Implemented Array enabled
FILTER ✓ ✓
RANDARRAY ✓ ✓
SEQUENCE ✓ ✓
SORT ✓ ✓
SORTBY ✓ ✓
UNIQUE ✓ ✓
XLOOKUP ✓ ✓
XMATCH ✓ ✓
LET ✓ ✓
SINGLE ✓ ✓
  • Total: 10
  • Implemented: 10 (100%)

Added functions in Office 365

Name Implemented Array enabled
ARRAYTOTEXT ✓ ✓
VALUETOTEXT ✓ ✓
BYCOL ✓ ✓
BYROW ✓ ✓
FIELDVALUE
ISOMITTED ✓ ✓
LAMBDA ✓ ✓
MAKEARRAY ✓ ✓
MAP ✓ ✓
REDUCE ✓ ✓
SCAN ✓ ✓
STOCKHISTORY
TEXTBEFORE ✓ ✓
TEXTAFTER ✓ ✓
TEXTSPLIT ✓ ✓
VSTACK ✓ ✓
HSTACK ✓ ✓
TOROW ✓ ✓
TOCOL ✓ ✓
WRAPROWS ✓ ✓
WRAPCOLS ✓ ✓
TAKE ✓ ✓
DROP ✓ ✓
CHOOSEROWS ✓ ✓
CHOOSECOLS ✓ ✓
EXPAND ✓ ✓
  • Total: 26
  • Implemented: 24 (92%)

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