What to give
- Sheet contents with formulas shown: [paste cells as cell address, formula or value; or paste the sheet with formulas visible]
- What the sheet does: [e.g. monthly budget for a 12-person team, pricing calculator, sales forecast]
- Which cells are the key outputs: [e.g. B40 total cost, F12 margin]
- Tool: [Excel or Google Sheets]
- Known worries: [e.g. totals do not match the bank statement]
Task
Check every formula and input, list what is wrong or risky, and give the fix.
Audit checklist
- Errors shown or hidden: #REF!, #N/A, #DIV/0!, and IFERROR wrappers that hide a real problem.
- Hardcoded numbers typed inside formulas, such as =B4*1.18 instead of a tax rate cell.
- Ranges that stop short of the data or skip rows, such as SUM(B2:B20) when data runs to B24.
- Formulas in a column or row that break the pattern of their neighbours.
- Totals that include subtotals and so count the same figures twice.
- Absolute and relative references that shift wrongly when copied.
- Lookups with approximate match where an exact match is needed.
- Units mixed in one column: thousands with units, percentages with whole numbers, months with years.
- Inputs typed over formula cells.
Output format
- | Cell | Current formula or value | Problem | Risk: high, medium or low | Corrected formula |
- Key outputs before and after the fixes, where the change can be worked out from the pasted data.
- Three changes to the sheet layout that would prevent these errors, such as one inputs tab.
Guardrails
- Do not rewrite formulas that are correct only to make them shorter.
- If a cell's purpose is unclear, ask about it in a questions list rather than guessing.
- Give formulas in the syntax of the tool named.






