Excel Formula Checker: find errors that look right at first glance.
Some spreadsheet failures are obvious, such as #REF! or #DIV/0!. Others are harder to see: one formula differs from the rows around it, a pasted value replaces a formula, a total stops one row early, or a lookup quietly uses approximate matching. A useful formula check looks for both kinds.
What an Excel formula checker should look for
Visible error values are only one category of risk. A stronger review also compares formulas to their surrounding pattern and follows workbook structure far enough to find dependencies that can make a formula fragile.
Broken references and error cells
Look for formulas containing #REF! and cells whose saved result is an Excel error such as #VALUE!, #DIV/0!, #N/A, or #NAME?.
Copied-formula drift
Compare formulas vertically and horizontally. One formula that no longer follows the dominant relative-reference pattern can be a copy/paste mistake even when it returns a believable number.
Hard-coded overrides and gaps
A literal value or blank cell inside a run of formulas deserves review. It may be intentional, or it may be an accidental overwrite that breaks future updates.
Totals with missing or duplicated ranges
Check whether SUM ranges stop early, skip rows, include the same input twice, or roll labeled subtotals into another total unexpectedly.
Circular and self-referencing formulas
Trace dependencies for loops and formulas whose own cell falls inside a referenced range. These can produce warnings, stale values, or iterative results that are hard to reason about.
Lookup risks
Review VLOOKUP or HLOOKUP formulas that omit the exact-match argument, and inspect lookup source ranges for duplicate keys that can return the wrong matching row.
Blank direct inputs
A formula may be syntactically valid but still depend on an unexpectedly empty cell. Direct blank precedents are worth checking when the surrounding data suggests an input should exist.
Embedded assumptions
Repeated numbers inside formulas can hide tax rates, thresholds, growth assumptions, or conversion factors. Centralizing important assumptions in labeled input cells makes them easier to audit.
How this differs from Excel's built-in error checking
Excel already provides useful formula-auditing tools, including background error checking, Trace Precedents/Dependents, Evaluate Formula, and the Watch Window. Those tools are valuable for investigating a workbook interactively. Spreadsheet Checkup is designed as a separate static review that scans the workbook for repeated patterns and workbook-wide structural risks so you know where to look first.
The checker does not run Excel's calculation engine. It cannot prove that a formula's business logic is correct, and it does not refresh Power Query, external sources, pivots, or macros.
Want the workbook scanned for you?
Upload an .xlsx or .xlsm workbook for a read-only report of formula integrity, lookup risks, dependencies, workbook controls, and data-quality signals. No signup is required.
Run a free spreadsheet check