xplo
Try for free

Excel compatibility

xplo compiles Excel formulas to native code for fast, deterministic execution. Below is a comprehensive breakdown of every Excel function and feature, with current support status. Canonical Microsoft list synced 4/23/2026.

522
Total
493
Supported
14
Cached Value
9
Returns #N/A
6
Blocked

Of the 493 supported functions, 509 are exercised in our validation corpus today. 341 match Excel byte-for-byte across every attributed cell. 23 have at least one cell that differs from Excel above the 0.1% threshold. Each row below carries a one-sentence accuracy summary — click any row to see the per-cell breakdown.

How accuracy is measured: Accuracy is the share of unique corpus cells where our engine matches Excel (per-cell, worst-of-all-validation-records). It is measured on cells where this function is the only function in the formula when at least 20 such cells exist; otherwise it includes composed formulas and the row is badged “(includes composed formulas).” Max abs/rel error is always isolated to sole cells. Relative error is reported as 0 when the expected value is ≈0 (|expected|≤1e-9); for those cells the absolute histogram is authoritative.

Corpus Coverage

Every chip above is grounded in a corpus of real Excel workbooks we re-evaluate on each release. Today the corpus spans:

1,457
Workbooks
61,627
Formulas
24,933,955
Cells validated
533
Functions exercised
🔍

Functions by Category

Statistical110106/110
FunctionStatusAccuracy
AVEDEV↗Supported
Byte-for-byte match across 40 compared cells.
AVERAGE↗Supported
Byte-for-byte match across 151 compared cells.
AVERAGEA↗Supported
Byte-for-byte match across 14 compared cells.
AVERAGEIF↗Supported
Byte-for-byte match across 53 compared cells.
AVERAGEIFS↗Supported
Byte-for-byte match across 38 compared cells.
BETA.DIST↗Supported
Matches Excel across 30 compared cells; 18 cells within numeric tolerance; largest relative error 1.8e-14.
BETA.INV↗Supported
Matches Excel across 40 compared cells; 24 cells within numeric tolerance; largest relative error 3.7e-15.
Runtime coverage differs
BINOM.DIST↗Supported
Matches Excel across 48 compared cells; 35 cells within numeric tolerance; largest relative error 7.3e-13.
Runtime coverage differs
BINOM.DIST.RANGE↗Supported
Matches Excel across 37 compared cells; 27 cells within numeric tolerance; largest relative error 1.5e-13.
BINOM.INV↗Supported
Byte-for-byte match across 32 compared cells.
CHISQ.DIST↗Supported
Matches Excel across 34 compared cells; 20 cells within numeric tolerance; largest relative error 3.6e-15.
Runtime coverage differs
CHISQ.DIST.RT↗Supported
Matches Excel across 22 compared cells; 14 cells within numeric tolerance; largest relative error 1.7e-14.
CHISQ.INV↗Supported
Matches Excel across 38 compared cells; 22 cells within numeric tolerance; largest relative error 8.9e-14.
CHISQ.INV.RT↗Supported
Matches Excel across 24 compared cells; 16 cells within numeric tolerance; largest relative error 2.8e-14.
CHISQ.TEST↗Supported
Matches Excel across 16 compared cells; 9 cells within numeric tolerance; largest relative error 2.4e-13.
CONFIDENCE.NORM↗Supported
Matches Excel across 34 compared cells; 22 cells within numeric tolerance; largest relative error 2.8e-15.
CONFIDENCE.T↗Supported
Matches Excel across 38 compared cells; 24 cells within numeric tolerance; largest relative error 5.4e-13.
Runtime coverage differs
CORREL↗Supported
Matches Excel across 28 compared cells; 12 cells within numeric tolerance; largest relative error 4.4e-16.
COUNT↗Supported
Byte-for-byte match across 57 compared cells.
COUNTA↗Supported
Byte-for-byte match across 63 compared cells.
COUNTBLANK↗Supported
Byte-for-byte match across 29 compared cells.
COUNTIF↗Supported
Byte-for-byte match across 250 compared cells.
COUNTIFS↗Supported
Byte-for-byte match across 49 compared cells.
COVARIANCE.P↗Supported
Byte-for-byte match across 30 compared cells.
COVARIANCE.S↗Supported
Byte-for-byte match across 20 compared cells.
DEVSQ↗Supported
Byte-for-byte match across 50 compared cells.
EXPON.DIST↗Supported
Matches Excel across 39 compared cells; 2 cells within numeric tolerance; largest relative error 3.0e-14.
Runtime coverage differs
F.DIST↗Supported
Matches Excel across 35 compared cells; 24 cells within numeric tolerance; largest relative error 2.2e-14.
Runtime coverage differs
F.DIST.RT↗Supported
Matches Excel across 32 compared cells; 24 cells within numeric tolerance; largest relative error 2.0e-14.
Runtime coverage differs
F.INV↗Supported
Matches Excel across 23 compared cells; 19 cells within numeric tolerance; largest relative error 7.7e-11.
F.INV.RT↗Supported
Matches Excel across 17 compared cells; 16 cells within numeric tolerance; largest relative error 4.0e-11.
F.TEST↗Supported
Matches Excel across 28 compared cells; 20 cells within numeric tolerance; largest relative error 6.1e-15.
FISHER↗Supported
Matches Excel across 25 compared cells; 10 cells within numeric tolerance; largest relative error 2.3e-14.
FISHERINV↗Supported
Matches Excel across 30 compared cells; 6 cells within numeric tolerance; largest relative error 1.9e-16.
Runtime coverage differs
FORECAST.ETS↗Cached value
Byte-for-byte match across 97 compared cells.
Cached value
FORECAST.ETS.CONFINT↗Cached value
Byte-for-byte match across 24 compared cells.
Cached value
FORECAST.ETS.SEASONALITY↗Cached value
Byte-for-byte match across 48 compared cells.
Cached value
FORECAST.ETS.STAT↗Cached value
Byte-for-byte match across 83 compared cells.
Cached value
FORECAST.LINEAR↗Supported
Byte-for-byte match across 33 compared cells.
FREQUENCY↗Supported
No corpus coverage yet.
GAMMA↗Supported
Matches Excel across 35 compared cells; 25 cells within numeric tolerance; largest relative error 7.7e-15.
GAMMA.DIST↗Supported
Matches Excel across 34 compared cells; 20 cells within numeric tolerance; largest relative error 2.1e-14.
GAMMA.INV↗Supported
Matches Excel across 18 compared cells; 9 cells within numeric tolerance; largest relative error 2.5e-15.
GAMMALN↗Supported
Byte-for-byte match across 2 compared cells.
GAMMALN.PRECISE↗Supported
Matches Excel across 18 compared cells; 8 cells within numeric tolerance; largest relative error 1.7e-15.
GAUSS↗Supported
Matches Excel across 29 compared cells; 21 cells within numeric tolerance; largest relative error 1.2e-13.
GEOMEAN↗Supported
Matches Excel across 43 compared cells; 17 cells within numeric tolerance; largest relative error 1.2e-14.
Runtime coverage differs
GROWTH↗Supported
Matches Excel across 35 compared cells; 21 cells within numeric tolerance; largest relative error 5.1e-13.
Runtime coverage differs
HARMEAN↗Supported
Matches Excel across 70 compared cells; 2 cells within numeric tolerance; largest relative error 1.2e-16.
HYPGEOM.DIST↗Supported
Matches Excel across 35 compared cells; 28 cells within numeric tolerance; largest relative error 3.2e-13.
INTERCEPT↗Supported
Byte-for-byte match across 1 compared cell.
KURT↗Supported
Byte-for-byte match across 37 compared cells.
LARGE↗Supported
Byte-for-byte match across 42 compared cells.
LINEST↗Supported
Matches Excel across 30 compared cells; 11 cells within numeric tolerance; largest relative error 5.2e-15.
LOGEST↗Supported
1 of 55 compared cells differ from Excel.
Compiled differs
LOGNORM.DIST↗Supported
Matches Excel across 32 compared cells; 15 cells within numeric tolerance; largest relative error 2.2e-14.
LOGNORM.INV↗Supported
Matches Excel across 32 compared cells; 15 cells within numeric tolerance; largest relative error 4.5e-12.
MAX↗Supported
Byte-for-byte match across 78 compared cells.
MAXA↗Supported
Byte-for-byte match across 12 compared cells.
MAXIFS↗Supported
Byte-for-byte match across 21 compared cells.
MEDIAN↗Supported
Byte-for-byte match across 16 compared cells.
MIN↗Supported
Byte-for-byte match across 82 compared cells.
MINA↗Supported
Byte-for-byte match across 12 compared cells.
MINIFS↗Supported
Byte-for-byte match across 23 compared cells.
MODE.MULT↗Supported
Byte-for-byte match across 29 compared cells.
MODE.SNGL↗Supported
Byte-for-byte match across 28 compared cells.
NEGBINOM.DIST↗Supported
Matches Excel across 34 compared cells; 22 cells within numeric tolerance; largest relative error 1.7e-14.
Runtime coverage differs
NORM.DIST↗Supported
Matches Excel across 38 compared cells; 8 cells within numeric tolerance; largest relative error 1.6e-14.
Runtime coverage differs
NORM.INV↗Supported
Matches Excel across 8 compared cells; 1 cell within numeric tolerance; largest relative error 1.1e-15.
NORM.S.DIST↗Supported
Matches Excel across 57 compared cells; 14 cells within numeric tolerance; largest relative error 1.1e-14.
NORM.S.INV↗Supported
Matches Excel across 32 compared cells; 20 cells within numeric tolerance; largest relative error 1.4e-11.
Runtime coverage differs
PEARSON↗Supported
Matches Excel across 22 compared cells; 6 cells within numeric tolerance; largest relative error 2.4e-16.
PERCENTILE.EXC↗Supported
Matches Excel across 37 compared cells; 3 cells within numeric tolerance; largest relative error 1.7e-16.
PERCENTILE.INC↗Supported
Byte-for-byte match across 21 compared cells.
PERCENTRANK.EXC↗Supported
Byte-for-byte match across 19 compared cells.
PERCENTRANK.INC↗Supported
Byte-for-byte match across 24 compared cells.
PERMUT↗Supported
Matches Excel across 25 compared cells; 1 cell within numeric tolerance; largest relative error 1.4e-15.
PERMUTATIONA↗Supported
Byte-for-byte match across 21 compared cells.
PHI↗Supported
Matches Excel across 27 compared cells; 2 cells within numeric tolerance; largest relative error 2.6e-16.
Runtime coverage differs
POISSON.DIST↗Supported
Matches Excel across 39 compared cells; 31 cells within numeric tolerance; largest relative error 1.9e-12.
Runtime coverage differs
PROB↗Supported
Byte-for-byte match across 38 compared cells.
QUARTILE.EXC↗Supported
Matches Excel across 31 compared cells; 1 cell within numeric tolerance; largest relative error 1.9e-16.
QUARTILE.INC↗Supported
1 of 37 compared cells differ from Excel.
RANK.AVG↗Supported
Byte-for-byte match across 42 compared cells.
RANK.EQ↗Supported
Byte-for-byte match across 38 compared cells.
RSQ↗Supported
Matches Excel across 2 compared cells; 1 cell within numeric tolerance; largest relative error 2.2e-16.
SKEW↗Supported
Byte-for-byte match across 35 compared cells.
SKEW.P↗Supported
Byte-for-byte match across 28 compared cells.
SLOPE↗Supported
Byte-for-byte match across 1 compared cell.
SMALL↗Supported
Byte-for-byte match across 20 compared cells.
STANDARDIZE↗Supported
Byte-for-byte match across 67 compared cells.
STDEV.P↗Supported
Byte-for-byte match across 1 compared cell.
STDEV.S↗Supported
Matches Excel across 27 compared cells; 3 cells within numeric tolerance; largest relative error 8.6e-16.
STDEVA↗Supported
Byte-for-byte match across 5 compared cells.
STDEVPA↗Supported
Byte-for-byte match across 2 compared cells.
STEYX↗Supported
Byte-for-byte match across 33 compared cells.
T.DIST↗Supported
Matches Excel across 29 compared cells; 19 cells within numeric tolerance; largest relative error 3.5e-8.
Runtime coverage differs
T.DIST.2T↗Supported
Matches Excel across 22 compared cells; 14 cells within numeric tolerance; largest relative error 6.4e-13.
Runtime coverage differs
T.DIST.RT↗Supported
Matches Excel across 18 compared cells; 9 cells within numeric tolerance; largest relative error 2.4e-12.
T.INV↗Supported
Matches Excel across 25 compared cells; 14 cells within numeric tolerance; largest relative error 1.4e-13.
Runtime coverage differs
T.INV.2T↗Supported
Matches Excel across 48 compared cells; 31 cells within numeric tolerance; largest relative error 1.2e-8.
Runtime coverage differs
T.TEST↗Supported
Matches Excel across 38 compared cells; 25 cells within numeric tolerance; largest relative error 7.9e-14.
TREND↗Supported
Matches Excel across 38 compared cells; 13 cells within numeric tolerance; largest relative error 1.4e-15.
TRIMMEAN↗Supported
Matches Excel across 36 compared cells; 1 cell within numeric tolerance; largest relative error 1.5e-16.
VAR.P↗Supported
Matches Excel across 38 compared cells; 4 cells within numeric tolerance; largest relative error 3.0e-15.
VAR.S↗Supported
Matches Excel across 34 compared cells; 7 cells within numeric tolerance; largest relative error 3.0e-15.
VARA↗Supported
Byte-for-byte match across 5 compared cells.
VARPA↗Supported
Byte-for-byte match across 2 compared cells.
WEIBULL.DIST↗Supported
Matches Excel across 35 compared cells; 15 cells within numeric tolerance; largest relative error 2.2e-14.
Z.TEST↗Supported
Matches Excel across 21 compared cells; 13 cells within numeric tolerance; largest relative error 1.5e-14.
Math and trigonometry8178/81
FunctionStatusAccuracy
ABS↗Supported
Byte-for-byte match across 57 compared cells.
ACOS↗Supported
Matches Excel across 28 compared cells; 9 cells within numeric tolerance; largest relative error 2.1e-16.
ACOSH↗Supported
Matches Excel across 31 compared cells; 4 cells within numeric tolerance; largest relative error 2.7e-11.
Runtime coverage differs
ACOT↗Supported
Byte-for-byte match across 22 compared cells.
ACOTH↗Supported
Matches Excel across 31 compared cells; 14 cells within numeric tolerance; largest relative error 2.3e-14.
Runtime coverage differs
AGGREGATE↗Supported
Byte-for-byte match across 123 compared cells.
ARABIC↗Supported
1 of 14 compared cells differ from Excel.
ASIN↗Supported
Matches Excel across 28 compared cells; 4 cells within numeric tolerance; largest relative error 1.4e-16.
ASINH↗Supported
Matches Excel across 24 compared cells; 5 cells within numeric tolerance; largest relative error 8.3e-8.
ATAN↗Supported
Byte-for-byte match across 21 compared cells.
ATAN2↗Supported
Byte-for-byte match across 20 compared cells.
ATANH↗Supported
Byte-for-byte match across 2 compared cells.
BASE↗Supported
Byte-for-byte match across 46 compared cells.
CEILING↗Supported
Byte-for-byte match across 23 compared cells.
CEILING.MATH↗Supported
Byte-for-byte match across 20 compared cells.
CEILING.PRECISE↗Supported
Byte-for-byte match across 12 compared cells.
COMBIN↗Supported
Matches Excel across 25 compared cells; 1 cell within numeric tolerance; largest relative error 4.3e-16.
COMBINA↗Supported
Byte-for-byte match across 15 compared cells.
COS↗Supported
Matches Excel across 52 compared cells; 2 cells within numeric tolerance.
Runtime coverage differs
COSH↗Supported
Matches Excel across 9 compared cells; 1 cell within numeric tolerance.
COT↗Supported
Byte-for-byte match across 2 compared cells.
COTH↗Supported
Matches Excel across 1 compared cell; 1 cell within numeric tolerance.
CSC↗Supported
Matches Excel across 22 compared cells; 1 cell within numeric tolerance; largest relative error 1.6e-12.
CSCH↗Supported
Matches Excel across 31 compared cells; 3 cells within numeric tolerance.
DECIMAL↗Supported
Byte-for-byte match across 1 compared cell.
DEGREES↗Supported
Matches Excel across 37 compared cells; 4 cells within numeric tolerance.
EVEN↗Supported
Byte-for-byte match across 18 compared cells.
EXP↗Supported
Matches Excel across 30 compared cells; 4 cells within numeric tolerance; largest relative error 1.6e-16.
Browser differs
FACT↗Supported
Matches Excel across 36 compared cells; 2 cells within numeric tolerance; largest relative error 1.4e-15.
FACTDOUBLE↗Supported
Byte-for-byte match across 13 compared cells.
FLOOR.MATH↗Supported
Byte-for-byte match across 45 compared cells.
FLOOR.PRECISE↗Supported
Byte-for-byte match across 47 compared cells.
GCD↗Supported
Byte-for-byte match across 21 compared cells.
INT↗Supported
Byte-for-byte match across 47 compared cells.
ISO.CEILING↗Supported
Byte-for-byte match across 6 compared cells.
LCM↗Supported
Byte-for-byte match across 16 compared cells.
LN↗Supported
Matches Excel across 48 compared cells; 7 cells within numeric tolerance.
Browser differs
LOG↗Supported
Byte-for-byte match across 23 compared cells.
LOG10↗Supported
Byte-for-byte match across 19 compared cells.
MDETERM↗Supported
Byte-for-byte match across 40 compared cells.
MINVERSE↗Supported
Byte-for-byte match across 42 compared cells.
MMULT↗Supported
Byte-for-byte match across 32 compared cells.
MOD↗Supported
Byte-for-byte match across 117 compared cells.
MROUND↗Supported
Byte-for-byte match across 39 compared cells.
MULTINOMIAL↗Supported
Matches Excel across 35 compared cells; 24 cells within numeric tolerance; largest relative error 5.6e-14.
MUNIT↗Supported
Byte-for-byte match across 33 compared cells.
ODD↗Supported
Byte-for-byte match across 13 compared cells.
PERCENTOF↗Supported
No corpus coverage yet.
PI↗Supported
Byte-for-byte match across 30 compared cells.
POWER↗Supported
1 of 90 compared cells differ from Excel.
Runtime coverage differs
PRODUCT↗Supported
Byte-for-byte match across 54 compared cells.
QUOTIENT↗Supported
Byte-for-byte match across 28 compared cells.
RADIANS↗Supported
Byte-for-byte match across 24 compared cells.
RAND↗Cached value
Byte-for-byte match across 21 compared cells.
VolatileCached value
RANDARRAY↗Cached value
Byte-for-byte match across 20 compared cells.
VolatileCached value
RANDBETWEEN↗Cached value
Byte-for-byte match across 20 compared cells.
VolatileCached value
ROMAN↗Supported
2 of 28 compared cells differ from Excel.
ROUND↗Supported
Byte-for-byte match across 70 compared cells.
ROUNDDOWN↗Supported
Byte-for-byte match across 20 compared cells.
ROUNDUP↗Supported
Matches Excel across 27 compared cells; 1 cell within numeric tolerance; largest relative error 1.1e-16.
SEC↗Supported
Byte-for-byte match across 31 compared cells.
SECH↗Supported
Matches Excel across 26 compared cells; 5 cells within numeric tolerance; largest relative error 1.7e-16.
Browser differs
SEQUENCE↗Supported
Byte-for-byte match across 78 compared cells.
SERIESSUM↗Supported
Matches Excel across 45 compared cells; 3 cells within numeric tolerance; largest relative error 2.2e-16.
Runtime coverage differs
SIGN↗Supported
Byte-for-byte match across 19 compared cells.
SIN↗Supported
Matches Excel across 69 compared cells; 1 cell within numeric tolerance.
Browser differs
SINH↗Supported
Matches Excel across 30 compared cells; 1 cell within numeric tolerance; largest relative error 1.8e-16.
SQRT↗Supported
Byte-for-byte match across 79 compared cells.
SQRTPI↗Supported
Byte-for-byte match across 27 compared cells.
SUBTOTAL↗Supported
1 of 81 compared cells differ from Excel.
SUM↗Supported
Byte-for-byte match across 353 compared cells.
SUMIF↗Supported
Byte-for-byte match across 146 compared cells.
SUMIFS↗Supported
Byte-for-byte match across 60 compared cells.
SUMPRODUCT↗Supported
Byte-for-byte match across 90 compared cells.
SUMSQ↗Supported
Byte-for-byte match across 28 compared cells.
SUMX2MY2↗Supported
Byte-for-byte match across 13 compared cells.
SUMX2PY2↗Supported
Byte-for-byte match across 9 compared cells.
SUMXMY2↗Supported
Byte-for-byte match across 10 compared cells.
TAN↗Supported
Matches Excel across 20 compared cells; 3 cells within numeric tolerance; largest relative error 4.9e-14.
TANH↗Supported
Matches Excel across 2 compared cells; 1 cell within numeric tolerance; largest relative error 1.2e-16.
TRUNC↗Supported
Byte-for-byte match across 23 compared cells.
Financial5555/55
FunctionStatusAccuracy
ACCRINT↗Supported
Byte-for-byte match across 40 compared cells.
ACCRINTM↗Supported
Byte-for-byte match across 29 compared cells.
AMORDEGRC↗Supported
Byte-for-byte match across 39 compared cells.
AMORLINC↗Supported
Matches Excel across 46 compared cells; 9 cells within numeric tolerance; largest relative error 4.4e-15.
COUPDAYBS↗Supported
Byte-for-byte match across 30 compared cells.
COUPDAYS↗Supported
Byte-for-byte match across 25 compared cells.
COUPDAYSNC↗Supported
Byte-for-byte match across 15 compared cells.
COUPNCD↗Supported
Byte-for-byte match across 27 compared cells.
COUPNUM↗Supported
Byte-for-byte match across 45 compared cells.
COUPPCD↗Supported
Byte-for-byte match across 14 compared cells.
CUMIPMT↗Supported
Matches Excel across 77 compared cells; 49 cells within numeric tolerance; largest relative error 1.1e-11.
CUMPRINC↗Supported
Matches Excel across 62 compared cells; 41 cells within numeric tolerance; largest relative error 2.0e-15.
Runtime coverage differs
DB↗Supported
Matches Excel across 65 compared cells; 3 cells within numeric tolerance; largest relative error 2.0e-16.
DDB↗Supported
Matches Excel across 57 compared cells; 15 cells within numeric tolerance; largest relative error 3.7e-15.
DISC↗Supported
Matches Excel across 46 compared cells; 6 cells within numeric tolerance; largest relative error 1.9e-16.
DOLLARDE↗Supported
Byte-for-byte match across 24 compared cells.
DOLLARFR↗Supported
Byte-for-byte match across 17 compared cells.
DURATION↗Supported
15 of 31 compared cells differ from Excel.
Browser differs
EFFECT↗Supported
Matches Excel across 26 compared cells; 11 cells within numeric tolerance; largest relative error 7.5e-13.
FV↗Supported
Matches Excel across 42 compared cells; 29 cells within numeric tolerance; largest relative error 1.8e-13.
Runtime coverage differs
FVSCHEDULE↗Supported
Byte-for-byte match across 31 compared cells.
INTRATE↗Supported
Matches Excel across 33 compared cells; 7 cells within numeric tolerance; largest relative error 1.7e-16.
IPMT↗Supported
Matches Excel across 106 compared cells; 39 cells within numeric tolerance; largest relative error 2.7e-15.
IRR↗Supported
Matches Excel across 34 compared cells; 27 cells within numeric tolerance; largest relative error 2.2e-11.
ISPMT↗Supported
Matches Excel across 30 compared cells; 10 cells within numeric tolerance; largest relative error 3.6e-15.
MDURATION↗Supported
3 of 10 compared cells differ from Excel.
Browser differs
MIRR↗Supported
Matches Excel across 40 compared cells; 7 cells within numeric tolerance; largest relative error 9.3e-15.
NOMINAL↗Supported
Matches Excel across 11 compared cells; 1 cell within numeric tolerance; largest relative error 2.1e-15.
Compiled differs
NPER↗Supported
Matches Excel across 42 compared cells; 5 cells within numeric tolerance; largest relative error 2.1e-16.
Browser differs
NPV↗Supported
1 of 38 compared cells differ from Excel.
Runtime coverage differs
ODDFPRICE↗Supported
Matches Excel across 29 compared cells; 12 cells within numeric tolerance; largest relative error 8.9e-16.
Runtime coverage differs
ODDFYIELD↗Supported
Matches Excel across 10 compared cells; 9 cells within numeric tolerance; largest relative error 1.7e-9.
ODDLPRICE↗Supported
Matches Excel across 26 compared cells; 10 cells within numeric tolerance; largest relative error 1.4e-16.
ODDLYIELD↗Supported
Matches Excel across 8 compared cells; 7 cells within numeric tolerance; largest relative error 7.9e-15.
PDURATION↗Supported
Matches Excel across 38 compared cells; 2 cells within numeric tolerance; largest relative error 1.3e-15.
Browser differs
PMT↗Supported
Matches Excel across 48 compared cells; 31 cells within numeric tolerance; largest relative error 2.5e-14.
PPMT↗Supported
Matches Excel across 76 compared cells; 45 cells within numeric tolerance; largest relative error 5.7e-16.
Runtime coverage differs
PRICE↗Supported
Matches Excel across 38 compared cells; 21 cells within numeric tolerance; largest relative error 1.2e-15.
Runtime coverage differs
PRICEDISC↗Supported
Matches Excel across 35 compared cells; 4 cells within numeric tolerance; largest relative error 2.8e-16.
PRICEMAT↗Supported
Matches Excel across 50 compared cells; 26 cells within numeric tolerance; largest relative error 4.3e-16.
PV↗Supported
Matches Excel across 56 compared cells; 35 cells within numeric tolerance; largest relative error 2.4e-14.
Runtime coverage differs
RATE↗Supported
2 of 36 compared cells differ from Excel.
Runtime coverage differs
RECEIVED↗Supported
Byte-for-byte match across 38 compared cells.
RRI↗Supported
Matches Excel across 33 compared cells; 2 cells within numeric tolerance; largest relative error 1.9e-15.
SLN↗Supported
Byte-for-byte match across 45 compared cells.
SYD↗Supported
Byte-for-byte match across 51 compared cells.
TBILLEQ↗Supported
Byte-for-byte match across 46 compared cells.
TBILLPRICE↗Supported
Byte-for-byte match across 23 compared cells.
TBILLYIELD↗Supported
Byte-for-byte match across 18 compared cells.
VDB↗Supported
Matches Excel across 63 compared cells; 9 cells within numeric tolerance; largest relative error 6.4e-15.
XIRR↗Supported
2 of 30 compared cells differ from Excel.
XNPV↗Supported
Matches Excel across 38 compared cells; 4 cells within numeric tolerance; largest relative error 7.0e-16.
Compiled differs
YIELD↗Supported
Matches Excel across 15 compared cells; 7 cells within numeric tolerance; largest relative error 5.9e-11.
YIELDDISC↗Supported
Matches Excel across 35 compared cells; 34 cells within numeric tolerance; largest relative error 8.8e-13.
YIELDMAT↗Supported
Matches Excel across 37 compared cells; 24 cells within numeric tolerance; largest relative error 1.3e-13.
Engineering5454/54
FunctionStatusAccuracy
BESSELI↗Supported
Matches Excel across 22 compared cells; 1 cell within numeric tolerance; largest relative error 2.3e-16.
BESSELJ↗Supported
Matches Excel across 38 compared cells; 15 cells within numeric tolerance; largest relative error 1.8e-7.
BESSELK↗Supported
Matches Excel across 20 compared cells; 1 cell within numeric tolerance; largest relative error 1.9e-16.
Browser differs
BESSELY↗Supported
Matches Excel across 20 compared cells; 5 cells within numeric tolerance; largest relative error 4.4e-15.
Runtime coverage differs
BIN2DEC↗Supported
Byte-for-byte match across 20 compared cells.
BIN2HEX↗Supported
Byte-for-byte match across 20 compared cells.
BIN2OCT↗Supported
Byte-for-byte match across 20 compared cells.
BITAND↗Supported
Byte-for-byte match across 20 compared cells.
BITLSHIFT↗Supported
Byte-for-byte match across 20 compared cells.
BITOR↗Supported
Byte-for-byte match across 30 compared cells.
BITRSHIFT↗Supported
Byte-for-byte match across 20 compared cells.
BITXOR↗Supported
Byte-for-byte match across 20 compared cells.
COMPLEX↗Supported
Byte-for-byte match across 20 compared cells.
CONVERT↗Supported
Matches Excel across 58 compared cells; 16 cells within numeric tolerance; largest relative error 8.6e-10.
DEC2BIN↗Supported
Byte-for-byte match across 35 compared cells.
DEC2HEX↗Supported
Byte-for-byte match across 1 compared cell.
DEC2OCT↗Supported
Byte-for-byte match across 36 compared cells.
DELTA↗Supported
Byte-for-byte match across 17 compared cells.
ERF↗Supported
Matches Excel across 36 compared cells; 20 cells within numeric tolerance; largest relative error 1.5e-14.
ERF.PRECISE↗Supported
Matches Excel across 22 compared cells; 10 cells within numeric tolerance; largest relative error 9.6e-16.
ERFC↗Supported
Matches Excel across 20 compared cells; 11 cells within numeric tolerance; largest relative error 2.4e-12.
ERFC.PRECISE↗Supported
Matches Excel across 21 compared cells; 11 cells within numeric tolerance; largest relative error 2.4e-12.
GESTEP↗Supported
Byte-for-byte match across 33 compared cells.
HEX2BIN↗Supported
Byte-for-byte match across 37 compared cells.
HEX2DEC↗Supported
Byte-for-byte match across 2 compared cells.
HEX2OCT↗Supported
Byte-for-byte match across 53 compared cells.
IMABS↗Supported
Matches Excel across 9 compared cells; 1 cell within numeric tolerance; largest relative error 1.5e-16.
IMAGINARY↗Supported
Byte-for-byte match across 6 compared cells.
IMARGUMENT↗Supported
Byte-for-byte match across 9 compared cells.
IMCONJUGATE↗Supported
Byte-for-byte match across 8 compared cells.
IMCOS↗Supported
Byte-for-byte match across 8 compared cells.
IMCOSH↗Supported
Byte-for-byte match across 10 compared cells.
IMCOT↗Supported
Matches Excel across 8 compared cells; 3 cells within numeric tolerance; largest relative error 1.9e-12.
Browser differs
IMCSC↗Supported
Byte-for-byte match across 10 compared cells.
IMCSCH↗Supported
Byte-for-byte match across 7 compared cells.
IMDIV↗Supported
Byte-for-byte match across 10 compared cells.
IMEXP↗Supported
Matches Excel across 13 compared cells; 1 cell within numeric tolerance.
Browser differs
IMLN↗Supported
Byte-for-byte match across 14 compared cells.
IMLOG10↗Supported
Byte-for-byte match across 6 compared cells.
IMLOG2↗Supported
Byte-for-byte match across 6 compared cells.
IMPOWER↗Supported
Matches Excel across 16 compared cells; 2 cells within numeric tolerance; largest relative error 3.4e-15.
Browser differs
IMPRODUCT↗Supported
Byte-for-byte match across 8 compared cells.
IMREAL↗Supported
Byte-for-byte match across 7 compared cells.
IMSEC↗Supported
Matches Excel across 13 compared cells; 2 cells within numeric tolerance; largest relative error 1.7e-15.
Browser differs
IMSECH↗Supported
Byte-for-byte match across 7 compared cells.
IMSIN↗Supported
Byte-for-byte match across 12 compared cells.
IMSINH↗Supported
Matches Excel across 12 compared cells; 1 cell within numeric tolerance.
Browser differs
IMSQRT↗Supported
Matches Excel across 7 compared cells; 1 cell within numeric tolerance.
Browser differs
IMSUB↗Supported
Byte-for-byte match across 11 compared cells.
IMSUM↗Supported
Byte-for-byte match across 12 compared cells.
IMTAN↗Supported
Byte-for-byte match across 8 compared cells.
OCT2BIN↗Supported
Byte-for-byte match across 30 compared cells.
OCT2DEC↗Supported
Byte-for-byte match across 20 compared cells.
OCT2HEX↗Supported
Byte-for-byte match across 29 compared cells.
Text4946/49
FunctionStatusAccuracy
ARRAYTOTEXT↗Supported
Byte-for-byte match across 24 compared cells.
ASC↗Supported
Byte-for-byte match across 18 compared cells.
BAHTTEXT↗Supported
Byte-for-byte match across 30 compared cells.
CHAR↗Supported
Byte-for-byte match across 103 compared cells.
CLEAN↗Supported
Byte-for-byte match across 32 compared cells.
CODE↗Supported
Byte-for-byte match across 29 compared cells.
CONCAT↗Supported
Byte-for-byte match across 28 compared cells.
DBCS↗Supported
Byte-for-byte match across 15 compared cells.
DETECTLANGUAGE↗Cached value
No corpus coverage yet.
Cached value
DOLLAR↗Supported
Byte-for-byte match across 63 compared cells.
EXACT↗Supported
Byte-for-byte match across 25 compared cells.
FIND↗Supported
Byte-for-byte match across 94 compared cells.
FINDB↗Supported
Byte-for-byte match across 1 compared cell.
FIXED↗Supported
Byte-for-byte match across 50 compared cells.
JIS↗Supported
Byte-for-byte match across 1 compared cell.
LEFT↗Supported
Byte-for-byte match across 56 compared cells.
LEFTB↗Supported
Byte-for-byte match across 10 compared cells.
LEN↗Supported
Byte-for-byte match across 53 compared cells.
LENB↗Supported
Byte-for-byte match across 19 compared cells.
LOWER↗Supported
Byte-for-byte match across 29 compared cells.
MID↗Supported
Byte-for-byte match across 92 compared cells.
MIDB↗Supported
Byte-for-byte match across 6 compared cells.
NUMBERVALUE↗Supported
Matches Excel across 54 compared cells; 4 cells within numeric tolerance; largest relative error 5.5e-15.
PHONETIC↗Returns #N/A
Byte-for-byte match across 34 compared cells.
PROPER↗Supported
Byte-for-byte match across 61 compared cells.
REGEXEXTRACT↗Supported
Byte-for-byte match across 40 compared cells.
REGEXREPLACE↗Supported
Byte-for-byte match across 43 compared cells.
REGEXTEST↗Supported
Byte-for-byte match across 40 compared cells.
REPLACE↗Supported
Byte-for-byte match across 63 compared cells.
REPLACEB↗Supported
Byte-for-byte match across 32 compared cells.
REPT↗Supported
Byte-for-byte match across 47 compared cells.
RIGHT↗Supported
Byte-for-byte match across 42 compared cells.
RIGHTB↗Supported
Byte-for-byte match across 6 compared cells.
SEARCH↗Supported
Byte-for-byte match across 102 compared cells.
SEARCHB↗Supported
Byte-for-byte match across 1 compared cell.
SUBSTITUTE↗Supported
Byte-for-byte match across 96 compared cells.
T↗Supported
Byte-for-byte match across 52 compared cells.
TEXT↗Supported
Byte-for-byte match across 482 compared cells.
TEXTAFTER↗Supported
1 of 35 compared cells differ from Excel.
TEXTBEFORE↗Supported
1 of 34 compared cells differ from Excel.
TEXTJOIN↗Supported
Byte-for-byte match across 100 compared cells.
TEXTSPLIT↗Supported
Byte-for-byte match across 121 compared cells.
TRANSLATE↗Cached value
No corpus coverage yet.
Cached value
TRIM↗Supported
Byte-for-byte match across 38 compared cells.
UNICHAR↗Supported
Byte-for-byte match across 56 compared cells.
UNICODE↗Supported
Byte-for-byte match across 12 compared cells.
UPPER↗Supported
Byte-for-byte match across 23 compared cells.
VALUE↗Supported
Matches Excel across 60 compared cells; 5 cells within numeric tolerance; largest relative error 5.6e-16.
VALUETOTEXT↗Supported
Byte-for-byte match across 32 compared cells.
Compatibility4141/41
FunctionStatusAccuracy
BETADIST↗Supported
Matches Excel across 42 compared cells; 21 cells within numeric tolerance; largest relative error 7.4e-14.
BETAINV↗Supported
Matches Excel across 39 compared cells; 26 cells within numeric tolerance; largest relative error 2.8e-14.
Runtime coverage differs
BINOMDIST↗Supported
Matches Excel across 39 compared cells; 28 cells within numeric tolerance; largest relative error 6.5e-13.
Runtime coverage differs
CHIDIST↗Supported
Matches Excel across 20 compared cells; 13 cells within numeric tolerance; largest relative error 3.7e-13.
CHIINV↗Supported
Matches Excel across 21 compared cells; 13 cells within numeric tolerance; largest relative error 2.7e-14.
CHITEST↗Supported
Matches Excel across 13 compared cells; 7 cells within numeric tolerance; largest relative error 6.1e-12.
CONCATENATE↗Supported
Byte-for-byte match across 55 compared cells.
CONFIDENCE↗Supported
Matches Excel across 39 compared cells; 23 cells within numeric tolerance; largest relative error 2.8e-15.
COVAR↗Supported
Byte-for-byte match across 20 compared cells.
CRITBINOM↗Supported
Byte-for-byte match across 40 compared cells.
EXPONDIST↗Supported
Matches Excel across 40 compared cells; 1 cell within numeric tolerance; largest relative error 1.5e-16.
FDIST↗Supported
Matches Excel across 44 compared cells; 33 cells within numeric tolerance; largest relative error 3.7e-14.
FINV↗Supported
Matches Excel across 46 compared cells; 34 cells within numeric tolerance; largest relative error 1.5e-8.
FLOOR↗Supported
Byte-for-byte match across 20 compared cells.
FORECAST↗Supported
Byte-for-byte match across 33 compared cells.
FTEST↗Supported
Matches Excel across 29 compared cells; 18 cells within numeric tolerance; largest relative error 7.5e-15.
Runtime coverage differs
GAMMADIST↗Supported
Matches Excel across 34 compared cells; 20 cells within numeric tolerance; largest relative error 2.1e-14.
GAMMAINV↗Supported
Matches Excel across 15 compared cells; 7 cells within numeric tolerance; largest relative error 2.5e-15.
HYPGEOMDIST↗Supported
Matches Excel across 35 compared cells; 28 cells within numeric tolerance; largest relative error 8.8e-13.
Runtime coverage differs
LOGINV↗Supported
Matches Excel across 35 compared cells; 17 cells within numeric tolerance; largest relative error 4.5e-12.
Runtime coverage differs
LOGNORMDIST↗Supported
Matches Excel across 35 compared cells; 13 cells within numeric tolerance; largest relative error 2.7e-11.
MODE↗Supported
Byte-for-byte match across 9 compared cells.
NEGBINOMDIST↗Supported
Matches Excel across 29 compared cells; 20 cells within numeric tolerance; largest relative error 2.0e-14.
NORMDIST↗Supported
Matches Excel across 38 compared cells; 8 cells within numeric tolerance; largest relative error 1.6e-14.
Runtime coverage differs
NORMINV↗Supported
Matches Excel across 37 compared cells; 13 cells within numeric tolerance; largest relative error 1.7e-14.
NORMSDIST↗Supported
Matches Excel across 20 compared cells; 7 cells within numeric tolerance; largest relative error 1.1e-14.
NORMSINV↗Supported
Matches Excel across 36 compared cells; 18 cells within numeric tolerance; largest relative error 1.7e-14.
PERCENTILE↗Supported
Byte-for-byte match across 2 compared cells.
PERCENTRANK↗Supported
Byte-for-byte match across 24 compared cells.
POISSON↗Supported
Matches Excel across 39 compared cells; 31 cells within numeric tolerance; largest relative error 1.9e-12.
Runtime coverage differs
QUARTILE↗Supported
Byte-for-byte match across 30 compared cells.
RANK↗Supported
Byte-for-byte match across 38 compared cells.
STDEV↗Supported
Matches Excel across 24 compared cells; 1 cell within numeric tolerance; largest relative error 1.2e-16.
STDEVP↗Supported
Byte-for-byte match across 5 compared cells.
TDIST↗Supported
Matches Excel across 20 compared cells; 11 cells within numeric tolerance; largest relative error 2.4e-12.
TINV↗Supported
Matches Excel across 30 compared cells; 17 cells within numeric tolerance; largest relative error 2.9e-10.
Runtime coverage differs
TTEST↗Supported
Matches Excel across 21 compared cells; 12 cells within numeric tolerance; largest relative error 5.4e-15.
VAR↗Supported
Matches Excel across 15 compared cells; 1 cell within numeric tolerance.
VARP↗Supported
Byte-for-byte match across 6 compared cells.
WEIBULL↗Supported
Matches Excel across 35 compared cells; 12 cells within numeric tolerance; largest relative error 2.2e-14.
ZTEST↗Supported
Matches Excel across 40 compared cells; 22 cells within numeric tolerance; largest relative error 6.5e-12.
Lookup and reference4035/40
FunctionStatusAccuracy
ADDRESS↗Supported
Byte-for-byte match across 149 compared cells.
AREAS↗Supported
Byte-for-byte match across 27 compared cells.
CHOOSE↗Supported
Byte-for-byte match across 194 compared cells.
CHOOSECOLS↗Supported
Byte-for-byte match across 65 compared cells.
CHOOSEROWS↗Supported
Byte-for-byte match across 75 compared cells.
COLUMN↗Supported
Byte-for-byte match across 35 compared cells.
COLUMNS↗Supported
Byte-for-byte match across 45 compared cells.
DROP↗Supported
6 of 73 compared cells differ from Excel.
EXPAND↗Supported
Byte-for-byte match across 96 compared cells.
FILTER↗Supported
Byte-for-byte match across 42 compared cells.
FORMULATEXT↗Supported
Byte-for-byte match across 21 compared cells.
GETPIVOTDATA↗Cached value
Byte-for-byte match across 29 compared cells.
Cached value
GROUPBY↗Cached value
No corpus coverage yet.
Cached value
HLOOKUP↗Supported
Byte-for-byte match across 270 compared cells.
HSTACK↗Supported
Byte-for-byte match across 62 compared cells.
HYPERLINK↗Supported
Byte-for-byte match across 162 compared cells.
IMAGE↗Blocked
No corpus coverage yet.
INDEX↗Supported
2 of 243 compared cells differ from Excel.
INDIRECT↗Supported
Byte-for-byte match across 233 compared cells.
LOOKUP↗Supported
Byte-for-byte match across 222 compared cells.
MATCH↗Supported
Byte-for-byte match across 352 compared cells.
OFFSET↗Supported
1 of 162 compared cells differ from Excel.
PIVOTBY↗Blocked
No corpus coverage yet.
ROW↗Supported
Byte-for-byte match across 40 compared cells.
ROWS↗Supported
Byte-for-byte match across 68 compared cells.
RTD↗Returns #N/A
Byte-for-byte match across 62 compared cells.
SORT↗Supported
Byte-for-byte match across 38 compared cells.
SORTBY↗Supported
Byte-for-byte match across 30 compared cells.
TAKE↗Supported
2 of 31 compared cells differ from Excel.
TOCOL↗Supported
Byte-for-byte match across 84 compared cells.
TOROW↗Supported
Byte-for-byte match across 41 compared cells.
TRANSPOSE↗Supported
Byte-for-byte match across 15 compared cells.
TRIMRANGE↗Supported
Byte-for-byte match across 16 compared cells.
UNIQUE↗Supported
Byte-for-byte match across 24 compared cells.
VLOOKUP↗Supported
Byte-for-byte match across 410 compared cells.
VSTACK↗Supported
Byte-for-byte match across 55 compared cells.
WRAPCOLS↗Supported
Byte-for-byte match across 43 compared cells.
WRAPROWS↗Supported
Byte-for-byte match across 42 compared cells.
XLOOKUP↗Supported
1 of 359 compared cells differ from Excel.
Browser differs
XMATCH↗Supported
Byte-for-byte match across 123 compared cells.
Date and time2525/25
FunctionStatusAccuracy
DATE↗Supported
Byte-for-byte match across 5,017 compared cells.
DATEDIF↗Supported
Byte-for-byte match across 135 compared cells.
DATEVALUE↗Supported
1 of 64 compared cells differ from Excel.
DAY↗Supported
Byte-for-byte match across 50 compared cells.
DAYS↗Supported
Byte-for-byte match across 31 compared cells.
DAYS360↗Supported
Byte-for-byte match across 87 compared cells.
EDATE↗Supported
Byte-for-byte match across 80 compared cells.
EOMONTH↗Supported
Byte-for-byte match across 73 compared cells.
HOUR↗Supported
Byte-for-byte match across 61 compared cells.
ISOWEEKNUM↗Supported
Byte-for-byte match across 37 compared cells.
MINUTE↗Supported
Byte-for-byte match across 28 compared cells.
MONTH↗Supported
Byte-for-byte match across 43 compared cells.
NETWORKDAYS↗Supported
Byte-for-byte match across 65 compared cells.
NETWORKDAYS.INTL↗Supported
Byte-for-byte match across 52 compared cells.
NOW↗Supported
Matches Excel across 22 compared cells; 2 cells within numeric tolerance; largest relative error 1.6e-16.
Browser differsVolatile
SECOND↗Supported
Byte-for-byte match across 32 compared cells.
TIME↗Supported
Matches Excel across 305 compared cells; 25 cells within numeric tolerance; largest relative error 2.6e-15.
TIMEVALUE↗Supported
Matches Excel across 58 compared cells; 12 cells within numeric tolerance; largest relative error 3.6e-11.
TODAY↗Supported
6 of 49 compared cells differ from Excel.
Browser differsVolatile
WEEKDAY↗Supported
Byte-for-byte match across 90 compared cells.
WEEKNUM↗Supported
Byte-for-byte match across 94 compared cells.
WORKDAY↗Supported
Byte-for-byte match across 61 compared cells.
WORKDAY.INTL↗Supported
Byte-for-byte match across 51 compared cells.
YEAR↗Supported
Byte-for-byte match across 74 compared cells.
YEARFRAC↗Supported
Byte-for-byte match across 90 compared cells.
Information2220/22
FunctionStatusAccuracy
CELL↗Supported
6 of 236 compared cells differ from Excel.
ERROR.TYPE↗Supported
Byte-for-byte match across 21 compared cells.
INFO↗Blocked
No corpus coverage yet.
ISBLANK↗Supported
Byte-for-byte match across 41 compared cells.
ISERR↗Supported
Byte-for-byte match across 16 compared cells.
ISERROR↗Supported
Byte-for-byte match across 30 compared cells.
ISEVEN↗Supported
Byte-for-byte match across 31 compared cells.
ISFORMULA↗Supported
Byte-for-byte match across 1 compared cell.
ISLOGICAL↗Supported
Byte-for-byte match across 29 compared cells.
ISNA↗Supported
1 of 36 compared cells differ from Excel.
ISNONTEXT↗Supported
Byte-for-byte match across 23 compared cells.
ISNUMBER↗Supported
Byte-for-byte match across 23 compared cells.
ISODD↗Supported
Byte-for-byte match across 28 compared cells.
ISOMITTED↗Supported
Byte-for-byte match across 25 compared cells.
ISREF↗Supported
Byte-for-byte match across 46 compared cells.
ISTEXT↗Supported
Byte-for-byte match across 24 compared cells.
N↗Supported
Byte-for-byte match across 88 compared cells.
NA↗Supported
Byte-for-byte match across 175 compared cells.
SHEET↗Supported
Byte-for-byte match across 24 compared cells.
SHEETS↗Supported
Byte-for-byte match across 25 compared cells.
STOCKHISTORY↗Cached value
No corpus coverage yet.
Cached value
TYPE↗Supported
Byte-for-byte match across 67 compared cells.
Logical1919/19
FunctionStatusAccuracy
AND↗Supported
1 of 110 compared cells differ from Excel.
Compiled differs
BYCOL↗Supported
Byte-for-byte match across 33 compared cells.
BYROW↗Supported
Byte-for-byte match across 34 compared cells.
FALSE↗Supported
Byte-for-byte match across 9 compared cells.
IF↗Supported
Byte-for-byte match across 307 compared cells.
IFERROR↗Supported
Byte-for-byte match across 70 compared cells.
IFNA↗Supported
Byte-for-byte match across 86 compared cells.
IFS↗Supported
Byte-for-byte match across 43 compared cells.
LAMBDA↗Supported
Matches Excel across 23 compared cells; 1 cell within numeric tolerance; largest relative error 4.2e-16.
LET↗Supported
Matches Excel across 86 compared cells; 3 cells within numeric tolerance; largest relative error 1.5e-15.
MAKEARRAY↗Supported
Byte-for-byte match across 35 compared cells.
MAP↗Supported
Byte-for-byte match across 38 compared cells.
NOT↗Supported
Byte-for-byte match across 37 compared cells.
OR↗Supported
Byte-for-byte match across 58 compared cells.
REDUCE↗Supported
Byte-for-byte match across 37 compared cells.
SCAN↗Supported
Byte-for-byte match across 9 compared cells.
SWITCH↗Supported
Byte-for-byte match across 40 compared cells.
TRUE↗Supported
Byte-for-byte match across 24 compared cells.
XOR↗Supported
Byte-for-byte match across 30 compared cells.
Database1212/12
FunctionStatusAccuracy
DAVERAGE↗Supported
Byte-for-byte match across 2 compared cells.
DCOUNT↗Supported
Byte-for-byte match across 4 compared cells.
DCOUNTA↗Supported
Byte-for-byte match across 4 compared cells.
DGET↗Supported
Byte-for-byte match across 3 compared cells.
DMAX↗Supported
Byte-for-byte match across 1 compared cell.
DMIN↗Supported
Byte-for-byte match across 1 compared cell.
DPRODUCT↗Supported
Byte-for-byte match across 1 compared cell.
DSTDEV↗Supported
Byte-for-byte match across 1 compared cell.
DSTDEVP↗Supported
Byte-for-byte match across 1 compared cell.
DSUM↗Supported
Byte-for-byte match across 22 compared cells.
DVAR↗Supported
Byte-for-byte match across 1 compared cell.
DVARP↗Supported
Byte-for-byte match across 1 compared cell.
Cubes70/7
FunctionStatusAccuracy
CUBEKPIMEMBER↗Returns #N/A
Byte-for-byte match across 15 compared cells.
CUBEMEMBER↗Returns #N/A
Byte-for-byte match across 30 compared cells.
CUBEMEMBERPROPERTY↗Returns #N/A
Byte-for-byte match across 9 compared cells.
CUBERANKEDMEMBER↗Returns #N/A
Byte-for-byte match across 20 compared cells.
CUBESET↗Returns #N/A
Byte-for-byte match across 26 compared cells.
CUBESETCOUNT↗Returns #N/A
Byte-for-byte match across 10 compared cells.
CUBEVALUE↗Returns #N/A
Byte-for-byte match across 36 compared cells.
User defined functions that are installed with add-ins30/3
FunctionStatusAccuracy
CALL↗Blocked
No corpus coverage yet.
EUROCONVERT↗Cached value
No corpus coverage yet.
Cached value
REGISTER.ID↗Blocked
No corpus coverage yet.
Web32/3
FunctionStatusAccuracy
ENCODEURL↗Supported
Byte-for-byte match across 13 compared cells.
FILTERXML↗Supported
Byte-for-byte match across 49 compared cells.
WEBSERVICE↗Cached value
Byte-for-byte match across 15 compared cells.
Cached value
Other10/1
FunctionStatusAccuracy
COPILOT↗Blocked
No corpus coverage yet.

Functions With Caveats

These functions compile and run, but their behavior diverges from Excel's live-recompute semantics in ways worth knowing about before you rely on them.

Volatile functions

Volatile functions change their output between evaluations in Excel — they read the live clock or draw from a random source. xplo handles them differently in each of its three execution modes:

• Deterministic mode (the default for testing) freezes every volatile call to the value Excel last saved in the workbook, so a single workbook always produces the same result no matter when it runs.

• Reproducible mode replaces the live source with a deterministic substitute — RAND/RANDBETWEEN/RANDARRAY draw from a seeded PRNG keyed on the run, NOW/TODAY use a caller-supplied timestamp — so identical seeds and inputs always produce identical outputs.

• Non-deterministic mode behaves like Excel itself: each evaluation reads the live system clock and an unseeded random source, so successive runs of the same workbook can disagree.

NOWRANDRANDARRAYRANDBETWEENTODAY

Workbook Features With Caveats

These are workbook-level capabilities — not tied to any single function. They work in common cases, with the limitations noted below.

Circular references

Cycles are detected via strongly connected components; cells inside a cycle use baseline passthrough on perturbation (cannot recompute).

Conditional formatting

Conditional formatting rules are preserved in the workbook but the formulas they depend on are not extracted; IF statements conditioned on conditional formats are not evaluated.

External data connections

Queries against external databases/REST sources are not executed; cached values are preserved.

Pivot tables

Pivot tables are not recomputed; GETPIVOTDATA emits the xlsx cached value.

Why Some Functions Aren't Supported

Images & Live AI

IMAGE references don't have a meaningful scalar value to fall back on, and COPILOT produces non-deterministic AI output that isn't safe to cache across runs. These are refused at compile time so their use surfaces early. Other network-dependent functions (TRANSLATE, WEBSERVICE, STOCKHISTORY, SQL.REQUEST, DETECTLANGUAGE, EUROCONVERT) use the cached workbook value instead — see Partial Support.

COPILOTIMAGE
OLAP / Cube Functions

Functions that query external OLAP cubes (SQL Server Analysis Services and similar) compile into your workbook but always return #N/A since we can't maintain a live cube connection. Wrapping them in IFERROR/IFNA works correctly — the error is visible and catchable at runtime.

CUBEKPIMEMBERCUBEMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESETCUBESETCOUNTCUBEVALUE
Grouping & Pivot Functions

GROUPBY and PIVOTBY produce dynamic spill arrays backed by a full SQL-style GROUP BY engine with multi-column hierarchy, totals, and sort modes. That infrastructure isn't implemented yet. Pivot tables themselves are supported: GETPIVOTDATA emits the cached pivot value from your xlsx.

PIVOTBY
System & Meta Functions

INFO, CALL, REGISTER.ID and friends query Excel's runtime environment — installed add-ins, DLL registrations, the running version's configuration — none of which exist in a compiled artifact. They refuse at compile time so their use is obvious.

CALLINFOREGISTER.ID
Platform-Specific Functions

Functions tied to a specific platform (Windows-only FILTERXML) or locale (Japanese-only PHONETIC) return #N/A in our runtime. Excel itself gives different answers on different platforms, so this mirrors the expected behavior for users running outside the supported environment.

PHONETIC
Real-Time Data

RTD requires a live COM server that publishes streaming values (e.g., stock tickers). Compiled artifacts have no COM runtime, so RTD is recognized but always returns #N/A — catch it with IFNA if you want a placeholder value.

RTD

Excel Qualities

Beyond per-function support, our corpus tracks Excel properties that cut across many functions — how Excel coerces types, how volatile and dynamic-array semantics behave, how circular references resolve, and more. Of 16 qualities tracked, 0 have at least one validated workbook (0 cases tagged so far).

Semantics5 qualityies
Type coercion
tracked, no cases tagged yet

Implicit conversions between numbers, text, booleans, and errors as Excel applies them inside formulas — e.g. "3"+2, TRUE*5, comparing dates with text, and propagating #N/A through arithmetic.

Volatile functions
tracked, no cases tagged yet

NOW, TODAY, RAND, RANDBETWEEN, RANDARRAY, OFFSET, INDIRECT, INFO, CELL — functions whose output is not a pure function of inputs. Coverage exercises Explo's deterministic, reproducible, and non-deterministic execution modes.

1900 leap-year bug
tracked, no cases tagged yet

Excel intentionally treats 1900 as a leap year for Lotus-1-2-3 compatibility. Coverage ensures Explo's date arithmetic reproduces the off-by-one for dates on or before 1900-03-01.

Platform-sensitive behavior
tracked, no cases tagged yet

Behaviors that diverge across Excel for Windows, Mac, and Web — locale-bound parsing, rendering of certain glyphs, and platform-specific functions like PHONETIC.

1904 date system
tracked, no cases tagged yet

Workbooks using the 1904 date base instead of the default 1900 base. Coverage ensures dates render and compute correctly under both systems.

Formulas4 qualityies
Dynamic arrays
tracked, no cases tagged yet

Spilling output from SEQUENCE / UNIQUE / SORT / FILTER / dynamic LET, including how spill ranges interact with downstream formulas, dependency tracking, and #SPILL! errors.

Circular references
tracked, no cases tagged yet

Cycles in the dependency graph. Explo detects them via strongly connected components and emits the workbook's saved baseline value for cells inside a cycle (no iterative-calc convergence yet).

Implicit intersection
tracked, no cases tagged yet

Pre-dynamic-array @ semantics — using a multi-cell range where a single value is expected, including legacy formulas that relied on the row/column intersection rule.

Legacy CSE array formulas
tracked, no cases tagged yet

Ctrl+Shift+Enter array formulas — the pre-dynamic-array way of producing array results, still authoritative in workbooks authored before Microsoft 365.

References4 qualityies
Named ranges
tracked, no cases tagged yet

Workbook- and sheet-scoped defined names, including names that reference single cells, ranges, constants, and other names.

Cross-sheet references
tracked, no cases tagged yet

Sheet2!A1-style references resolving across sheets within a workbook, including references that survive sheet renames and reorders.

Structured references
tracked, no cases tagged yet

Table[Column], Table[#All], Table[#Headers], Table[@Column] — the Table-aware reference syntax that resolves to ranges at evaluation time.

3D references
tracked, no cases tagged yet

Sheet1:Sheet3!A1-style ranges that span multiple sheets, including aggregate functions (SUM, AVERAGE, COUNT) operating across the 3D range.

Workbook2 qualityies
Excel Tables (ListObjects)
tracked, no cases tagged yet

Native Excel Tables — auto-expanding ranges, total rows, calculated columns, and references that follow row inserts/deletes.

VBA presence
tracked, no cases tagged yet

Workbooks containing VBA modules. Coverage ensures the workbook is accepted, parsed, and evaluated correctly even when VBA is present; macro execution itself is not supported yet.

Numerics1 quality
Floating-point precision
tracked, no cases tagged yet

IEEE-754 rounding behavior under operations where it matters — accumulating long sums, transcendentals (LN, EXP, trig), and financial functions whose results depend on iterative algorithms.

Legacy Names

These older Excel function names are accepted but treated as their modern equivalents during compilation.

Legacy nameCanonical name
FORECASTFORECAST.LINEAR
GAMMADISTGAMMA.DIST
NORMDISTNORM.DIST
PERCENTRANKPERCENTRANK.INC
POISSONPOISSON.DIST
RANKRANK.EQ
SINGLEIMPLICIT

Developer view: per-case pipeline dashboard · per-function fidelity internals

This page is changing fast
Coverage expands with every release, and we're aiming for full Excel feature parity soon. See what's next on the roadmap.