# Supported Excel functions

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

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**: 419**Implemented**: 312 (74%)

### Built-in functions in 2003

#### Financial

Name | Implemented | Array enabled |
---|---|---|

Db | ✓ | |

Ddb | ✓ | |

Fv | ✓ | |

Ipmt | ✓ | |

Irr | ✓ | |

Mirr | ✓ | |

Nper | ✓ | |

Npv | ✓ | |

Pmt | ✓ | |

PPmt | ✓ | |

Pv | ✓ | |

Rate | ✓ | |

Sln | ✓ | |

Syd | ✓ | |

#### 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 | ✓ | ✓ |

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 | ✓ | ✓ |

Binomdist | ✓ | |

Chidist | ✓ | |

Chiinv | ✓ | |

Chitest | ✓ | ✓ |

Confidence | ✓ | |

Correl | ✓ | |

Count | ✓ | ✓ |

Counta | ✓ | ✓ |

Countblank | ✓ | ✓ |

Countif | ✓ | ✓ |

Covar | ✓ | |

Devsq | ✓ | |

Expondist | ✓ | |

Fisher | ✓ | ✓ |

Fisherinv | ✓ | ✓ |

Frequency | ✓ | ✓ |

Gammadist | ✓ | |

Gammainv | ✓ | |

Gammaln | ✓ | ✓ |

Geomean | ✓ | |

Harmean | ✓ | |

Hypgeomdist | ✓ | |

Intercept | ✓ | |

Kurt | ✓ | |

Large | ✓ | ✓ |

Loginv | ✓ | |

Lognormdist | ✓ | |

Max | ✓ | ✓ |

Maxa | ✓ | ✓ |

Median | ✓ | ✓ |

Min | ✓ | ✓ |

Mina | ✓ | ✓ |

Mode | ✓ | ✓ |

Negbinomdist | ✓ | |

Normdist | ✓ | |

Norminv | ✓ | |

Normsdist | ✓ | ✓ |

Normsinv | ✓ | ✓ |

Pearson | ✓ | ✓ |

Percentile | ✓ | ✓ |

Percentrank | ✓ | |

Permut | ✓ | ✓ |

Poisson | ✓ | |

Quartile | ✓ | ✓ |

Rank | ✓ | |

Rsq | ✓ | ✓ |

Skew | ✓ | ✓ |

Slope | ✓ | ✓ |

Small | ✓ | ✓ |

Standardize | ✓ | ✓ |

Stdev | ✓ | |

Stdeva | ✓ | |

Stdevp | ✓ | |

Stdevpa | ✓ | |

Steyx | ✓ | ✓ |

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 | ✓ | |

#### Text

Name | Implemented | Array enabled |
---|---|---|

Asc | ✓ | ✓ |

Char | ✓ | ✓ |

Clean | ✓ | ✓ |

Code | ✓ | ✓ |

Concatenate | ✓ | ✓ |

Dollar | ✓ | |

Exact | ✓ | |

Find | ✓ | |

Fixed | ✓ | |

Left | ✓ | ✓ |

Len | ✓ | ✓ |

Lower | ✓ | ✓ |

Mid | ✓ | ✓ |

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 | ✓ | ✓ |

Isblank | ✓ | ✓ |

Iserr | ✓ | ✓ |

Iserror | ✓ | ✓ |

Islogical | ✓ | ✓ |

Isna | ✓ | ✓ |

Isnontext | ✓ | ✓ |

Isnumber | ✓ | ✓ |

Isref | ✓ | |

Istext | ✓ | ✓ |

N | ✓ | |

Na | ✓ | ✓ |

Type | ✓ | ✓ |

**Total**: 238**Implemented**: 213 (89%)

### Added functions in Excel 2007

Name | Implemented | Array enabled |
---|---|---|

AverageIf | ✓ | ✓ |

AverageIfs | ✓ | ✓ |

Bin2Dec | ✓ | |

Bin2Hex | ✓ | |

Bin2Oct | ✓ | |

Convert | ✓ | |

CountIfs | ✓ | ✓ |

CoupDayBs | ✓ | |

CoupDays | ✓ | |

CoupDaysNc | ✓ | |

CoupNcd | ✓ | |

CoupNum | ✓ | |

CoupPcd | ✓ | |

Dec2Bin | ✓ | |

Dec2Hex | ✓ | |

Dec2Oct | ✓ | |

Delta | ✓ | |

DollarDe | ✓ | |

DollarFr | ✓ | |

Duration | ✓ | |

EDate | ✓ | |

Effect | ✓ | |

EoMonth | ✓ | |

FactDouble | ✓ | |

Gcd | ✓ | ✓ |

GeStep | ✓ | |

Hex2Bin | ✓ | |

Hex2Dec | ✓ | |

Hex2Oct | ✓ | |

IfError | ✓ | ✓ |

IsEven | ✓ | |

IsOdd | ✓ | |

Lcm | ✓ | ✓ |

MDuration | ✓ | |

MRound | ✓ | |

MultiNomial | ✓ | ✓ |

NetworkDays | ✓ | |

Nominal | ✓ | |

Oct2Bin | ✓ | |

Oct2Dec | ✓ | |

Oct2Hex | ✓ | |

Quotient | ✓ | |

RandBetween | ✓ | |

SeriesSum | ✓ | |

SqrtPi | ✓ | |

SumIfs | ✓ | ✓ |

WeekNum | ✓ | |

WorkDay | ✓ | |

Xirr | ✓ | |

Xnpv | ✓ | |

YearFrac | ✓ | |

**Total**: 97**Implemented**: 51 (53%)

### Added functions in Excel 2010

Name | Implemented | Array enabled |
---|---|---|

NETWORKDAYS.INTL | ✓ | |

WORKDAY.INTL | ✓ | |

AGGREGATE | ✓ | |

CEILING.PRECISE | ✓ | ✓ |

ISO.CEILING | ✓ | ✓ |

FLOOR.PRECISE | ✓ | |

PERCENTILE.EXC | ✓ | |

QUARTILE.EXC | ✓ | |

**Total**: 22**Implemented**: 8 (36%)

### Added functions in Excel 2013

Name | Implemented | Array enabled |
---|---|---|

DAYS | ✓ | ✓ |

ISOWEEKNUM | ✓ | ✓ |

BITAND | ✓ | ✓ |

BITLSHIFT | ✓ | ✓ |

BITOR | ✓ | ✓ |

BITRSHIFT | ✓ | ✓ |

BITXOR | ✓ | ✓ |

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 | ✓ | ✓ |

PERMUTATIONA | ✓ | ✓ |

UNICHAR | ✓ | ✓ |

UNICODE | ✓ | ✓ |

**Total**: 51**Implemented**: 34 (67%)

### Added functions in Excel 2016

Name | Implemented | Array enabled |
---|---|---|

TEXTJOIN | ✓ | ✓ |

CONCAT | ✓ | ✓ |

IFS | ✓ | ✓ |

SWITCH | ✓ | ✓ |

MINIFS | ✓ | ✓ |

MAXIFS | ✓ | ✓ |

**Total**: 11**Implemented**: 6 (55%)

## 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 |
---|---|---|---|

BETADIST | ✓ | ||

BETAINV | ✓ | ||

BINOM.DIST | BINOMDIST | ✓ | ✓ |

CRITBINOM | ✓ | ||

CHISQ.DIST.RT | CHIDIST | ✓ | ✓ |

CHISQ.INV.RT | CHIINV | ✓ | ✓ |

CHISQ.TEST | CHITEST | ✓ | ✓ |

CONFIDENCE.NORM | CONFIDENCE | ✓ | ✓ |

COVARIANCE.P | COVAR | ✓ | ✓ |

EXPON.DIST | EXPONDIST | ✓ | ✓ |

FDIST | ✓ | ||

FINV | ✓ | ||

FTEST | ✓ | ||

GAMMA.DIST | GAMMADIST | ✓ | ✓ |

GAMMA.INV | GAMMAINV | ✓ | ✓ |

HYPGEOMDIST | ✓ | ||

LOGNORMDIST | ✓ | ||

LOGNORM.INV | LOGINV | ✓ | ✓ |

MODE.SNGL | MODE | ✓ | ✓ |

NEGBINOMDIST | ✓ | ||

NORM.DIST | NORMDIST | ✓ | ✓ |

NORM.INV | NORMINV | ✓ | ✓ |

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 | ✓ | ✓ |

TDIST | ✓ | ||

TDIST | ✓ | ||

TINV | ✓ | ||

TTEST | ✓ | ||

VAR.P | VARP | ✓ | ✓ |

VAR.S | VAR | ✓ | ✓ |

WEIBULL.DIST | WEIBULL | ✓ | ✓ |

Z.TEST | ZTEST | ✓ | ✓ |

**Total**: 39**Implemented**: 25 (64%)