Normal Microsoft changes some functions name in Excel 2010, but the functions work no differently from old ones, just name changed.
To keep backward compatibility, we can register new names but calling the same functions.
| new name in 2010 | old name |
|---|---|
| BINOM.DIST | BINOMDIST |
| CHISQ.DIST.RT | CHIDIST |
| CHISQ.INV.RT | CHIINV |
| EXPON.DIST | EXPONDIST |
| F.DIST.RT | FDIST |
| F.INV.RT | FINV |
| GAMMA.DIST | GAMMADIST |
| GAMMA.INV | GAMMAINV |
| HYPGEOM.DIST | HYPGEOMDIST |
| MODE.SNGL | MODE |
| NORM.DIST | NORMDIST |
| POISSON.DIST | POISSON |
| RANK.EQ | RANK |
| STDE.V | STDEV |
| T.INV.2T | TINV |
| VAR.P | VARP |
| VAR.S | VAR |
| WEIBULL.DIST | WEIBULL |
Detail:
- list of renamed functions: https://support.office.com/en-us/article/What-s-New-Changes-made-to-Excel-functions-355d08c8-8358-4ecb-b6eb-e2e443e98aac?ui=en-US&rs=en-US&ad=US&fromAR=1#bm2
- https://www.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Features_and_Usages/Supported_Formula_Functions
- STDEVP is also changed to STDEV.P, but ZSS doesn't support it.
- TDIST is changed to T.DIST.2T and T.DIST.RT but required arguments number also change from 3 to 2. It's an special case.
