# Neuron function support

Also see [Neuron](/build-spark-services/neuron.md) [Neuron release history](/build-spark-services/neuron/neuron-release-history.md).

## Neuron supported functions

| Category              | Function                 |
| --------------------- | ------------------------ |
| Compatibility         | BETADIST                 |
|                       | BETAINV                  |
|                       | BINOMDIST                |
|                       | CEILING                  |
|                       | CHIDIST                  |
|                       | CHIINV                   |
|                       | CHITEST                  |
|                       | CONFIDENCE               |
|                       | COVAR                    |
|                       | CRITBINOM                |
|                       | EXPONDIST                |
|                       | FDIST                    |
|                       | FINV                     |
|                       | FLOOR                    |
|                       | FTEST                    |
|                       | GAMMADIST                |
|                       | GAMMAINV                 |
|                       | HYPGEOMDIST              |
|                       | LOGINV                   |
|                       | LOGNORMDIST              |
|                       | MODE                     |
|                       | NEGBINOMDIST             |
|                       | NORM.INV                 |
|                       | NORMDIST                 |
|                       | NORMSDIST                |
|                       | NORMSINV                 |
|                       | PERCENTILE               |
|                       | PERCENTRANK              |
|                       | POISSON                  |
|                       | QUARTILE                 |
|                       | RANK                     |
|                       | STDEV                    |
|                       | STDEVP                   |
|                       | TDIST                    |
|                       | TINV                     |
|                       | TTEST                    |
|                       | VAR                      |
|                       | VARP                     |
|                       | WEIBULL                  |
| Database              | DAVERAGE                 |
|                       | DCOUNT                   |
|                       | DCOUNTA                  |
|                       | DGET                     |
|                       | DMAX                     |
|                       | DMIN                     |
|                       | DPRODUCT                 |
|                       | DSTDEV                   |
|                       | DSTDEVP                  |
|                       | DSUM                     |
|                       | DVAR                     |
|                       | DVARP                    |
| Date and time         | DATE                     |
|                       | DATEDIF                  |
|                       | DATEVALUE                |
|                       | DAY                      |
|                       | DAYS                     |
|                       | DAYS360                  |
|                       | EDATE                    |
|                       | EOMONTH                  |
|                       | HOUR                     |
|                       | ISOWEEKNUM               |
|                       | MINUTE                   |
|                       | MONTH                    |
|                       | NETWORKDAYS              |
|                       | NETWORKDAYS.INTL         |
|                       | NOW                      |
|                       | SECOND                   |
|                       | TIME                     |
|                       | TIMEVALUE                |
|                       | TODAY                    |
|                       | WEEKDAY                  |
|                       | WEEKNUM                  |
|                       | WORKDAY                  |
|                       | WORKDAY.INTL             |
|                       | YEAR                     |
|                       | YEARFRAC                 |
| Engineering           | BESSELI                  |
|                       | BESSELJ                  |
|                       | BESSELK                  |
|                       | BESSELY                  |
|                       | BIN2DEC                  |
|                       | BIN2HEX                  |
|                       | BIN2OCT                  |
|                       | BITAND                   |
|                       | BITLSHIFT                |
|                       | BITOR                    |
|                       | BITRSHIFT                |
|                       | BITXOR                   |
|                       | COMPLEX                  |
|                       | DEC2BIN                  |
|                       | DEC2HEX                  |
|                       | DEC2OCT                  |
|                       | DELTA                    |
|                       | ERF                      |
|                       | ERF.PRECISE              |
|                       | ERFC                     |
|                       | ERFC.PRECISE             |
|                       | GESTEP                   |
|                       | HEX2BIN                  |
|                       | HEX2DEC                  |
|                       | HEX2OCT                  |
|                       | 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                    |
|                       | OCT2BIN                  |
|                       | OCT2DEC                  |
|                       | OCT2HEX                  |
| Financial             | ACCRINT                  |
|                       | ACCRINTM                 |
|                       | AMORLINC                 |
|                       | AND                      |
|                       | COUPDAYBS                |
|                       | COUPDAYS                 |
|                       | COUPDAYSNC               |
|                       | COUPNCD                  |
|                       | COUPNUM                  |
|                       | COUPPCD                  |
|                       | CUMIPMT                  |
|                       | CUMPRINC                 |
|                       | DB                       |
|                       | DDB                      |
|                       | DISC                     |
|                       | DOLLARDE                 |
|                       | DOLLARFR                 |
|                       | DURATION                 |
|                       | EFFECT                   |
|                       | FV                       |
|                       | FVSCHEDULE               |
|                       | INTRATE                  |
|                       | IPMT                     |
|                       | IRR                      |
|                       | ISPMT                    |
|                       | MDURATION                |
|                       | MIRR                     |
|                       | NOMINAL                  |
|                       | NPER                     |
|                       | NPV                      |
|                       | ODDFPRICE                |
|                       | ODDFYIELD                |
|                       | ODDLPRICE                |
|                       | ODDLYIELD                |
|                       | PDURATION                |
|                       | PMT                      |
|                       | PPMT                     |
|                       | PRICE                    |
|                       | PRICEDISC                |
|                       | PRICEMAT                 |
|                       | PV                       |
|                       | RATE                     |
|                       | RECEIVED                 |
|                       | RRI                      |
|                       | SLN                      |
|                       | SYD                      |
|                       | TBILLEQ                  |
|                       | TBILLPRICE               |
|                       | TBILLYIELD               |
|                       | VDB                      |
|                       | XIRR                     |
|                       | XNPV                     |
|                       | YIELD                    |
|                       | YIELDDISC                |
|                       | YIELDMAT                 |
| Information           | CELL                     |
|                       | ERROR.TYPE               |
|                       | INFO                     |
|                       | ISBLANK                  |
|                       | ISERR                    |
|                       | ISERROR                  |
|                       | ISEVEN                   |
|                       | ISLOGICAL                |
|                       | ISNA                     |
|                       | ISNONTEXT                |
|                       | ISNUMBER                 |
|                       | ISODD                    |
|                       | ISOMITTED                |
|                       | ISREF                    |
|                       | ISTEXT                   |
|                       | N                        |
|                       | NA                       |
|                       | SHEET                    |
|                       | SHEETS                   |
|                       | TYPE                     |
| Logical               | ARABIC                   |
|                       | BYCOL                    |
|                       | BYROW                    |
|                       | IF                       |
|                       | IFERROR                  |
|                       | IFNA                     |
|                       | IFS                      |
|                       | LAMBDA                   |
|                       | LET                      |
|                       | MAKEARRAY                |
|                       | MAP                      |
|                       | NOT                      |
|                       | OR                       |
|                       | REDUCE                   |
|                       | SCAN                     |
|                       | SWITCH                   |
|                       | XOR                      |
|                       | FALSE                    |
|                       | TRUE                     |
| Lookup and reference  | AMORDEGRC                |
|                       | AREAS                    |
|                       | ARRAYTOTEXT              |
|                       | CHOOSE                   |
|                       | CHOOSECOLS               |
|                       | CHOOSEROWS               |
|                       | COLUMN                   |
|                       | COLUMNS                  |
|                       | DROP                     |
|                       | EXPAND                   |
|                       | FILTER                   |
|                       | FORMULATEXT              |
|                       | HLOOKUP                  |
|                       | HSTACK                   |
|                       | INDEX                    |
|                       | INDIRECT                 |
|                       | LOOKUP                   |
|                       | MATCH                    |
|                       | OFFSET                   |
|                       | ROW                      |
|                       | ROWS                     |
|                       | SORT                     |
|                       | SORTBY                   |
|                       | TAKE                     |
|                       | TOCOL                    |
|                       | TOROW                    |
|                       | TRANSPOSE                |
|                       | UNIQUE                   |
|                       | VLOOKUP                  |
|                       | VSTACK                   |
|                       | WRAPCOLS                 |
|                       | WRAPROWS                 |
|                       | XLOOKUP                  |
|                       | XMATCH                   |
| Math and trigonometry | ABS                      |
|                       | ACOS                     |
|                       | ACOSH                    |
|                       | ACOT                     |
|                       | ACOTH                    |
|                       | ADDRESS                  |
|                       | AGGREGATE                |
|                       | ASINH                    |
|                       | ATAN                     |
|                       | ATAN2                    |
|                       | ATANH                    |
|                       | AVEDEV                   |
|                       | BASE                     |
|                       | CEILING.MATH             |
|                       | CEILING.PRECISE          |
|                       | COMBIN                   |
|                       | COMBINA                  |
|                       | COS                      |
|                       | COSH                     |
|                       | COT                      |
|                       | COTH                     |
|                       | CSC                      |
|                       | CSCH                     |
|                       | DECIMAL                  |
|                       | DEGREES                  |
|                       | EVEN                     |
|                       | EXP                      |
|                       | FACT                     |
|                       | FACTDOUBLE               |
|                       | FLOOR.MATH               |
|                       | FLOOR.PRECISE            |
|                       | GCD                      |
|                       | INT                      |
|                       | ISO.CEILING              |
|                       | LCM                      |
|                       | LN                       |
|                       | LOG                      |
|                       | LOG10                    |
|                       | MDETERM                  |
|                       | MINVERSE                 |
|                       | MMULT                    |
|                       | MOD                      |
|                       | MROUND                   |
|                       | MULTINOMIAL              |
|                       | MUNIT                    |
|                       | ODD                      |
|                       | PI                       |
|                       | POWER                    |
|                       | PRODUCT                  |
|                       | QUOTIENT                 |
|                       | RADIANS                  |
|                       | RAND                     |
|                       | RANDARRAY                |
|                       | RANDBETWEEN              |
|                       | ROMAN                    |
|                       | ROUND                    |
|                       | ROUNDDOWN                |
|                       | ROUNDUP                  |
|                       | SEC                      |
|                       | SECH                     |
|                       | SEQUENCE                 |
|                       | SERIESSUM                |
|                       | SIGN                     |
|                       | SIN                      |
|                       | SINH                     |
|                       | SQRT                     |
|                       | SQRTPI                   |
|                       | SUBTOTAL                 |
|                       | SUM                      |
|                       | SUMIF                    |
|                       | SUMIFS                   |
|                       | SUMPRODUCT               |
|                       | SUMSQ                    |
|                       | SUMX2MY2                 |
|                       | SUMX2PY2                 |
|                       | SUMXMY2                  |
|                       | TAN                      |
|                       | TANH                     |
|                       | TRUNC                    |
| Statistical           | AVERAGE                  |
|                       | AVERAGEA                 |
|                       | AVERAGEIF                |
|                       | AVERAGEIFS               |
|                       | BETA.DIST                |
|                       | BETA.INV                 |
|                       | BINOM.DIST               |
|                       | BINOM.DIST.RANGE         |
|                       | BINOM.INV                |
|                       | CHISQ.DIST               |
|                       | CHISQ.DIST.RT            |
|                       | CHISQ.INV                |
|                       | CHISQ.INV.RT             |
|                       | CHISQ.TEST               |
|                       | CONFIDENCE.NORM          |
|                       | CONFIDENCE.T             |
|                       | CORREL                   |
|                       | COUNT                    |
|                       | COUNTA                   |
|                       | COUNTBLANK               |
|                       | COUNTIF                  |
|                       | COUNTIFS                 |
|                       | COVARIANCE.P             |
|                       | COVARIANCE.S             |
|                       | DEVSQ                    |
|                       | EXPON.DIST               |
|                       | F.DIST                   |
|                       | F.DIST.RT                |
|                       | F.INV                    |
|                       | F.INV.RT                 |
|                       | F.TEST                   |
|                       | FISHER                   |
|                       | FISHERINV                |
|                       | FORECAST                 |
|                       | FORECAST.ETS             |
|                       | FORECAST.ETS.CONFINT     |
|                       | FORECAST.ETS.SEASONALITY |
|                       | FORECAST.ETS.STAT        |
|                       | FORECAST.LINEAR          |
|                       | FREQUENCY                |
|                       | GAMMA                    |
|                       | GAMMA.DIST               |
|                       | GAMMA.INV                |
|                       | GAMMALN                  |
|                       | GAMMALN.PRECISE          |
|                       | GAUSS                    |
|                       | GEOMEAN                  |
|                       | GROWTH                   |
|                       | HARMEAN                  |
|                       | HYPGEOM.DIST             |
|                       | INTERCEPT                |
|                       | KURT                     |
|                       | LARGE                    |
|                       | LINEST                   |
|                       | LOGEST                   |
|                       | LOGNORM.DIST             |
|                       | LOGNORM.INV              |
|                       | MAX                      |
|                       | MAXA                     |
|                       | MAXIFS                   |
|                       | MEDIAN                   |
|                       | MIN                      |
|                       | MINA                     |
|                       | MINIFS                   |
|                       | MODE.MULT                |
|                       | MODE.SNGL                |
|                       | NEGBINOM.DIST            |
|                       | NORM.DIST                |
|                       | NORM.S.DIST              |
|                       | NORM.S.INV               |
|                       | NORMINV                  |
|                       | PEARSON                  |
|                       | PERCENTILE.EXC           |
|                       | PERCENTILE.INC           |
|                       | PERCENTRANK.EXC          |
|                       | PERCENTRANK.INC          |
|                       | PERMUT                   |
|                       | PERMUTATIONA             |
|                       | PHI                      |
|                       | POISSON.DIST             |
|                       | PROB                     |
|                       | QUARTILE.EXC             |
|                       | QUARTILE.INC             |
|                       | RANK.AVG                 |
|                       | RANK.EQ                  |
|                       | RSQ                      |
|                       | SKEW                     |
|                       | SKEW\.P                  |
|                       | SLOPE                    |
|                       | SMALL                    |
|                       | STANDARDIZE              |
|                       | STDEV.P                  |
|                       | STDEV.S                  |
|                       | STDEVA                   |
|                       | STDEVPA                  |
|                       | STEYX                    |
|                       | T.DIST                   |
|                       | T.DIST.2T                |
|                       | T.DIST.RT                |
|                       | T.INV                    |
|                       | T.INV.2T                 |
|                       | T.TEST                   |
|                       | TREND                    |
|                       | TRIMMEAN                 |
|                       | VAR.P                    |
|                       | VAR.S                    |
|                       | VARA                     |
|                       | VARPA                    |
|                       | WEIBULL.DIST             |
|                       | Z.TEST                   |
|                       | ZTEST                    |
| Text                  | ASC                      |
|                       | ASIN                     |
|                       | CHAR                     |
|                       | CLEAN                    |
|                       | CODE                     |
|                       | CONCAT                   |
|                       | CONCATENATE              |
|                       | DBCS                     |
|                       | DOLLAR                   |
|                       | EXACT                    |
|                       | FIND                     |
|                       | FINDB                    |
|                       | FIXED                    |
|                       | JIS                      |
|                       | LEFT                     |
|                       | LEFTB                    |
|                       | LEN                      |
|                       | LENB                     |
|                       | LONGTEXT                 |
|                       | LOWER                    |
|                       | MID                      |
|                       | MIDB                     |
|                       | NUMBERVALUE              |
|                       | PHONETIC                 |
|                       | PROPER                   |
|                       | REPLACE                  |
|                       | REPLACEB                 |
|                       | REPT                     |
|                       | RIGHT                    |
|                       | RIGHTB                   |
|                       | SEARCH                   |
|                       | SEARCHB                  |
|                       | SUBSTITUTE               |
|                       | T                        |
|                       | TEXT                     |
|                       | TEXTAFTER                |
|                       | TEXTBEFORE               |
|                       | TEXTJOIN                 |
|                       | TEXTSPLIT                |
|                       | TRIM                     |
|                       | UNICHAR                  |
|                       | UNICODE                  |
|                       | UPPER                    |
|                       | VALUE                    |
|                       | VALUETOTEXT              |
| Web                   | ENCODEURL                |
|                       | FILTERXML                |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.coherent.global/build-spark-services/neuron/neuron-function-support.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.