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