ExcelFormulas logoExcelFormulas.
Ask AI
LIVE PRODUCTION QA SYSTEM

Excel Formula Automated QA Dashboard

Automated test verification engine continuously executing 15 boundary variations per formula, validating calculation fidelity, regression fixes, and platform support matrices.

QA Matrix View ↓
Discovered
133
Canonical registry
Total Tests
1995
15 per formula
Passed
1425
71.4% verified
Unverified
570
Honest gaps (Rule 9)
Failed
0
0 regressions
Bugs Fixed
16/16
100% regression tests

Permanent Regression Test Suite (16 Tests)

ALL PASSING
Bug IDFormulaComponentBug Diagnosis & FixStatus
BUG-001COUNTSpreadsheetGrid & ExcelEvaluatorCOUNT must count only numeric values, not text cellsReturns 3 (counting only 10, 20, 30)PASS
BUG-002AVERAGESpreadsheetGrid & ExcelEvaluatorAVERAGE must ignore text cells in range instead of adding 0Evaluates to (10 + 20) / 2 = 15.00PASS
BUG-003ROUNDSpreadsheetGrid & ExcelEvaluatorROUND must return #VALUE! for non-numeric text inputsReturns #VALUE!PASS
BUG-004NETWORKDAYSSpreadsheetGrid & ExcelEvaluatorNETWORKDAYS must return negative working days when start > endReturns negative integer (e.g. -9 working days)PASS
BUG-005SORTBYFormulaGenerator buildWizardFormulaSORTBY row number regex must strip all digits with /\d+/gProduces =SORTBY(A10:C50, A2:A50, 1)PASS
BUG-006PERCENTILEFormulaGenerator buildWizardFormulaPERCENTILE wizard must not generate NaN for empty inputs=PERCENTILE(C2:C50, 0.9)PASS
BUG-007NETWORKDAYS.INTLwizardData translateExcelFormulaFunction translation regex must preserve dotted function namesAccurately translates =NETWORKDAYS.INTL(...) to =DIAS.LAB.INTL(...)PASS
BUG-008RANGE_VALIDATIONFormulaGeneratorEngine validateRangeCyrillic lookalikes in range inputs must be detected and converted to ASCIIDetected lookalike character, warned user, and converted to Latin ASCII C2:C50PASS
BUG-009SUMIFSFormulaGeneratorEngine escapeTextCriteriaUnquoted text criteria in SUMIFS must be safely wrapped in double quotesEmits =SUMIFS(C2:C50, B2:B50, "West")PASS
BUG-010TEXT_ESCAPINGFormulaGeneratorEngine escapeTextCriteriaInternal double quotes in text criteria must be doubled per Excel syntaxEscaped internal quotes to "15"" Monitor"PASS
BUG-011VLOOKUPFormulaGeneratorEngine validateIntegerNegative column indices in VLOOKUP/SORT must fail validationRejects negative column index with error messagePASS
BUG-012RANGE_VALIDATIONFormulaGeneratorEngine validateRangeMalformed ranges like A1: must be caught with descriptive validation messageCaught missing end cell with clear error and fallbackPASS
BUG-013CELL_COORDINATESFormulaGeneratorEngine validateCellReferenceRow numbers exceeding 1,048,576 must be rejected with Excel boundary errorExplicitly validates against 1,048,576 row limitPASS
BUG-014GENERATOR_STATUSFormulaGenerator truthful statusGenerator must never emit unverified "100% syntax-correct" false claimsEmits truthful status: "Validated formula" or "Generated and verified"PASS
BUG-015XLOOKUPFormulaGenerator platform auditModern formulas on legacy platforms must be flagged as unsupported with recommendationFlags Platform unsupported and provides alternative recommendationPASS
BUG-016PREVIEW_TABLEFormulaGenerator sample table & previewEngineFormula Generator preview table must dynamically generate distinct datasets and calculate results from current cellsDynamically generates tailored datasets based on formula/inputs and evaluates result from current cell valuesPASS
Showing 133 of 133 formulas
FormulaCategoryStatusPlatform Support MatrixInteractive FeaturesDiagnostic Inspect
XLOOKUP
lookupPASS
Excel36520212019Sheets
-
VLOOKUP
lookupPASS
Excel36520212019Sheets
-
INDEX & MATCH
lookupPASS
Excel36520212019Sheets
-
IF
logicalPASS
Excel36520212019Sheets
-
IFS
logicalPASS
Excel36520212019Sheets
-
IFERROR
logicalPASS
Excel36520212019Sheets
-
SUMIFS
mathPASS
Excel36520212019Sheets
-
COUNTIF
mathPASS
Excel36520212019Sheets
-
COUNTIFS
statPASS
Excel36520212019Sheets
-
TEXTJOIN
textPASS
Excel36520212019Sheets
-
FILTER
arrayPASS
Excel36520212019Sheets
-
UNIQUE
arrayPASS
Excel36520212019Sheets
-
TODAY
datePASS
Excel36520212019Sheets
-
NETWORKDAYS
datePASS
Excel36520212019Sheets
-
PMT
financePASS
Excel36520212019Sheets
-
SUM
mathPASS
Excel36520212019Sheets
-
AVERAGE
statPASS
Excel36520212019Sheets
-
COUNT
statPASS
Excel36520212019Sheets
-
LEFT
textPASS
Excel36520212019Sheets
-
RIGHT
textPASS
Excel36520212019Sheets
-
TRIM
textPASS
Excel36520212019Sheets
-
PROPER
textPASS
Excel36520212019Sheets
-
ROUND
mathPASS
Excel36520212019Sheets
-
AND
logicalPASS
Excel36520212019Sheets
-
OR
logicalPASS
Excel36520212019Sheets
-
CONCAT
textPASS
Excel36520212019Sheets
-
LEN
textPASS
Excel36520212019Sheets
-
HLOOKUP
lookupPASS
Excel36520212019Sheets
-
ISBLANK
infoPASS
Excel36520212019Sheets
-
ISNUMBER
infoPASS
Excel36520212019Sheets
-
ISTEXT
infoPASS
Excel36520212019Sheets
-
ISERROR
infoPASS
Excel36520212019Sheets
-
DSUM
databasePASS
Excel36520212019Sheets
-
DCOUNT
databasePASS
Excel36520212019Sheets
-
DAVERAGE
databasePASS
Excel36520212019Sheets
-
CONVERT
engineeringPASS
Excel36520212019Sheets
-
DELTA
engineeringPASS
Excel36520212019Sheets
-
BIN2DEC
engineeringPASS
Excel36520212019Sheets
-
SORT
arrayPASS
Excel36520212019Sheets
-
SORTBY
arrayPASS
Excel36520212019Sheets
-
SEQUENCE
arrayPASS
Excel36520212019Sheets
-
TOCOL
arrayPASS
Excel36520212019Sheets
-
RANK
compatibilityPASS
Excel36520212019Sheets
-
MODE
compatibilityPASS
Excel36520212019Sheets
-
ARRAYFORMULA
sheetsPASS
Excel36520212019Sheets
-
QUERY
sheetsPASS
Excel36520212019Sheets
-
SPARKLINE
sheetsPASS
Excel36520212019Sheets
-
IMPORTRANGEDraft
sheetsUNVERIFIED
Excel36520212019Sheets
-
FV
financePASS
Excel36520212019Sheets
-
PV
financePASS
Excel36520212019Sheets
-
NPV
financePASS
Excel36520212019Sheets
-
ABS
mathPASS
Excel36520212019Sheets
-
MOD
mathPASS
Excel36520212019Sheets
-
POWER
mathPASS
Excel36520212019Sheets
-
SQRT
mathPASS
Excel36520212019Sheets
-
PRODUCT
mathPASS
Excel36520212019Sheets
-
CEILING
mathPASS
Excel36520212019Sheets
-
FLOOR
mathPASS
Excel36520212019Sheets
-
SWITCH
logicalPASS
Excel36520212019Sheets
-
NOT
logicalPASS
Excel36520212019Sheets
-
XOR
logicalPASS
Excel36520212019Sheets
-
IFNA
logicalPASS
Excel36520212019Sheets
-
INDEX
lookupPASS
Excel36520212019Sheets
-
MATCH
lookupPASS
Excel36520212019Sheets
-
CHOOSE
lookupPASS
Excel36520212019Sheets
-
OFFSET
referencePASS
Excel36520212019Sheets
-
MID
textPASS
Excel36520212019Sheets
-
UPPER
textPASS
Excel36520212019Sheets
-
LOWER
textPASS
Excel36520212019Sheets
-
SUBSTITUTE
textPASS
Excel36520212019Sheets
-
REPLACE
textPASS
Excel36520212019Sheets
-
VALUE
textPASS
Excel36520212019Sheets
-
DATE
datePASS
Excel36520212019Sheets
-
DAYS
datePASS
Excel36520212019Sheets
-
EDATE
datePASS
Excel36520212019Sheets
-
EOMONTH
datePASS
Excel36520212019Sheets
-
YEAR
datePASS
Excel36520212019Sheets
-
MONTH
datePASS
Excel36520212019Sheets
-
DAY
datePASS
Excel36520212019Sheets
-
MEDIAN
statPASS
Excel36520212019Sheets
-
MIN
statPASS
Excel36520212019Sheets
-
MAX
statPASS
Excel36520212019Sheets
-
COUNTA
statPASS
Excel36520212019Sheets
-
COUNTBLANK
statPASS
Excel36520212019Sheets
-
LARGE
statPASS
Excel36520212019Sheets
-
SMALL
statPASS
Excel36520212019Sheets
-
INTDraft
mathPASS
Excel36520212019Sheets
-
SUMPRODUCTDraft
mathPASS
Excel36520212019Sheets
-
MINADraft
statUNVERIFIED
Excel36520212019Sheets
-
MAXADraft
statUNVERIFIED
Excel36520212019Sheets
-
STDEVDraft
statUNVERIFIED
Excel36520212019Sheets
-
STDEVPDraft
statUNVERIFIED
Excel36520212019Sheets
-
VARDraft
statUNVERIFIED
Excel36520212019Sheets
-
VARPDraft
statUNVERIFIED
Excel36520212019Sheets
-
PERCENTILEDraft
statUNVERIFIED
Excel36520212019Sheets
-
QUARTILEDraft
statUNVERIFIED
Excel36520212019Sheets
-
CORRELDraft
statUNVERIFIED
Excel36520212019Sheets
-
FORECASTDraft
statUNVERIFIED
Excel36520212019Sheets
-
CLEANDraft
textPASS
Excel36520212019Sheets
-
REPTDraft
textPASS
Excel36520212019Sheets
-
EXACTDraft
textPASS
Excel36520212019Sheets
-
TEXTDraft
textUNVERIFIED
Excel36520212019Sheets
-
FINDDraft
textUNVERIFIED
Excel36520212019Sheets
-
SEARCHDraft
textUNVERIFIED
Excel36520212019Sheets
-
CHARDraft
textUNVERIFIED
Excel36520212019Sheets
-
CODEDraft
textUNVERIFIED
Excel36520212019Sheets
-
NETWORKDAYS.INTLDraft
dateUNVERIFIED
Excel36520212019Sheets
-
WORKDAYDraft
dateUNVERIFIED
Excel36520212019Sheets
-
NOWDraft
datePASS
Excel36520212019Sheets
-
DATEDIFDraft
dateUNVERIFIED
Excel36520212019Sheets
-
HOURDraft
dateUNVERIFIED
Excel36520212019Sheets
-
MINUTEDraft
dateUNVERIFIED
Excel36520212019Sheets
-
SECONDDraft
dateUNVERIFIED
Excel36520212019Sheets
-
WEEKDAYDraft
dateUNVERIFIED
Excel36520212019Sheets
-
WEEKNUMDraft
dateUNVERIFIED
Excel36520212019Sheets
-
INDIRECTDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
ADDRESSDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
TRANSPOSEDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
ROWDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
COLUMNDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
ROWSDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
COLUMNSDraft
referenceUNVERIFIED
Excel36520212019Sheets
-
AVERAGEIFSDraft
statUNVERIFIED
Excel36520212019Sheets
-
ROUNDUPDraft
mathPASS
Excel36520212019Sheets
-
ROUNDDOWNDraft
mathPASS
Excel36520212019Sheets
-
MROUNDDraft
mathPASS
Excel36520212019Sheets
-
TRUNCDraft
mathPASS
Excel36520212019Sheets
-
IRRDraft
financeUNVERIFIED
Excel36520212019Sheets
-
RATEDraft
financeUNVERIFIED
Excel36520212019Sheets
-
NPERDraft
financeUNVERIFIED
Excel36520212019Sheets
-
IPMTDraft
financeUNVERIFIED
Excel36520212019Sheets
-
PPMTDraft
financeUNVERIFIED
Excel36520212019Sheets
-
SLNDraft
financeUNVERIFIED
Excel36520212019Sheets
-