SaferSheetsSaferSheetsBeta

EXCEL FORMULA CHECKER · FORMULA DOCTOR

An Excel formula checker for the breaks you can't see.

Most Excel formula problems aren't the red #REF! cells you can find with a glance. They're the VLOOKUPs returning the wrong column, the SUM ranges that drifted by one row, the AVERAGE that silently excludes hidden cells. The Excel formula checker parses every formula in your workbook and surfaces every break — visible and silent.

Check formulas freeSee pricing →

Free tier — 30 audits/month — no card required.

Excel won't tell you when a formula is wrong, only when it's broken

Excel shows red triangles when a formula throws an error. It says nothing when a formula returns a perfectly valid-looking number that's mathematically wrong. A VLOOKUP that's pointing one column off, an INDEX-MATCH where the row index drifted by 2, a SUM that excludes a hidden row — these all return clean numbers. Wrong ones.

The Excel formula checker reads every formula and runs structural sanity checks: are the ranges consistent across the column? does the lookup target still exist? are any literal numbers buried inside otherwise-clean formulas? Each finding ties back to the exact cell with a one-paragraph explanation.

How the formula check works

  1. 1

    1. Upload

    Drop your .xlsx or pick a Google Sheet. SaferSheets reads every formula across every sheet.

  2. 2

    2. Parse the formula graph

    Each formula is parsed into its syntax tree. The checker walks the tree looking for known break patterns and risky constructs.

  3. 3

    3. Rank by severity

    Critical (error cells, broken refs) at the top. Risky (hardcoded constants, volatile functions) in the middle. Soft warnings at the bottom.

  4. 4

    4. Drill into any finding

    Click any issue to see the cell, the formula, the explanation, and a suggested fix in actual formula syntax — paste-able into Excel.

Formula problems the checker catches

Standard Excel error states (#REF!, #DIV/0!, etc.) plus the harder-to-spot patterns that quietly return wrong numbers.

  • All seven Excel error types

    #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?, #NUM!, #NULL! — each listed by cell address with the originating formula and the most likely root cause.

  • Broken VLOOKUP / XLOOKUP / INDEX-MATCH

    Formula syntax is valid, but the lookup column has moved or the target range no longer contains the key. Returns #N/A or worse, the wrong row.

  • Circular references

    A1 depends on B1, B1 depends on A1. Excel will calculate them (incorrectly) by default. The checker finds the cycle and tells you which cells are involved.

  • Inconsistent range endpoints

    One row of formulas sums to row 100, another row to row 99 or 105. Easy to miss; common when rows are added later. The check finds them across the whole column.

  • Volatile functions

    OFFSET, INDIRECT, NOW, TODAY, RAND, RANDBETWEEN — these recalculate on every change. A workbook full of them slows down. The check lists them so you can decide what's necessary.

  • Formulas referencing deleted sheets

    When a sheet is deleted, references to it become #REF! — but only after Excel recalculates. Until then, the formula caches the last-known value and looks fine.

  • Hardcoded numbers in formulas

    =SUM(A1:A10) + 5000, =A2 * 0.23 — literal numbers jammed into formulas. Often legitimate constants; sometimes forgotten overrides. Each is flagged for review.

  • Formula inconsistency across a region

    Eight of the ten cells in a row use one formula pattern, the other two are slightly different — a copy-paste mistake. The check flags the outliers.

Frequently asked questions

Will this catch VLOOKUP errors that don't throw #N/A?

+

Yes — that's one of the things the formula checker is specifically designed for. A VLOOKUP can return a value (no error) but be pointing at the wrong column because columns have been added or removed since the formula was written. The checker compares the lookup target's structure to what the formula expects and flags mismatches.

Can I see the formula syntax the checker suggests as a fix?

+

Yes. Every fix-suggestion comes with the actual formula syntax — paste-able directly into Excel. For example: if you have =VLOOKUP(A2, B:F, 4, FALSE) where column 4 used to be "Region" but is now "Manager", the suggested fix is =VLOOKUP(A2, B:F, 3, FALSE) along with an explanation of which column moved.

Does it find circular references?

+

Yes. The checker builds a formula dependency graph and detects cycles. A cycle of any length (A→B→A, A→B→C→A, etc.) gets flagged. Excel itself will calculate circular formulas iteratively, often producing a value that looks right but isn't — these are particularly easy to miss without the dependency graph.

How does it handle array formulas / dynamic arrays?

+

Standard array formulas (Ctrl+Shift+Enter) and modern dynamic-array formulas (FILTER, SORT, UNIQUE, etc.) are both supported. The checker reads the spill range and flags issues that would prevent the array from spilling correctly — like blocked cells in the target range.

Is this just a fancier version of Excel's Error Checking pane?

+

Excel's built-in pane covers cell-level error states. SaferSheets adds: dependency-graph analysis (circular refs), structural consistency (range drift), semantic checks (lookups pointing at moved columns), hardcoded-value detection, and volatile-function inventory. There's overlap on the visible errors, but the layer above is the differentiator.

Further reading

Deep-dives from the SaferSheets blog

Audit your next spreadsheet before you send it.

Free tier covers 30 audits a month. No card. Sign in with Google and you're running in under a minute.

Check formulas free

Audit. Validate. Trust your data.

Related tools