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: 468
- Implemented: 353 (75%)
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 |
✓ |
✓ |
| 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 |
✓ |
✓ |
COPILOT |
|
|
DETECTLANGUAGE |
|
|
DROP |
|
|
EXPAND |
|
|
GROUPBY |
|
|
IMAGE |
|
|
PERCENTOF |
|
|
PIVOTBY |
|
|
REGEXEXTRACT |
|
|
REGEXREPLACE |
|
|
REGEXTEST |
|
|
TRANSLATE |
|
|
TRIMRANGE |
|
|
- Total: 39
- Implemented: 24 (62%)
Renamed functions
This is a list of the functions renamed in Excel.
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%)