> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/build-spark-services/neuron/legacy-service-types.md).

# Type3 function support

The legacy `Type3` service type supports a large number of Excel functions, but **not** the ones listed below. Excel functions introduced after April 6th 2022 are not included in this list.

{% hint style="danger" %}
Please note that the `Type3` engine is no longer being developed. There are no plans to implement these functions in this service type in the future.
{% endhint %}

{% hint style="success" %}
Please refer to [Neuron function support](/build-spark-services/neuron/neuron-function-support.md) for more information about which functions are supported by Neuron.
{% endhint %}

## `Type3` Unsupported Functions

| Category                  | FunctIon                 |
| ------------------------- | ------------------------ |
| **Add-in and Automation** | CALL                     |
|                           | EUROCONVERT              |
|                           | REGISTER.ID              |
| **Compatibility**         | BETADIST                 |
|                           | BETAINV                  |
|                           | FDIST                    |
|                           | FINV                     |
|                           | HYPGEOMDIST              |
|                           | NEGBINOMDIST             |
|                           | TDIST                    |
|                           | TINV                     |
|                           | TTEST                    |
| **Cube**                  | CUBEKPIMEMBER            |
|                           | CUBEMEMBER               |
|                           | CUBEMEMBERPROPERTY       |
|                           | CUBERANKEDMEMBER         |
|                           | CUBESET                  |
|                           | CUBESETCOUNT             |
|                           | CUBEVALUE                |
| **Database**              | GETPIVOTDATA             |
| **Engineering**           | BESSELI                  |
|                           | BESSELJ                  |
|                           | BESSELK                  |
|                           | BESSELY                  |
|                           | COMPLEX                  |
|                           | ERF                      |
|                           | ERF.PRECISE              |
|                           | ERFC                     |
|                           | ERFC.PRECISE             |
|                           | IMABS                    |
|                           | IMAGINARY                |
|                           | IMARGUMENT               |
|                           | IMCONJUGATE              |
|                           | IMCOS                    |
|                           | IMCOSH                   |
|                           | IMCOT                    |
|                           | IMCSC                    |
|                           | IMCSCH                   |
|                           | IMDIV                    |
|                           | IMEXP                    |
|                           | IMLN                     |
|                           | IMLOG10                  |
|                           | IMLOG2                   |
|                           | IMPOWER                  |
|                           | IMPRODUCT                |
|                           | IMREAL                   |
|                           | IMSEC                    |
|                           | IMSECH                   |
|                           | IMSIN                    |
|                           | IMSINH                   |
|                           | IMSQRT                   |
|                           | IMSUB                    |
|                           | IMSUM                    |
|                           | IMTAN                    |
| **Financial**             | AMORDEGRC                |
|                           | AMORLINC                 |
|                           | DISC                     |
|                           | FVSCHEDULE               |
|                           | INTRATE                  |
|                           | ISPMT                    |
|                           | ODDFPRICE                |
|                           | ODDFYIELD                |
|                           | ODDLPRICE                |
|                           | ODDLYIELD                |
|                           | PRICE                    |
|                           | PRICEDISC                |
|                           | PRICEMAT                 |
|                           | RECEIVED                 |
|                           | STOCKHISTORY             |
|                           | TBILLEQ                  |
|                           | TBILLPRICE               |
|                           | TBILLYIELD               |
|                           | VDB                      |
|                           | YIELDDISC                |
|                           | YIELDMAT                 |
| **Information**           | INFO                     |
|                           | ISOMITTED                |
| **Logical**               | BYCOL                    |
|                           | BYROW                    |
|                           | IFS                      |
|                           | LAMBDA                   |
|                           | LET                      |
|                           | MAKEARRAY                |
|                           | MAP                      |
|                           | REDUCE                   |
|                           | SCAN                     |
|                           | SWITCH                   |
| **Lookup and reference**  | ARRAYTOTEXT              |
|                           | CHOOSECOLS               |
|                           | CHOOSEROWS               |
|                           | DROP                     |
|                           | EXPAND                   |
|                           | FILTER                   |
|                           | FORMULATEXT              |
|                           | GETPIVOTDATA             |
|                           | HSTACK                   |
|                           | RTD                      |
|                           | SORT                     |
|                           | SORTBY                   |
|                           | TAKE                     |
|                           | TOCOL                    |
|                           | TOROW                    |
|                           | UNIQUE                   |
|                           | VSTACK                   |
|                           | WRAPCOLS                 |
|                           | WRAPROWS                 |
|                           | XLOOKUP                  |
|                           | XMATCH                   |
| **Math and trigonometry** | MDETERM                  |
|                           | MINVERSE                 |
|                           | RANDARRAY                |
|                           | SEQUENCE                 |
| **Statistical**           | BETA.DIST                |
|                           | BETA.INV                 |
|                           | BINOM.DIST.RANGE         |
|                           | BINOM.INV                |
|                           | CHISQ.DIST               |
|                           | CHISQ.INV                |
|                           | CONFIDENCE.T             |
|                           | COVARIANCE.S             |
|                           | CRITBINOM                |
|                           | F.DIST                   |
|                           | F.DIST.RT                |
|                           | F.INV                    |
|                           | F.INV.RT                 |
|                           | F.TEST                   |
|                           | FORECAST.ETS             |
|                           | FORECAST.ETS.CONFINT     |
|                           | FORECAST.ETS.SEASONALITY |
|                           | FORECAST.ETS.STAT        |
|                           | FORECAST.LINEAR          |
|                           | FTEST                    |
|                           | GAMMA                    |
|                           | GAMMALN.PRECISE          |
|                           | GAUSS                    |
|                           | GROWTH                   |
|                           | HYPGEOM.DIST             |
|                           | LOGNORM.DIST             |
|                           | LOGNORMDIST              |
|                           | MAXIFS                   |
|                           | MINIFS                   |
|                           | MODE.MULT                |
|                           | NEGBINOM.DIST            |
|                           | NORM.S.DIST              |
|                           | PERCENTRANK.EXC          |
|                           | PHI                      |
|                           | PROB                     |
|                           | SKEW\.P                  |
|                           | T.DIST                   |
|                           | T.DIST.2T                |
|                           | T.DIST.RT                |
|                           | T.INV                    |
|                           | T.INV.2T                 |
|                           | T.TEST                   |
|                           | TREND                    |
|                           | TRIMMEAN                 |
|                           | WEIBULL.DIST             |
| **Text**                  | ASC                      |
|                           | BAHTTEXT                 |
|                           | CONCAT                   |
|                           | DBCS                     |
|                           | JIS                      |
|                           | NUMBERVALUE              |
|                           | PHONETIC                 |
|                           | TEXTAFTER                |
|                           | TEXTBEFORE               |
|                           | TEXTJOIN                 |
|                           | TEXTSPLIT                |
|                           | VALUETOTEXT              |
| **Web**                   | ENCODEURL                |
|                           | FILTERXML                |
|                           | WEBSERVICE               |