Supported Excel Functions
This is a list of all the standard Excel functions up to Excel 365.
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.
NOTE
If you are looking for a specific function in your local language and you don't know the English translation, you can use the Excel Translator.
If you are looking for a specific function, use the browser search -> CTRL + F.
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 | ✓ | ✓ |
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 | − | − |
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 | − | − |
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 | − | − |
Added functions in Excel 2016
| Name | Implemented | Array enabled |
|---|---|---|
| FORECAST.LINEAR | − | − |
| FORECAST.ETS | − | − |
| FORECAST.ETS.SEASONALITY | − | − |
| FORECAST.ETS.CONFINT | − | − |
| FORECAST.ETS.STAT | − | − |
| SWITCH | ✓ | ✓ |
Added functions in Excel 2019
| Name | Implemented | Array enabled |
|---|---|---|
| AVERAGEIFS | ✓ | ✓ |
| COUNTIFS | ✓ | ✓ |
| SUMIFS | ✓ | ✓ |
| TEXTJOIN | ✓ | ✓ |
| CONCAT | ✓ | ✓ |
| IFS | ✓ | ✓ |
| MINIFS | ✓ | ✓ |
| MAXIFS | ✓ | ✓ |
Added functions in Office 2021
| Name | Implemented | Array enabled |
|---|---|---|
| FILTER | − | − |
| RANDARRAY | ✓ | ✓ |
| SEQUENCE | ✓ | ✓ |
| SORT | − | − |
| SORTBY | − | − |
| UNIQUE | − | − |
| XLOOKUP | ✓ | ✓ |
| XMATCH | ✓ | ✓ |
| LET | ✓ | ✓ |
| SINGLE | ✓ | ✓ |
Added functions in Office 365
| Name | Implemented | Array enabled |
|---|---|---|
| ARRAYTOTEXT | ✓ | ✓ |
| VALUETOTEXT | ✓ | ✓ |
| BYCOL | − | − |
| BYROW | − | − |
| FIELDVALUE | − | − |
| ISOMITTED | − | − |
| LAMBDA | ✓ | ✓ |
| MAKEARRAY | − | − |
| MAP | − | − |
| REDUCE | − | − |
| SCAN | − | − |
| STOCKHISTORY | − | − |
| TOCOL | − | − |
Was this article helpful?
Still stuck? Submit a request