TREB Function Coverage Report

Generated 2026-05-14 22:44:05 UTC
424Pass (81.2%)
6Fail (1.1%)
37Not Implemented (7.1%)
55Not Tested (10.5%)

Math79 functions — 78 pass, 0 fail, 1 not implemented, 0 not tested

FunctionStatusTestsFailed Expressions
ABS Pass 4/4
ACOS Pass 3/3
ACOSH Pass 4/4
ACOT Pass 4/4
ACOTH Pass 4/4
AGGREGATE Not Implemented 0/4
ARABIC Pass 4/4
ASIN Pass 3/3
ASINH Pass 4/4
ATAN Pass 3/3
ATAN2 Pass 4/4
ATANH Pass 4/4
BASE Pass 4/4
CEILING.MATH Pass 4/4
CEILING.PRECISE Pass 4/4
COMBIN Pass 4/4
COMBINA Pass 4/4
COS Pass 4/4
COSH Pass 4/4
COT Pass 4/4
COTH Pass 4/4
CSC Pass 4/4
CSCH Pass 4/4
DECIMAL Pass 4/4
DEGREES Pass 3/3
EVEN Pass 4/4
EXP Pass 4/4
FACT Pass 4/4
FACTDOUBLE Pass 4/4
FLOOR.MATH Pass 4/4
FLOOR.PRECISE Pass 4/4
GCD Pass 4/4
INT Pass 4/4
ISO.CEILING Pass 4/4
LCM Pass 4/4
LN Pass 4/4
LOG Pass 4/4
LOG10 Pass 4/4
MDETERM Pass 2/2
MINVERSE Pass 4/4
MMULT Pass 4/4
MOD Pass 4/4
MROUND Pass 4/4
MULTINOMIAL Pass 4/4
MUNIT Pass 4/4
ODD Pass 4/4
PI Pass 1/1
POWER Pass 4/4
PRODUCT Pass 4/4
QUOTIENT Pass 4/4
RADIANS Pass 3/3
RAND Pass 1/1
RANDARRAY Pass 2/2
RANDBETWEEN Pass 2/2
ROMAN Pass 4/4
ROUND Pass 5/5
ROUNDDOWN Pass 4/4
ROUNDUP Pass 4/4
SEC Pass 4/4
SECH Pass 4/4
SEQUENCE Pass 4/4
SERIESSUM Pass 4/4
SIGN Pass 4/4
SIN Pass 4/4
SINH Pass 4/4
SQRT Pass 4/4
SQRTPI Pass 4/4
SUBTOTAL Pass 4/4
SUM Pass 3/3
SUMIF Pass 4/4
SUMIFS Pass 4/4
SUMPRODUCT Pass 3/3
SUMSQ Pass 4/4
SUMX2MY2 Pass 2/2
SUMX2PY2 Pass 2/2
SUMXMY2 Pass 2/2
TAN Pass 3/3
TANH Pass 4/4
TRUNC Pass 4/4

Financial56 functions — 54 pass, 0 fail, 1 not implemented, 1 not tested

FunctionStatusTestsFailed Expressions
ACCRINT Pass 2/2
ACCRINTM Pass 2/2
AMORDEGRC Not Implemented 0/2
AMORLINC Pass 1/1
COUPDAYBS Pass 2/2
COUPDAYS Pass 2/2
COUPDAYSNC Pass 2/2
COUPNCD Pass 1/1
COUPNUM Pass 2/2
COUPPCD Pass 1/1
CUMIPMT Pass 2/2
CUMPRINC Pass 2/2
DB Pass 3/3
DDB Pass 3/3
DISC Pass 1/1
DOLLARDE Pass 3/3
DOLLARFR Pass 3/3
DURATION Pass 1/1
EFFECT Pass 3/3
FV Pass 3/3
FVSCHEDULE Pass 3/3
INTRATE Pass 1/1
IPMT Pass 2/2
IRR Pass 1/1
ISPMT Pass 2/2
MDURATION Pass 1/1
MIRR Pass 1/1
NOMINAL Pass 3/3
NPER Pass 2/2
NPV Pass 2/2
ODDFPRICE Pass 1/1
ODDFYIELD Pass 1/1
ODDLPRICE Pass 1/1
ODDLYIELD Pass 1/1
PDURATION Pass 2/2
PMT Pass 3/3
PPMT Pass 2/2
PRICE Pass 2/2
PRICEDISC Pass 1/1
PRICEMAT Pass 1/1
PV Pass 3/3
RATE Pass 2/2
RECEIVED Pass 1/1
RRI Pass 2/2
SLN Pass 3/3
STOCKHISTORY Not Tested
SYD Pass 3/3
TBILLEQ Pass 1/1
TBILLPRICE Pass 1/1
TBILLYIELD Pass 1/1
VDB Pass 3/3
XIRR Pass 1/1
XNPV Pass 1/1
YIELD Pass 1/1
YIELDDISC Pass 1/1
YIELDMAT Pass 1/1

Lookup41 functions — 32 pass, 0 fail, 1 not implemented, 8 not tested

FunctionStatusTestsFailed Expressions
ADDRESS Pass 4/4
AREAS Not Tested
CHOOSE Pass 4/4
CHOOSECOLS Pass 4/4
CHOOSEROWS Pass 4/4
COLUMN Pass 3/3
COLUMNS Pass 3/3
DROP Pass 4/4
EXPAND Pass 4/4
FILTER Pass 4/4
FORMULATEXT Pass 1/1
GETPIVOTDATA Not Tested
GROUPBY Not Tested
HLOOKUP Pass 4/4
HSTACK Pass 4/4
HYPERLINK Not Tested
IMAGE Not Tested
INDEX Pass 3/3
INDIRECT Pass 3/3
LOOKUP Not Implemented 0/4
MATCH Pass 4/4
OFFSET Pass 4/4
PERCENTOF Not Tested
PIVOTBY Not Tested
ROW Pass 3/3
ROWS Pass 3/3
RTD Not Tested
SORT Pass 4/4
SORTBY Pass 3/3
TAKE Pass 4/4
TOCOL Pass 4/4
TOROW Pass 4/4
TRANSPOSE Pass 4/4
TRIMRANGE Pass 3/3
UNIQUE Pass 3/3
VLOOKUP Pass 4/4
VSTACK Pass 4/4
WRAPCOLS Pass 4/4
WRAPROWS Pass 4/4
XLOOKUP Pass 4/4
XMATCH Pass 4/4

Logical19 functions — 19 pass, 0 fail, 0 not implemented, 0 not tested

FunctionStatusTestsFailed Expressions
AND Pass 5/5
BYCOL Pass 3/3
BYROW Pass 2/2
FALSE Pass 1/1
IF Pass 6/6
IFERROR Pass 3/3
IFNA Pass 2/2
IFS Pass 3/3
LAMBDA Pass 4/4
LET Pass 4/4
MAKEARRAY Pass 4/4
MAP Pass 4/4
NOT Pass 4/4
OR Pass 5/5
REDUCE Pass 4/4
SCAN Pass 3/3
SWITCH Pass 4/4
TRUE Pass 1/1
XOR Pass 4/4

Text48 functions — 31 pass, 3 fail, 1 not implemented, 13 not tested

FunctionStatusTestsFailed Expressions
ARRAYTOTEXT Pass 2/2
ASC Not Tested
BAHTTEXT Not Tested
CHAR Pass 4/4
CLEAN Pass 4/4
CODE Pass 4/4
CONCAT Pass 4/4
DBCS Not Tested
DETECTLANGUAGE Not Tested
DOLLAR Pass 4/4
EXACT Pass 4/4
FIND Pass 4/4
FINDB Not Tested
FIXED Pass 4/4
LEFT Pass 4/4
LEFTB Not Tested
LEN Pass 4/4
LENB Not Tested
LOWER Pass 4/4
MID Pass 4/4
MIDB Not Tested
NUMBERVALUE Pass 4/4
PHONETIC Not Tested
PROPER Pass 4/4
REGEXEXTRACT Fail 3/4 =REGEXEXTRACT("test@email.com","@(.+)")
REGEXREPLACE Fail 3/4 =REGEXREPLACE("test",".*","replaced")
REGEXTEST Pass 4/4
REPLACE Pass 4/4
REPLACEB Not Tested
REPT Pass 4/4
RIGHT Pass 4/4
RIGHTB Not Tested
SEARCH Pass 5/5
SEARCHB Not Tested
SUBSTITUTE Pass 4/4
T Pass 4/4
TEXT Pass 4/4
TEXTAFTER Pass 4/4
TEXTBEFORE Pass 4/4
TEXTJOIN Pass 5/5
TEXTSPLIT Pass 4/4
TRANSLATE Not Tested
TRIM Pass 4/4
UNICHAR Pass 4/4
UNICODE Pass 4/4
UPPER Pass 4/4
VALUE Fail 3/4 =VALUE("16:48:00")
VALUETOTEXT Not Implemented 0/4

Statistical110 functions — 104 pass, 1 fail, 0 not implemented, 5 not tested

FunctionStatusTestsFailed Expressions
AVEDEV Pass 1/1
AVERAGE Pass 3/3
AVERAGEA Pass 2/2
AVERAGEIF Pass 3/3
AVERAGEIFS Pass 2/2
BETA.DIST Pass 3/3
BETA.INV Pass 2/2
BINOM.DIST Pass 4/4
BINOM.DIST.RANGE Pass 2/2
BINOM.INV Pass 3/3
CHISQ.DIST Pass 3/3
CHISQ.DIST.RT Pass 3/3
CHISQ.INV Pass 3/3
CHISQ.INV.RT Pass 3/3
CHISQ.TEST Pass 1/1
CONFIDENCE.NORM Pass 2/2
CONFIDENCE.T Pass 2/2
CORREL Pass 3/3
COUNT Pass 3/3
COUNTA Pass 2/2
COUNTBLANK Pass 2/2
COUNTIF Pass 4/4
COUNTIFS Pass 3/3
COVARIANCE.P Pass 1/1
COVARIANCE.S Pass 1/1
DEVSQ Pass 1/1
EXPON.DIST Pass 4/4
F.DIST Pass 3/3
F.DIST.RT Pass 3/3
F.INV Pass 2/2
F.INV.RT Pass 3/3
F.TEST Pass 1/1
FISHER Pass 4/4
FISHERINV Pass 4/4
FORECAST.ETS Not Tested
FORECAST.ETS.CONFINT Not Tested
FORECAST.ETS.SEASONALITY Not Tested
FORECAST.ETS.STAT Not Tested
FORECAST.LINEAR Not Tested
FREQUENCY Pass 3/3
GAMMA Pass 4/4
GAMMA.DIST Pass 3/3
GAMMA.INV Pass 2/2
GAMMALN Pass 4/4
GAMMALN.PRECISE Pass 3/3
GAUSS Pass 4/4
GEOMEAN Pass 4/4
GROWTH Pass 3/3
HARMEAN Pass 4/4
HYPGEOM.DIST Pass 2/2
INTERCEPT Pass 1/1
KURT Pass 1/1
LARGE Pass 3/3
LINEST Pass 2/2
LOGEST Pass 1/1
LOGNORM.DIST Pass 3/3
LOGNORM.INV Pass 3/3
MAX Pass 3/3
MAXA Pass 1/1
MAXIFS Pass 3/3
MEDIAN Pass 4/4
MIN Pass 3/3
MINA Pass 1/1
MINIFS Pass 3/3
MODE.MULT Pass 1/1
MODE.SNGL Pass 1/1
NEGBINOM.DIST Pass 2/2
NORM.DIST Pass 4/4
NORM.INV Pass 4/4
NORM.S.DIST Pass 4/4
NORM.S.INV Pass 4/4
PEARSON Pass 3/3
PERCENTILE.EXC Pass 3/3
PERCENTILE.INC Pass 4/4
PERCENTRANK.EXC Pass 3/3
PERCENTRANK.INC Pass 3/3
PERMUT Pass 4/4
PERMUTATIONA Pass 4/4
PHI Pass 4/4
POISSON.DIST Pass 4/4
PROB Pass 2/2
QUARTILE.EXC Pass 3/3
QUARTILE.INC Pass 4/4
RANK.AVG Pass 3/3
RANK.EQ Pass 4/4
RSQ Pass 1/1
SKEW Pass 2/2
SKEW.P Pass 1/1
SLOPE Pass 1/1
SMALL Pass 3/3
STANDARDIZE Pass 4/4
STDEV.P Pass 1/1
STDEV.S Pass 1/1
STDEVA Pass 1/1
STDEVPA Pass 1/1
STEYX Pass 1/1
T.DIST Pass 4/4
T.DIST.2T Pass 3/3
T.DIST.RT Pass 3/3
T.INV Pass 3/3
T.INV.2T Fail 2/3 =T.INV.2T(0.01,30)
T.TEST Pass 1/1
TREND Pass 3/3
TRIMMEAN Pass 2/2
VAR.P Pass 1/1
VAR.S Pass 1/1
VARA Pass 1/1
VARPA Pass 1/1
WEIBULL.DIST Pass 3/3
Z.TEST Pass 4/4

Engineering54 functions — 23 pass, 2 fail, 29 not implemented, 0 not tested

FunctionStatusTestsFailed Expressions
BESSELI Not Implemented 0/3
BESSELJ Not Implemented 0/3
BESSELK Not Implemented 0/2
BESSELY Not Implemented 0/2
BIN2DEC Pass 4/4
BIN2HEX Pass 4/4
BIN2OCT Pass 4/4
BITAND Pass 4/4
BITLSHIFT Pass 4/4
BITOR Pass 4/4
BITRSHIFT Pass 4/4
BITXOR Pass 4/4
COMPLEX Fail 0/4 =COMPLEX(3,4), =COMPLEX(3,-4), =COMPLEX(0,1), =COMPLEX(1,0)
CONVERT Not Implemented 0/4
DEC2BIN Pass 4/4
DEC2HEX Pass 4/4
DEC2OCT Pass 4/4
DELTA Pass 4/4
ERF Pass 4/4
ERF.PRECISE Pass 3/3
ERFC Pass 3/3
ERFC.PRECISE Pass 3/3
GESTEP Pass 4/4
HEX2BIN Pass 4/4
HEX2DEC Pass 4/4
HEX2OCT Pass 4/4
IMABS Not Implemented 0/4
IMAGINARY Fail 0/4 =IMAGINARY("3+4i"), =IMAGINARY("5-2i"), =IMAGINARY("i"), =IMAGINARY("6")
IMARGUMENT Not Implemented 0/4
IMCONJUGATE Not Implemented 0/4
IMCOS Not Implemented 0/2
IMCOSH Not Implemented 0/2
IMCOT Not Implemented 0/1
IMCSC Not Implemented 0/1
IMCSCH Not Implemented 0/1
IMDIV Not Implemented 0/3
IMEXP Not Implemented 0/2
IMLN Not Implemented 0/2
IMLOG10 Not Implemented 0/2
IMLOG2 Not Implemented 0/2
IMPOWER Not Implemented 0/3
IMPRODUCT Not Implemented 0/3
IMREAL Not Implemented 0/4
IMSEC Not Implemented 0/2
IMSECH Not Implemented 0/2
IMSIN Not Implemented 0/2
IMSINH Not Implemented 0/2
IMSQRT Not Implemented 0/3
IMSUB Not Implemented 0/3
IMSUM Not Implemented 0/3
IMTAN Not Implemented 0/2
OCT2BIN Pass 4/4
OCT2DEC Pass 4/4
OCT2HEX Pass 4/4

Compatibility42 functions — 41 pass, 0 fail, 1 not implemented, 0 not tested

FunctionStatusTestsFailed Expressions
BETADIST Pass 2/2
BETAINV Pass 2/2
BINOMDIST Pass 2/2
CEILING Pass 4/4
CHIDIST Pass 2/2
CHIINV Pass 2/2
CHITEST Pass 1/1
CONCATENATE Pass 3/3
CONFIDENCE Pass 2/2
COVAR Pass 1/1
CRITBINOM Pass 2/2
EXPONDIST Pass 2/2
FDIST Pass 2/2
FINV Pass 2/2
FLOOR Pass 4/4
FORECAST Not Implemented 0/1
FTEST Pass 1/1
GAMMADIST Pass 2/2
GAMMAINV Pass 1/1
HYPGEOMDIST Pass 1/1
LOGINV Pass 2/2
LOGNORMDIST Pass 1/1
MODE Pass 1/1
NEGBINOMDIST Pass 1/1
NORMDIST Pass 3/3
NORMINV Pass 2/2
NORMSDIST Pass 2/2
NORMSINV Pass 2/2
PERCENTILE Pass 2/2
PERCENTRANK Pass 2/2
POISSON Pass 2/2
QUARTILE Pass 2/2
RANK Pass 2/2
STDEV Pass 1/1
STDEVP Pass 1/1
TDIST Pass 2/2
TINV Pass 2/2
TTEST Pass 1/1
VAR Pass 1/1
VARP Pass 1/1
WEIBULL Pass 2/2
ZTEST Pass 1/1

Add-in5 functions — 0 pass, 0 fail, 0 not implemented, 5 not tested

FunctionStatusTestsFailed Expressions
CALL Not Tested
EUROCONVERT Not Tested
PY Not Tested
REGISTER.ID Not Tested
SQL.REQUEST Not Tested

Information21 functions — 17 pass, 0 fail, 3 not implemented, 1 not tested

FunctionStatusTestsFailed Expressions
CELL Pass 3/3
ERROR.TYPE Pass 2/2
INFO Not Implemented 0/1
ISBLANK Pass 3/3
ISERR Pass 3/3
ISERROR Pass 4/4
ISEVEN Pass 4/4
ISFORMULA Pass 2/2
ISLOGICAL Pass 4/4
ISNA Pass 3/3
ISNONTEXT Pass 3/3
ISNUMBER Pass 4/4
ISODD Pass 4/4
ISOMITTED Not Tested
ISREF Pass 3/3
ISTEXT Pass 4/4
N Pass 4/4
NA Pass 2/2
SHEET Not Implemented 0/1
SHEETS Not Implemented 0/1
TYPE Pass 4/4

Cube7 functions — 0 pass, 0 fail, 0 not implemented, 7 not tested

FunctionStatusTestsFailed Expressions
CUBEKPIMEMBER Not Tested
CUBEMEMBER Not Tested
CUBEMEMBERPROPERTY Not Tested
CUBERANKEDMEMBER Not Tested
CUBESET Not Tested
CUBESETCOUNT Not Tested
CUBEVALUE Not Tested

Date & Time25 functions — 25 pass, 0 fail, 0 not implemented, 0 not tested

FunctionStatusTestsFailed Expressions
DATE Pass 4/4
DATEDIF Pass 4/4
DATEVALUE Pass 3/3
DAY Pass 3/3
DAYS Pass 4/4
DAYS360 Pass 3/3
EDATE Pass 4/4
EOMONTH Pass 4/4
HOUR Pass 3/3
ISOWEEKNUM Pass 3/3
MINUTE Pass 3/3
MONTH Pass 3/3
NETWORKDAYS Pass 3/3
NETWORKDAYS.INTL Pass 2/2
NOW Pass 1/1
SECOND Pass 3/3
TIME Pass 4/4
TIMEVALUE Pass 3/3
TODAY Pass 1/1
WEEKDAY Pass 4/4
WEEKNUM Pass 3/3
WORKDAY Pass 3/3
WORKDAY.INTL Pass 2/2
YEAR Pass 3/3
YEARFRAC Pass 3/3

Database12 functions — 0 pass, 0 fail, 0 not implemented, 12 not tested

FunctionStatusTestsFailed Expressions
DAVERAGE Not Tested
DCOUNT Not Tested
DCOUNTA Not Tested
DGET Not Tested
DMAX Not Tested
DMIN Not Tested
DPRODUCT Not Tested
DSTDEV Not Tested
DSTDEVP Not Tested
DSUM Not Tested
DVAR Not Tested
DVARP Not Tested

Web3 functions — 0 pass, 0 fail, 0 not implemented, 3 not tested

FunctionStatusTestsFailed Expressions
ENCODEURL Not Tested
FILTERXML Not Tested
WEBSERVICE Not Tested