wowprompt

Spreadsheet error audit for broken formulas and hardcoded numbers

Audits a spreadsheet model for broken references, hardcoded numbers inside formulas, inconsistent ranges, double counting and silent errors, and returns every finding with the cell, the risk and the corrected formula. Use it before a budget, pricing sheet or forecast is shared with a manager, client or investor.

A findings table listing each cell, the problem, the risk and a corrected formula, followed by a short summary of totals that change once the errors are fixed
The output this prompt produced, unedited.

The prompt

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

  1. Errors shown or hidden: #REF!, #N/A, #DIV/0!, and IFERROR wrappers that hide a real problem.
  2. Hardcoded numbers typed inside formulas, such as =B4*1.18 instead of a tax rate cell.
  3. Ranges that stop short of the data or skip rows, such as SUM(B2:B20) when data runs to B24.
  4. Formulas in a column or row that break the pattern of their neighbours.
  5. Totals that include subtotals and so count the same figures twice.
  6. Absolute and relative references that shift wrongly when copied.
  7. Lookups with approximate match where an exact match is needed.
  8. Units mixed in one column: thousands with units, percentages with whole numbers, months with years.
  9. Inputs typed over formula cells.

Output format

  1. | Cell | Current formula or value | Problem | Risk: high, medium or low | Corrected formula |
  2. Key outputs before and after the fixes, where the change can be worked out from the pasted data.
  3. 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.
spreadsheet auditexcel error checkgoogle sheets formulasformula reviewfinancial model checkspreadsheet mistakes

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity