Excel function coverage

This table covers 520 distinct Excel function names from Microsoft's category catalog, updated 2026-06-25 and retrieved 2026-10-30. It includes compatibility names and add-in functions. It is a pinned catalog, not a claim to cover functions Microsoft adds after that date.

The full engine has 216 supported, 93 partly supported, and 211 not supported names in this catalog. Aliases count as separate Excel names. Functions outside the catalog remain in the function contract.

How to read the table

Full engine is @sheetwrite/formulas. Lite engine is the default @sheetwrite/wasm package. Importing the full package alone does not select it; see engine builds.
Supported means registered and implemented within the linked Sheetwrite signature and semantic contract. It does not mean complete Excel parity, array broadcasting for every scalar function, unlimited numerical precision, or reviewed external results.
Partly supported means implemented with a known Excel difference, marked as divergent in the formula contract. The row states the difference. Shared resource limits are documented in the bounded evaluation contract.
Not supported means not registered in that engine; the call evaluates to #NAME?. A function that is only in the full engine is not a broken lite implementation. Unsupported by design marks a name that the contract's unsupported categories exclude on purpose; other missing names are open gaps.
Availability and aliases come from the formula contract, checked against the Rust parser registry and the full engine's analysis registries every time this page is generated or checked. The Microsoft catalog stores names, categories and source links only.
To refresh the baseline, update scripts/excel-functions.json from the linked Microsoft catalog. Keep one row per name, split compound names, omit the featured-function duplicates, and prefer a function's current category over its compatibility duplicate. Run bun run docs:generate, then bun run docs:check.
Reviewed external workbook results are separate from registry coverage; see compatibility results.

Compatibility

Excel function	Full engine	Lite engine	Notes and differences
`BETADIST`	Not supported	Not supported	Not registered in either engine.
`BETAINV`	Not supported	Not supported	Not registered in either engine.
`BINOMDIST`	Not supported	Not supported	Not registered in either engine.
`CHIDIST`	Not supported	Not supported	Not registered in either engine.
`CHIINV`	Not supported	Not supported	Not registered in either engine.
`CHITEST`	Not supported	Not supported	Not registered in either engine.
`CONFIDENCE`	Not supported	Not supported	Not registered in either engine.
`COVAR`	Not supported	Not supported	Not registered in either engine.
`CRITBINOM`	Not supported	Not supported	Not registered in either engine.
`EXPONDIST`	Not supported	Not supported	Not registered in either engine.
`FDIST`	Not supported	Not supported	Not registered in either engine.
`FINV`	Not supported	Not supported	Not registered in either engine.
`FTEST`	Not supported	Not supported	Not registered in either engine.
`GAMMADIST`	Not supported	Not supported	Not registered in either engine.
`GAMMAINV`	Not supported	Not supported	Not registered in either engine.
`HYPGEOMDIST`	Not supported	Not supported	Not registered in either engine.
`LOGINV`	Not supported	Not supported	Not registered in either engine.
`LOGNORMDIST`	Not supported	Not supported	Not registered in either engine.
`MODE`	Not supported	Not supported	Not registered in either engine.
`NEGBINOMDIST`	Not supported	Not supported	Not registered in either engine.
`NORMDIST`	Not supported	Not supported	Not registered in either engine.
`NORMINV`	Not supported	Not supported	Not registered in either engine.
`NORMSDIST`	Not supported	Not supported	Not registered in either engine.
`NORMSINV`	Not supported	Not supported	Not registered in either engine.
`PERCENTILE`	Supported	Not supported	Lite engine: not registered. Contract
`PERCENTRANK`	Supported	Not supported	Lite engine: not registered. Contract
`POISSON`	Not supported	Not supported	Not registered in either engine.
`QUARTILE`	Supported	Not supported	Lite engine: not registered. Contract
`RANK`	Supported	Not supported	Lite engine: not registered. Contract
`STDEV`	Not supported	Not supported	Not registered in either engine.
`STDEVP`	Not supported	Not supported	Not registered in either engine.
`TDIST`	Not supported	Not supported	Not registered in either engine.
`TINV`	Not supported	Not supported	Not registered in either engine.
`TTEST`	Not supported	Not supported	Not registered in either engine.
`VAR`	Not supported	Not supported	Not registered in either engine.
`VARP`	Not supported	Not supported	Not registered in either engine.
`WEIBULL`	Not supported	Not supported	Not registered in either engine.
`ZTEST`	Not supported	Not supported	Not registered in either engine.

Cubes

Excel function	Full engine	Lite engine	Notes and differences
`CUBEKPIMEMBER`	Not supported	Not supported	Not registered in either engine.
`CUBEMEMBER`	Not supported	Not supported	Unsupported by design: OLAP cube members, sets, and values are not resolved.
`CUBEMEMBERPROPERTY`	Not supported	Not supported	Not registered in either engine.
`CUBERANKEDMEMBER`	Not supported	Not supported	Not registered in either engine.
`CUBESET`	Not supported	Not supported	Unsupported by design: OLAP cube members, sets, and values are not resolved.
`CUBESETCOUNT`	Not supported	Not supported	Not registered in either engine.
`CUBEVALUE`	Not supported	Not supported	Unsupported by design: OLAP cube members, sets, and values are not resolved.

Database functions

Excel function	Full engine	Lite engine	Notes and differences
`DAVERAGE`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DCOUNT`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DCOUNTA`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DGET`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DMAX`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DMIN`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DPRODUCT`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DSTDEV`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DSTDEVP`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DSUM`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DVAR`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract
`DVARP`	Partly supported	Not supported	Lite engine: not registered. Database criteria use header names, AND across columns, and OR across rows. Custom formula predicates under headers that are not database fields are not supported. A not-equal criterion does not match a value of a different type, so "<>" skips numbers in a field that Excel counts as nonblank (#246). Contract

Date and time functions

Excel function	Full engine	Lite engine	Notes and differences
`DATE`	Partly supported	Partly supported	DATE can return a negative serial, as in =DATE(1900,1,-1). Excel returns #NUM! (#246). Contract
`DATEDIF`	Supported	Not supported	Lite engine: not registered. Contract
`DATEVALUE`	Supported	Supported	Contract
`DAY`	Partly supported	Partly supported	Serial 0 and blank cells read as 1899-12-31. Excel returns year 1900, month 1 and day 0 (#246). Negative serials are accepted. Excel returns #NUM! (#246). Contract
`DAYS`	Supported	Supported	Contract
`DAYS360`	Supported	Supported	Contract
`EDATE`	Supported	Supported	Contract
`EOMONTH`	Supported	Supported	Contract
`HOUR`	Supported	Supported	Contract
`ISOWEEKNUM`	Supported	Not supported	Lite engine: not registered. Contract
`MINUTE`	Supported	Supported	Contract
`MONTH`	Partly supported	Partly supported	Serial 0 and blank cells read as 1899-12-31. Excel returns year 1900, month 1 and day 0 (#246). Negative serials are accepted. Excel returns #NUM! (#246). Contract
`NETWORKDAYS`	Supported	Supported	Contract
`NETWORKDAYS.INTL`	Supported	Not supported	Lite engine: not registered. Contract
`NOW`	Supported	Supported	Contract
`SECOND`	Supported	Supported	Contract
`TIME`	Supported	Supported	Contract
`TIMEVALUE`	Supported	Supported	Contract
`TODAY`	Supported	Supported	Contract
`WEEKDAY`	Supported	Supported	Contract
`WEEKNUM`	Supported	Supported	Contract
`WORKDAY`	Supported	Supported	Contract
`WORKDAY.INTL`	Supported	Not supported	Lite engine: not registered. Contract
`YEAR`	Partly supported	Partly supported	Serial 0 and blank cells read as 1899-12-31. Excel returns year 1900, month 1 and day 0 (#246). Negative serials are accepted. Excel returns #NUM! (#246). Contract
`YEARFRAC`	Supported	Supported	Contract

Engineering functions

Excel function	Full engine	Lite engine	Notes and differences
`BESSELI`	Not supported	Not supported	Not registered in either engine.
`BESSELJ`	Not supported	Not supported	Not registered in either engine.
`BESSELK`	Not supported	Not supported	Not registered in either engine.
`BESSELY`	Not supported	Not supported	Not registered in either engine.
`BIN2DEC`	Not supported	Not supported	Not registered in either engine.
`BIN2HEX`	Not supported	Not supported	Not registered in either engine.
`BIN2OCT`	Not supported	Not supported	Not registered in either engine.
`BITAND`	Not supported	Not supported	Not registered in either engine.
`BITLSHIFT`	Not supported	Not supported	Not registered in either engine.
`BITOR`	Not supported	Not supported	Not registered in either engine.
`BITRSHIFT`	Not supported	Not supported	Not registered in either engine.
`BITXOR`	Not supported	Not supported	Not registered in either engine.
`COMPLEX`	Not supported	Not supported	Not registered in either engine.
`CONVERT`	Not supported	Not supported	Not registered in either engine.
`DEC2BIN`	Not supported	Not supported	Not registered in either engine.
`DEC2HEX`	Not supported	Not supported	Not registered in either engine.
`DEC2OCT`	Not supported	Not supported	Not registered in either engine.
`DELTA`	Not supported	Not supported	Not registered in either engine.
`ERF`	Not supported	Not supported	Not registered in either engine.
`ERF.PRECISE`	Not supported	Not supported	Not registered in either engine.
`ERFC`	Not supported	Not supported	Not registered in either engine.
`ERFC.PRECISE`	Not supported	Not supported	Not registered in either engine.
`GESTEP`	Not supported	Not supported	Not registered in either engine.
`HEX2BIN`	Not supported	Not supported	Not registered in either engine.
`HEX2DEC`	Not supported	Not supported	Not registered in either engine.
`HEX2OCT`	Not supported	Not supported	Not registered in either engine.
`IMABS`	Not supported	Not supported	Not registered in either engine.
`IMAGINARY`	Not supported	Not supported	Not registered in either engine.
`IMARGUMENT`	Not supported	Not supported	Not registered in either engine.
`IMCONJUGATE`	Not supported	Not supported	Not registered in either engine.
`IMCOS`	Not supported	Not supported	Not registered in either engine.
`IMCOSH`	Not supported	Not supported	Not registered in either engine.
`IMCOT`	Not supported	Not supported	Not registered in either engine.
`IMCSC`	Not supported	Not supported	Not registered in either engine.
`IMCSCH`	Not supported	Not supported	Not registered in either engine.
`IMDIV`	Not supported	Not supported	Not registered in either engine.
`IMEXP`	Not supported	Not supported	Not registered in either engine.
`IMLN`	Not supported	Not supported	Not registered in either engine.
`IMLOG10`	Not supported	Not supported	Not registered in either engine.
`IMLOG2`	Not supported	Not supported	Not registered in either engine.
`IMPOWER`	Not supported	Not supported	Not registered in either engine.
`IMPRODUCT`	Not supported	Not supported	Not registered in either engine.
`IMREAL`	Not supported	Not supported	Not registered in either engine.
`IMSEC`	Not supported	Not supported	Not registered in either engine.
`IMSECH`	Not supported	Not supported	Not registered in either engine.
`IMSIN`	Not supported	Not supported	Not registered in either engine.
`IMSINH`	Not supported	Not supported	Not registered in either engine.
`IMSQRT`	Not supported	Not supported	Not registered in either engine.
`IMSUB`	Not supported	Not supported	Not registered in either engine.
`IMSUM`	Not supported	Not supported	Not registered in either engine.
`IMTAN`	Not supported	Not supported	Not registered in either engine.
`OCT2BIN`	Not supported	Not supported	Not registered in either engine.
`OCT2DEC`	Not supported	Not supported	Not registered in either engine.
`OCT2HEX`	Not supported	Not supported	Not registered in either engine.

Financial functions

Excel function	Full engine	Lite engine	Notes and differences
`ACCRINT`	Not supported	Not supported	Not registered in either engine.
`ACCRINTM`	Not supported	Not supported	Not registered in either engine.
`AMORDEGRC`	Not supported	Not supported	Not registered in either engine.
`AMORLINC`	Not supported	Not supported	Not registered in either engine.
`COUPDAYBS`	Not supported	Not supported	Not registered in either engine.
`COUPDAYS`	Not supported	Not supported	Not registered in either engine.
`COUPDAYSNC`	Not supported	Not supported	Not registered in either engine.
`COUPNCD`	Not supported	Not supported	Not registered in either engine.
`COUPNUM`	Not supported	Not supported	Not registered in either engine.
`COUPPCD`	Not supported	Not supported	Not registered in either engine.
`CUMIPMT`	Supported	Not supported	Lite engine: not registered. Contract
`CUMPRINC`	Supported	Not supported	Lite engine: not registered. Contract
`DB`	Supported	Not supported	Lite engine: not registered. Contract
`DDB`	Supported	Not supported	Lite engine: not registered. Contract
`DISC`	Not supported	Not supported	Not registered in either engine.
`DOLLARDE`	Not supported	Not supported	Not registered in either engine.
`DOLLARFR`	Not supported	Not supported	Not registered in either engine.
`DURATION`	Not supported	Not supported	Not registered in either engine.
`EFFECT`	Supported	Not supported	Lite engine: not registered. Contract
`FV`	Supported	Supported	Contract
`FVSCHEDULE`	Supported	Not supported	Lite engine: not registered. Contract
`INTRATE`	Not supported	Not supported	Not registered in either engine.
`IPMT`	Supported	Supported	Contract
`IRR`	Supported	Supported	Contract
`ISPMT`	Not supported	Not supported	Not registered in either engine.
`MDURATION`	Not supported	Not supported	Not registered in either engine.
`MIRR`	Supported	Not supported	Lite engine: not registered. Contract
`NOMINAL`	Supported	Not supported	Lite engine: not registered. Contract
`NPER`	Supported	Not supported	Lite engine: not registered. Contract
`NPV`	Supported	Supported	Contract
`ODDFPRICE`	Not supported	Not supported	Not registered in either engine.
`ODDFYIELD`	Not supported	Not supported	Not registered in either engine.
`ODDLPRICE`	Not supported	Not supported	Not registered in either engine.
`ODDLYIELD`	Not supported	Not supported	Not registered in either engine.
`PDURATION`	Supported	Not supported	Lite engine: not registered. Contract
`PMT`	Supported	Supported	Contract
`PPMT`	Supported	Supported	Contract
`PRICE`	Not supported	Not supported	Not registered in either engine.
`PRICEDISC`	Not supported	Not supported	Not registered in either engine.
`PRICEMAT`	Not supported	Not supported	Not registered in either engine.
`PV`	Supported	Supported	Contract
`RATE`	Supported	Supported	Contract
`RECEIVED`	Not supported	Not supported	Not registered in either engine.
`RRI`	Supported	Not supported	Lite engine: not registered. Contract
`SLN`	Supported	Not supported	Lite engine: not registered. Contract
`SYD`	Supported	Not supported	Lite engine: not registered. Contract
`TBILLEQ`	Not supported	Not supported	Not registered in either engine.
`TBILLPRICE`	Not supported	Not supported	Not registered in either engine.
`TBILLYIELD`	Not supported	Not supported	Not registered in either engine.
`VDB`	Not supported	Not supported	Not registered in either engine.
`XIRR`	Supported	Not supported	Lite engine: not registered. Contract
`XNPV`	Supported	Not supported	Lite engine: not registered. Contract
`YIELD`	Not supported	Not supported	Not registered in either engine.
`YIELDDISC`	Not supported	Not supported	Not registered in either engine.
`YIELDMAT`	Not supported	Not supported	Not registered in either engine.

Information functions

Excel function	Full engine	Lite engine	Notes and differences
`CELL`	Partly supported	Partly supported	CELL supports the info types address, col, contents, row and type. Other info types return #VALUE!. CELL without a reference describes the cell of the formula, as in LibreOffice. Excel uses the last changed cell. A formula that reads its own cell with FORMULATEXT, ISFORMULA or CELL is a #CYCLE! error. Cells inside a spilled range and host-linked reference cells hold no formula. For them, FORMULATEXT returns #N/A and ISFORMULA returns FALSE. Contract
`ERROR.TYPE`	Not supported	Not supported	Not registered in either engine.
`INFO`	Not supported	Not supported	Not registered in either engine.
`ISBLANK`	Supported	Supported	Contract
`ISERR`	Supported	Supported	Contract
`ISERROR`	Supported	Supported	Contract
`ISEVEN`	Not supported	Not supported	Not registered in either engine.
`ISFORMULA`	Partly supported	Partly supported	CELL supports the info types address, col, contents, row and type. Other info types return #VALUE!. CELL without a reference describes the cell of the formula, as in LibreOffice. Excel uses the last changed cell. A formula that reads its own cell with FORMULATEXT, ISFORMULA or CELL is a #CYCLE! error. Cells inside a spilled range and host-linked reference cells hold no formula. For them, FORMULATEXT returns #N/A and ISFORMULA returns FALSE. Contract
`ISLOGICAL`	Supported	Supported	Contract
`ISNA`	Supported	Supported	Contract
`ISNONTEXT`	Not supported	Not supported	Not registered in either engine.
`ISNUMBER`	Supported	Supported	Contract
`ISODD`	Not supported	Not supported	Not registered in either engine.
`ISOMITTED`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`ISREF`	Not supported	Not supported	Not registered in either engine.
`ISTEXT`	Supported	Supported	Contract
`N`	Supported	Supported	Contract
`NA`	Supported	Supported	Contract
`SHEET`	Not supported	Not supported	Not registered in either engine.
`SHEETS`	Not supported	Not supported	Not registered in either engine.
`STOCKHISTORY`	Not supported	Not supported	Not registered in either engine.
`TYPE`	Supported	Supported	Contract

Logical functions

Excel function	Full engine	Lite engine	Notes and differences
`AND`	Supported	Supported	Contract
`BYCOL`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`BYROW`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`FALSE`	Supported	Supported	Contract
`IF`	Supported	Supported	Contract
`IFERROR`	Supported	Supported	Contract
`IFNA`	Supported	Supported	Contract
`IFS`	Supported	Supported	Contract
`LAMBDA`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. An error argument stops the call before the body runs. =LAMBDA(x,IFERROR(x,0))(1/0) returns #DIV/0!; Excel returns 0 (#246). Contract
`LET`	Supported	Supported	Contract
`MAKEARRAY`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`MAP`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`NOT`	Supported	Supported	Contract
`OR`	Supported	Supported	Contract
`REDUCE`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`SCAN`	Partly supported	Not supported	Lite engine: not registered. Named ranges are supported, but workbook-defined named formulas are not available. LAMBDA uses lexical parameters and LET bindings. Calls are limited to depth 64 and 2000000 work units. Helpers reject nested arrays. Contract
`SWITCH`	Supported	Supported	Contract
`TRUE`	Supported	Supported	Contract
`XOR`	Supported	Supported	Contract

Lookup and reference functions

Excel function	Full engine	Lite engine	Notes and differences
`ADDRESS`	Partly supported	Partly supported	Fractional row and column numbers return #VALUE!. Excel truncates them, as in =ADDRESS(2.5,1) (#246). Some argument errors become #VALUE!. Excel keeps the original error, as in =ADDRESS(1,1,NA()) (#246). Contract
`AREAS`	Partly supported	Partly supported	A space between two references is the intersection operator. An empty intersection, or references on different sheets, return #NULL!. A non-reference operand returns #VALUE!. Spaces around other operators, after commas, before a closing parenthesis and between a function name and its parenthesis are not operators. A comma inside parentheses that are not a function call is the union operator, as in (A1:A2,C1:C2). Aggregate functions that read their arguments as a list of values accept a union. INDEX picks area area_num of a union, and an area_num past the last area returns #REF!. A union in any other position returns #VALUE!. AREAS counts the areas of a reference: the members of a union, or 1 for a cell, range or intersection. A non-reference argument returns #VALUE!. A 3-D reference such as Sheet1:Sheet3!A1:B2 or 'Sheet 1:Sheet 3'!A1 spans the sheets between its endpoints in workbook tab order. SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV.S, STDEV.P, VAR.S and VAR.P accept it; any other position returns #VALUE!. Excel also accepts it in the A-suffixed aggregate functions. A sheet inserted or moved inside the span joins it; a sheet moved out leaves it. Deleting an endpoint moves the endpoint to its inner neighbour; moving an endpoint past the other endpoint drops it; renaming an endpoint rewrites the formula text. Deleting every sheet of the span gives #REF!. Row and column edits do not change a 3-D reference. Cells beyond a smaller sheet's grid read as blank. XLSX import and export keep the Excel formula text of intersections, unions and 3-D references. Contract
`CHOOSE`	Partly supported	Partly supported	Fractional index arguments return #VALUE!. Excel truncates them, as in =CHOOSE(1.5,"a","b") (#246). Contract
`CHOOSECOLS`	Supported	Supported	Contract
`CHOOSEROWS`	Supported	Supported	Contract
`COLUMN`	Supported	Supported	Contract
`COLUMNS`	Supported	Supported	Contract
`DROP`	Supported	Supported	Contract
`EXPAND`	Supported	Not supported	Lite engine: not registered. Contract
`FILTER`	Supported	Supported	Contract
`FORMULATEXT`	Partly supported	Partly supported	CELL supports the info types address, col, contents, row and type. Other info types return #VALUE!. CELL without a reference describes the cell of the formula, as in LibreOffice. Excel uses the last changed cell. A formula that reads its own cell with FORMULATEXT, ISFORMULA or CELL is a #CYCLE! error. Cells inside a spilled range and host-linked reference cells hold no formula. For them, FORMULATEXT returns #N/A and ISFORMULA returns FALSE. Contract
`GETPIVOTDATA`	Not supported	Not supported	Not registered in either engine.
`GROUPBY`	Partly supported	Not supported	Lite engine: not registered. Aggregators must be a single eta-reduced built-in or a LAMBDA with one or two parameters. Vectors of functions are not supported. Grouping and output use the engine spill and work limits. Contract
`HLOOKUP`	Supported	Supported	Contract
`HSTACK`	Supported	Not supported	Lite engine: not registered. Contract
`HYPERLINK`	Partly supported	Partly supported	HYPERLINK returns its display value: the friendly name, or the link when there is no friendly name. The grid does not open the link. Use cell hyperlinks for links that open. Contract
`IMAGE`	Not supported	Not supported	Unsupported by design: Formula evaluation never performs network requests.
`INDEX`	Partly supported	Partly supported	Fractional row and column numbers return #VALUE!. Excel truncates them, as in =INDEX(A1:A5,2.9) (#246). Row or column number 0 returns #VALUE!. Excel returns the whole column or row, as in =SUM(INDEX(A1:B5,0,1)) (#246). Contract
`INDIRECT`	Partly supported	Partly supported	OFFSET and INDIRECT are volatile and return references. Multi-cell results spill when used as formula results; reference-taking functions consume the reference. OFFSET requires a reference and positive height and width; omitted dimensions inherit the source shape. Row and column offsets truncate toward zero. Out-of-grid bounds return #REF!; nonpositive dimensions, nonnumeric offsets and a non-reference first argument return #VALUE!. INDIRECT supports A1 by default and R1C1 when a1 is FALSE, including relative R1C1 coordinates, sheet-qualified references, defined names and table references. Invalid reference text and external workbook references return #REF!. Reference text inside INDIRECT is not rewritten by fill, copy or structural edits. Ordinary reference arguments to OFFSET are rewritten. References must stay within the Excel grid; reading beyond the loaded sheet retains the engine's #REF! behavior. Existing range, spill and work limits apply. A reference that creates a runtime dependency cycle returns #CYCLE!. Contract
`LOOKUP`	Not supported	Not supported	Not registered in either engine.
`MATCH`	Supported	Supported	Contract
`OFFSET`	Partly supported	Partly supported	OFFSET and INDIRECT are volatile and return references. Multi-cell results spill when used as formula results; reference-taking functions consume the reference. OFFSET requires a reference and positive height and width; omitted dimensions inherit the source shape. Row and column offsets truncate toward zero. Out-of-grid bounds return #REF!; nonpositive dimensions, nonnumeric offsets and a non-reference first argument return #VALUE!. INDIRECT supports A1 by default and R1C1 when a1 is FALSE, including relative R1C1 coordinates, sheet-qualified references, defined names and table references. Invalid reference text and external workbook references return #REF!. Reference text inside INDIRECT is not rewritten by fill, copy or structural edits. Ordinary reference arguments to OFFSET are rewritten. References must stay within the Excel grid; reading beyond the loaded sheet retains the engine's #REF! behavior. Existing range, spill and work limits apply. A reference that creates a runtime dependency cycle returns #CYCLE!. Contract
`PIVOTBY`	Partly supported	Not supported	Lite engine: not registered. Aggregators must be a single eta-reduced built-in or a LAMBDA with one or two parameters. Vectors of functions are not supported. Grouping and output use the engine spill and work limits. Contract
`ROW`	Supported	Supported	Contract
`ROWS`	Supported	Supported	Contract
`RTD`	Not supported	Not supported	Unsupported by design: Functions that query external providers or live data connections are not evaluated.
`SORT`	Supported	Supported	Contract
`SORTBY`	Supported	Not supported	Lite engine: not registered. Contract
`TAKE`	Supported	Supported	Contract
`TOCOL`	Supported	Not supported	Lite engine: not registered. Contract
`TOROW`	Supported	Not supported	Lite engine: not registered. Contract
`TRANSPOSE`	Supported	Supported	Contract
`TRIMRANGE`	Not supported	Not supported	Not registered in either engine.
`UNIQUE`	Supported	Supported	Contract
`VLOOKUP`	Supported	Supported	Contract
`VSTACK`	Supported	Not supported	Lite engine: not registered. Contract
`WRAPCOLS`	Supported	Not supported	Lite engine: not registered. Contract
`WRAPROWS`	Supported	Not supported	Lite engine: not registered. Contract
`XLOOKUP`	Supported	Supported	Contract
`XMATCH`	Supported	Supported	Contract

Math and trigonometry functions

Excel function	Full engine	Lite engine	Notes and differences
`ABS`	Supported	Supported	Contract
`ACOS`	Not supported	Not supported	Not registered in either engine.
`ACOSH`	Not supported	Not supported	Not registered in either engine.
`ACOT`	Not supported	Not supported	Not registered in either engine.
`ACOTH`	Not supported	Not supported	Not registered in either engine.
`AGGREGATE`	Partly supported	Not supported	Lite engine: not registered. Hidden rows are not part of the engine model. AGGREGATE row visibility options therefore have no effect. Contract
`ARABIC`	Not supported	Not supported	Not registered in either engine.
`ASIN`	Not supported	Not supported	Not registered in either engine.
`ASINH`	Not supported	Not supported	Not registered in either engine.
`ATAN`	Not supported	Not supported	Not registered in either engine.
`ATAN2`	Not supported	Not supported	Not registered in either engine.
`ATANH`	Not supported	Not supported	Not registered in either engine.
`BASE`	Not supported	Not supported	Not registered in either engine.
`CEILING`	Partly supported	Partly supported	The quotient is not corrected for binary error, and significance signs are not checked. =FLOOR(0.3,0.1) can return 0.2, and =FLOOR(2.5,-2) returns 4 instead of #NUM! (#246). Contract
`CEILING.MATH`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`CEILING.PRECISE`	Not supported	Not supported	Not registered in either engine.
`COMBIN`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`COMBINA`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`COS`	Not supported	Not supported	Not registered in either engine.
`COSH`	Not supported	Not supported	Not registered in either engine.
`COT`	Not supported	Not supported	Not registered in either engine.
`COTH`	Not supported	Not supported	Not registered in either engine.
`CSC`	Not supported	Not supported	Not registered in either engine.
`CSCH`	Not supported	Not supported	Not registered in either engine.
`DECIMAL`	Not supported	Not supported	Not registered in either engine.
`DEGREES`	Not supported	Not supported	Not registered in either engine.
`EVEN`	Supported	Supported	Contract
`EXP`	Supported	Supported	Contract
`FACT`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`FACTDOUBLE`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`FLOOR`	Partly supported	Partly supported	The quotient is not corrected for binary error, and significance signs are not checked. =FLOOR(0.3,0.1) can return 0.2, and =FLOOR(2.5,-2) returns 4 instead of #NUM! (#246). Contract
`FLOOR.MATH`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`FLOOR.PRECISE`	Not supported	Not supported	Not registered in either engine.
`GCD`	Supported	Supported	Contract
`INT`	Supported	Supported	Contract
`ISO.CEILING`	Not supported	Not supported	Not registered in either engine.
`LCM`	Supported	Supported	Contract
`LN`	Supported	Supported	Contract
`LOG`	Supported	Supported	Contract
`LOG10`	Supported	Supported	Contract
`MDETERM`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`MINVERSE`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`MMULT`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`MOD`	Supported	Supported	Contract
`MROUND`	Supported	Supported	Contract
`MULTINOMIAL`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`MUNIT`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`ODD`	Supported	Supported	Contract
`PERCENTOF`	Partly supported	Not supported	Lite engine: not registered. Aggregators must be a single eta-reduced built-in or a LAMBDA with one or two parameters. Vectors of functions are not supported. Grouping and output use the engine spill and work limits. Contract
`PI`	Supported	Supported	Contract
`POWER`	Supported	Supported	Contract
`PRODUCT`	Supported	Supported	Contract
`QUOTIENT`	Supported	Supported	Contract
`RADIANS`	Not supported	Not supported	Not registered in either engine.
`RAND`	Supported	Supported	Contract
`RANDARRAY`	Not supported	Not supported	Unsupported by design: RANDARRAY returns a volatile array and is outside the supported contract.
`RANDBETWEEN`	Supported	Supported	Contract
`ROMAN`	Not supported	Not supported	Not registered in either engine.
`ROUND`	Partly supported	Partly supported	Decimal rounding exposes binary scaling error. =ROUND(1.005,2) returns 1; Excel returns 1.01 (#246). Contract
`ROUNDDOWN`	Supported	Supported	Contract
`ROUNDUP`	Supported	Supported	Contract
`SEC`	Not supported	Not supported	Not registered in either engine.
`SECH`	Not supported	Not supported	Not registered in either engine.
`SEQUENCE`	Supported	Supported	Contract
`SERIESSUM`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`SIGN`	Supported	Supported	Contract
`SIN`	Not supported	Not supported	Not registered in either engine.
`SINH`	Not supported	Not supported	Not registered in either engine.
`SQRT`	Supported	Supported	Contract
`SQRTPI`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`SUBTOTAL`	Partly supported	Partly supported	Only function codes 1 to 11 are accepted. Codes 101 to 111, which ignore hidden rows in Excel, return #VALUE! (#246). Contract
`SUM`	Supported	Supported	Contract
`SUMIF`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells (#246). The value range must have the same shape as the criteria range. =SUMIF(A1:A10,">0",B1) returns #VALUE!; Excel uses B1 as the top-left cell of a ten-row value range (#246). Contract
`SUMIFS`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`SUMPRODUCT`	Supported	Supported	Contract
`SUMSQ`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`SUMX2MY2`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`SUMX2PY2`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`SUMXMY2`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`TAN`	Not supported	Not supported	Not registered in either engine.
`TANH`	Not supported	Not supported	Not registered in either engine.
`TRUNC`	Supported	Supported	Contract

Statistical functions

Excel function	Full engine	Lite engine	Notes and differences
`AVEDEV`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`AVERAGE`	Supported	Supported	Contract
`AVERAGEA`	Not supported	Not supported	Not registered in either engine.
`AVERAGEIF`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells (#246). The value range must have the same shape as the criteria range. =SUMIF(A1:A10,">0",B1) returns #VALUE!; Excel uses B1 as the top-left cell of a ten-row value range (#246). Contract
`AVERAGEIFS`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`BETA.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`BETA.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`BINOM.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`BINOM.DIST.RANGE`	Not supported	Not supported	Not registered in either engine.
`BINOM.INV`	Not supported	Not supported	Not registered in either engine.
`CHISQ.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CHISQ.DIST.RT`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CHISQ.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CHISQ.INV.RT`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CHISQ.TEST`	Not supported	Not supported	Not registered in either engine.
`CONFIDENCE.NORM`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CONFIDENCE.T`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`CORREL`	Supported	Supported	Contract
`COUNT`	Supported	Supported	Contract
`COUNTA`	Supported	Supported	Contract
`COUNTBLANK`	Supported	Supported	Contract
`COUNTIF`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`COUNTIFS`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`COVARIANCE.P`	Supported	Supported	Contract
`COVARIANCE.S`	Supported	Supported	Contract
`DEVSQ`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`EXPON.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`F.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`F.DIST.RT`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`F.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`F.INV.RT`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`F.TEST`	Not supported	Not supported	Not registered in either engine.
`FISHER`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`FISHERINV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`FORECAST`	Supported	Not supported	Alias of `FORECAST.LINEAR`. Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`FORECAST.ETS`	Not supported	Not supported	Not registered in either engine.
`FORECAST.ETS.CONFINT`	Not supported	Not supported	Not registered in either engine.
`FORECAST.ETS.SEASONALITY`	Not supported	Not supported	Not registered in either engine.
`FORECAST.ETS.STAT`	Not supported	Not supported	Not registered in either engine.
`FORECAST.LINEAR`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`FREQUENCY`	Supported	Not supported	Lite engine: not registered. Contract
`GAMMA`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`GAMMA.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`GAMMA.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`GAMMALN`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`GAMMALN.PRECISE`	Not supported	Not supported	Not registered in either engine.
`GAUSS`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`GEOMEAN`	Supported	Supported	Contract
`GROWTH`	Supported	Not supported	Lite engine: not registered. Contract
`HARMEAN`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`HYPGEOM.DIST`	Not supported	Not supported	Not registered in either engine.
`INTERCEPT`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`KURT`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`LARGE`	Supported	Supported	Contract
`LINEST`	Supported	Not supported	Lite engine: not registered. Contract
`LOGEST`	Supported	Not supported	Lite engine: not registered. Contract
`LOGNORM.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`LOGNORM.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`MAX`	Supported	Supported	Contract
`MAXA`	Not supported	Not supported	Not registered in either engine.
`MAXIFS`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`MEDIAN`	Supported	Supported	Contract
`MIN`	Supported	Supported	Contract
`MINA`	Not supported	Not supported	Not registered in either engine.
`MINIFS`	Partly supported	Partly supported	A not-equal criterion does not match a value of a different type. With 5, "x" and a blank cell, "<>" selects only the text cell; Excel selects both nonblank cells, as in =COUNTIF(A1:A3,"<>") (#246). Contract
`MODE.MULT`	Supported	Not supported	Lite engine: not registered. Contract
`MODE.SNGL`	Supported	Supported	Contract
`NEGBINOM.DIST`	Not supported	Not supported	Not registered in either engine.
`NORM.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`NORM.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`NORM.S.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`NORM.S.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`PEARSON`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`PERCENTILE.EXC`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`PERCENTILE.INC`	Supported	Supported	Contract
`PERCENTRANK.EXC`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`PERCENTRANK.INC`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`PERMUT`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`PERMUTATIONA`	Supported	Not supported	Lite engine: not registered. Matrix functions use engine resource limits. Contract
`PHI`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`POISSON.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`PROB`	Supported	Not supported	Lite engine: not registered. Contract
`QUARTILE.EXC`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`QUARTILE.INC`	Supported	Supported	Contract
`RANK.AVG`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`RANK.EQ`	Supported	Supported	Contract
`RSQ`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`SKEW`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`SKEW.P`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`SLOPE`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`SMALL`	Supported	Supported	Contract
`STANDARDIZE`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`STDEV.P`	Supported	Supported	Contract
`STDEV.S`	Supported	Supported	Contract
`STDEVA`	Not supported	Not supported	Not registered in either engine.
`STDEVPA`	Not supported	Not supported	Not registered in either engine.
`STEYX`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`T.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`T.DIST.2T`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`T.DIST.RT`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`T.INV`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`T.INV.2T`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`T.TEST`	Not supported	Not supported	Not registered in either engine.
`TREND`	Supported	Not supported	Lite engine: not registered. Contract
`TRIMMEAN`	Supported	Not supported	Lite engine: not registered. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits. Contract
`VAR.P`	Supported	Supported	Contract
`VAR.S`	Supported	Supported	Contract
`VARA`	Not supported	Not supported	Not registered in either engine.
`VARPA`	Not supported	Not supported	Not registered in either engine.
`WEIBULL.DIST`	Partly supported	Not supported	Lite engine: not registered. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!. Contract
`Z.TEST`	Not supported	Not supported	Not registered in either engine.

Text functions

Excel function	Full engine	Lite engine	Notes and differences
`ARRAYTOTEXT`	Supported	Not supported	Lite engine: not registered. Contract
`ASC`	Not supported	Not supported	Not registered in either engine.
`BAHTTEXT`	Not supported	Not supported	Not registered in either engine.
`CHAR`	Supported	Supported	Contract
`CLEAN`	Supported	Supported	Contract
`CODE`	Supported	Supported	Contract
`CONCAT`	Supported	Supported	Contract
`CONCATENATE`	Supported	Supported	Alias of `CONCAT`. Contract
`DBCS`	Not supported	Not supported	Not registered in either engine.
`DETECTLANGUAGE`	Not supported	Not supported	Not registered in either engine.
`DOLLAR`	Supported	Not supported	Lite engine: not registered. Contract
`EXACT`	Supported	Supported	Contract
`FIND`	Supported	Supported	Contract
`FINDB`	Not supported	Not supported	Not registered in either engine.
`FIXED`	Partly supported	Not supported	Lite engine: not registered. Decimal rounding exposes binary scaling error. =ROUND(1.005,2) returns 1; Excel returns 1.01 (#246). Contract
`LEFT`	Supported	Supported	Contract
`LEFTB`	Not supported	Not supported	Not registered in either engine.
`LEN`	Supported	Supported	Contract
`LENB`	Not supported	Not supported	Not registered in either engine.
`LOWER`	Supported	Supported	Contract
`MID`	Supported	Supported	Contract
`MIDB`	Not supported	Not supported	Not registered in either engine.
`NUMBERVALUE`	Supported	Supported	Contract
`PHONETIC`	Not supported	Not supported	Not registered in either engine.
`PROPER`	Supported	Supported	Contract
`REGEXEXTRACT`	Partly supported	Not supported	Lite engine: not registered. REGEXTEST, REGEXEXTRACT, and REGEXREPLACE use the regex-lite syntax, not full PCRE2. Lookaround, backreferences, Unicode classes such as \p{L}, and other patterns the engine cannot compile return #VALUE!. \d, \s, and \w use ASCII character classes. \b uses ASCII word boundaries. As in Excel, caseSensitivity is 0 (case-sensitive, the default) or 1 (case-insensitive). Case-insensitive matching and the (?i) flag fold ASCII letters only. If caseSensitivity is 1 or the pattern enables an inline i flag, a pattern with a non-ASCII cased letter or a \x, \u, or \U escape returns #VALUE!. Regex programs are limited to 2 MiB. Text inputs and outputs are limited to 32,767 characters. Contract
`REGEXREPLACE`	Partly supported	Not supported	Lite engine: not registered. REGEXTEST, REGEXEXTRACT, and REGEXREPLACE use the regex-lite syntax, not full PCRE2. Lookaround, backreferences, Unicode classes such as \p{L}, and other patterns the engine cannot compile return #VALUE!. \d, \s, and \w use ASCII character classes. \b uses ASCII word boundaries. As in Excel, caseSensitivity is 0 (case-sensitive, the default) or 1 (case-insensitive). Case-insensitive matching and the (?i) flag fold ASCII letters only. If caseSensitivity is 1 or the pattern enables an inline i flag, a pattern with a non-ASCII cased letter or a \x, \u, or \U escape returns #VALUE!. Regex programs are limited to 2 MiB. Text inputs and outputs are limited to 32,767 characters. Contract
`REGEXTEST`	Partly supported	Not supported	Lite engine: not registered. REGEXTEST, REGEXEXTRACT, and REGEXREPLACE use the regex-lite syntax, not full PCRE2. Lookaround, backreferences, Unicode classes such as \p{L}, and other patterns the engine cannot compile return #VALUE!. \d, \s, and \w use ASCII character classes. \b uses ASCII word boundaries. As in Excel, caseSensitivity is 0 (case-sensitive, the default) or 1 (case-insensitive). Case-insensitive matching and the (?i) flag fold ASCII letters only. If caseSensitivity is 1 or the pattern enables an inline i flag, a pattern with a non-ASCII cased letter or a \x, \u, or \U escape returns #VALUE!. Regex programs are limited to 2 MiB. Text inputs and outputs are limited to 32,767 characters. Contract
`REPLACE`	Partly supported	Partly supported	A start position after the end of the text returns #VALUE!. Excel appends the new text, as in =REPLACE("abc",5,1,"X") (#246). Contract
`REPLACEB`	Not supported	Not supported	Not registered in either engine.
`REPT`	Supported	Supported	Contract
`RIGHT`	Supported	Supported	Contract
`RIGHTB`	Not supported	Not supported	Not registered in either engine.
`SEARCH`	Supported	Supported	Contract
`SEARCHB`	Not supported	Not supported	Not registered in either engine.
`SUBSTITUTE`	Supported	Supported	Contract
`T`	Supported	Supported	Contract
`TEXT`	Partly supported	Partly supported	Numeric format codes are reduced to a decimal count. =TEXT(0.5,"0%") returns 0, grouping in "#,##0.00" is omitted, and =TEXT(2.5,"0") rounds half to even (#246). Contract
`TEXTAFTER`	Supported	Not supported	Lite engine: not registered. Contract
`TEXTBEFORE`	Supported	Not supported	Lite engine: not registered. Contract
`TEXTJOIN`	Supported	Supported	Contract
`TEXTSPLIT`	Supported	Not supported	Lite engine: not registered. Contract
`TRANSLATE`	Not supported	Not supported	Not registered in either engine.
`TRIM`	Partly supported	Partly supported	All Unicode whitespace is collapsed. Excel removes only ordinary spaces, so a line feed in =TRIM("a"&CHAR(10)&"b") stays a line feed in Excel (#246). Contract
`UNICHAR`	Supported	Supported	Contract
`UNICODE`	Supported	Supported	Contract
`UPPER`	Supported	Supported	Contract
`VALUE`	Supported	Supported	Contract
`VALUETOTEXT`	Supported	Not supported	Lite engine: not registered. Contract

User defined functions that are installed with add-ins

Excel function	Full engine	Lite engine	Notes and differences
`CALL`	Not supported	Not supported	Not registered in either engine.
`EUROCONVERT`	Not supported	Not supported	Not registered in either engine.
`REGISTER.ID`	Not supported	Not supported	Not registered in either engine.

Web functions

Excel function	Full engine	Lite engine	Notes and differences
`ENCODEURL`	Not supported	Not supported	Unsupported by design: Formula evaluation never performs network requests.
`FILTERXML`	Not supported	Not supported	Unsupported by design: Formula evaluation never performs network requests.
`WEBSERVICE`	Not supported	Not supported	Unsupported by design: Formula evaluation never performs network requests.

Loading documentation…