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

Table of Contents