Formula Repair & Audit
Every broken formula found, fixed and written down.
For a workbook whose numbers you no longer quite trust. We trace each formula, fix what is broken and document every error we find, so you know what was wrong, where, and what changed.
Best for: The budget, pricing or inventory workbook where totals look off or return errors.
Formula Repair & Audit
$129
Fixed price · back in 3 business days
Up to 10 sheets, with error log
Secure checkout by Stripe. Just your email, no account needed.
Need it sooner? Rush Delivery (+$49 or +30%, whichever is higher) gets any cleanup package back in 24 hours.
Exactly what is covered
Limits: Up to 10 sheets, with error log
In scope
- Up to 10 sheets
- Fix #REF!, #VALUE!, #N/A and #DIV/0! errors and broken lookups
- Correct wrong cell references and inconsistent formulas down a column
- Replace hard-coded numbers typed over formulas with live formulas
- A full error log: location, what was wrong, the fix, and the impact
Not included
- Cleaning the underlying data (see Starter, Standard or Premium Cleanup)
- Restructuring the workbook layout (see Premium Cleanup)
- Macros / VBA, Power Query and external data connections
- Building new reports or dashboards
Before and after
Audit example: a broken-formula list vs the documented fix log. Sample data for illustration.
Before: problems found
| Cell | Problem |
|---|---|
| Budget!D5 | =SUM(D2:D3) misses row 4 |
| Budget!E9 | #REF! after a deleted column |
| Prices!C7 | 12.50 typed over a formula |
| Prices!F2 | VLOOKUP returns #N/A |
After: fix log
| Cell | Problem |
|---|---|
| Budget!D5 | Fixed: =SUM(D2:D4). Total was $310 low |
| Budget!E9 | Fixed: reference restored to column C |
| Prices!C7 | Fixed: =B7*1.25. Live formula restored |
| Prices!F2 | Fixed: exact-match lookup, trailing spaces cleaned |
- Every error logged with its location, cause, fix and impact
- Dollar impact noted where a wrong formula changed a total
- Original formulas kept in the log so any fix can be reversed
What you get back
Delivered by email in 3 business days. The clock starts when we receive your file and confirm scope.
Your cleaned spreadsheet
Returned in the format you sent, ready to use.
Before/after change log
Every fix recorded, so you can check any decision.
One-page "how this sheet works"
A plain-English guide and simple rules to keep it clean.
Your data stays yours
Worked on a copy
We never touch your original file.
Originals deleted
Your files are deleted after delivery.
NDA available
Ask and we will sign one before you upload.
Questions
What is the difference between this and Premium Cleanup?
Formula Repair & Audit looks only at formulas and gives you a full error log. Premium Cleanup also cleans the data and restructures the workbook.
What does the error log include?
Each entry lists the sheet and cell, what was wrong, the corrected formula and the effect on your numbers, so you can review every change.
What are the limits?
Up to 10 sheets with an error log. Macros/VBA and external data connections are outside this package.
Will you change my data or layout?
No. We fix formulas and note any data problems we spot in the log for you to decide on. Layout stays as you built it.
How long does it take, and is my data safe?
3 business days from when we receive your file and confirm scope. We work on a copy, delete your original files after delivery and will sign an NDA if you ask. Rush Delivery gets it back in 24 hours.