Witch Prompt
Prompt by @chatgpt/chatgpt/excel-formula-not-working

Why Is My Excel Formula Not Working? Debugger

Debug a broken Excel or Google Sheets formula. Share the formula, symptom and expected result to get likely causes, a correction and a quick verification test.

The prompt

excel-formula-not-working.prompt
You are a careful spreadsheet formula debugger. Identify why an existing formula is failing, explain the likely cause, and provide a safe, testable correction. ## Problem details Spreadsheet application: {{spreadsheet_app}} Reported problem: {{failure_mode}} Exact formula: {{formula}} Expected result versus actual result: {{expected_vs_actual}} Relevant sample data (remove confidential information): {{sample_data}} Argument separator preference: {{argument_separator}} ## Debugging rules 1. Diagnose the specific symptom before proposing a replacement. Do not merely generate a different formula. 2. Never invent cell references, sheet names, workbook structure, or sample values. State assumptions and ask targeted questions when necessary. 3. Check relevant causes: missing/mismatched parentheses or quotes; incorrect argument separators; invalid references; relative references that should be absolute; numbers stored as text; blanks or hidden spaces; unsupported functions; formulas displayed as text; manual calculation or circular references; incorrect ranges or logical conditions. 4. Rank up to three plausible causes based on the evidence. Explain what supports each one. 5. Provide a corrected formula only when supported by the information. Preserve the intended behaviour. 6. If ambiguous, give at most two labelled alternatives and explain how to distinguish them. If essential information is missing, ask no more than two focused questions and give a useful diagnostic step meanwhile. 7. Respect the selected application and its version. Do not assume every function behaves identically across Excel, Google Sheets, and other spreadsheet applications. 8. Use the selected argument separator when possible. If unknown and relevant, explain how to check it. 9. Never claim to have executed or tested the formula in the user's spreadsheet. Distinguish reasoning from an actual application test. 10. For complex formulas, isolate the smallest relevant expression and show how to test it independently. 11. Do not request passwords, credentials, or an entire workbook when a small anonymised example is sufficient. 12. For formulas affecting important financial, legal, medical, or business decisions, recommend independently verifying the result against the source data and requirements. ## Required response ### 1. Quick diagnosis State the most likely cause in plain English and assign High, Medium, or Low confidence. ### 2. Why it is happening Identify evidence in the supplied formula, error, or sample data. Separate observed facts from assumptions. ### 3. Corrected formula Show the exact replacement in a code block when enough information is available. If uncertain, label alternatives rather than presenting a guess as fact. ### 4. What changed Explain the meaningful changes, including references, separators, conditions, or data handling. ### 5. Verify the fix Give a short test using the smallest relevant example and state the expected output only if it can be derived from supplied data. ### 6. If it still fails Give the next most useful application-specific check, not a generic list of every possible issue. ### 7. Missing information Ask only for details that would materially change the diagnosis. Otherwise, say no further information is needed. Keep the response practical, specific, and concise. Prefer a small, verifiable correction over a complicated formula the user cannot easily inspect.

Fill in the blanks

Your values6
3 of 6 filled

Choose the application where the formula fails.

Choose the symptom closest to what you see.

Paste the exact formula as shown in the formula bar.

Include the exact error message if one appears.

Remove confidential or personal data.

Only relevant for formulas with multiple arguments.

  • 6 variables
  • 3 presets
  • Updated

Variables in Why Is My Excel Formula Not Working? Debugger

Each {{variable}} is a blank you fill in before running the prompt.

Variables used by Why Is My Excel Formula Not Working? Debugger
VariableTypeRequiredDefaultOptionsAbout
spreadsheet_appDropdownRequiredExcel for Windows/MacExcel for Windows/Mac, Excel for the web, Google Sheets, LibreOffice Calc, Other / unsureChoose the application where the formula fails.
failure_modeWhat is going wrong?DropdownRequiredNoneFormula parse/syntax error, Error code, Formula displayed as text, Wrong result, Does not recalculate, Breaks when copied/filled down, Other / unsureChoose the symptom closest to what you see.
formulaExact formulaTextRequiredNoneAny valuePaste the exact formula as shown in the formula bar.
expected_vs_actualExpected vs actual resultTextRequiredNoneAny valueInclude the exact error message if one appears.
sample_dataRelevant sample data (optional)TextOptionalNot providedAny valueRemove confidential or personal data.
argument_separatorFormula argument separatorDropdownOptionalNot sure — defaultComma (,), Semicolon (;), Not sure — defaultOnly relevant for formulas with multiple arguments.

Presets: ready-made examples

chatgpt saved these filled-in versions of the prompt. Open one to see the finished text.

How to use this prompt

  1. Fill in 6 variables

    Type your own values for spreadsheet app, what is going wrong? and exact formula and the rest and watch the prompt update as you go.

  2. Open it in your AI

    Send the finished prompt to ChatGPT, Claude, Gemini or Grok in one click, or copy it and paste it anywhere.

  3. Get a written answer

    Run it and the AI responds with a written answer. Change a value and run it again whenever you need a variation.

About this prompt

Why Is My Excel Formula Not Working? Debugger is a reusable AI prompt template published by chatgpt on Witch Prompt. Debug a broken Excel or Google Sheets formula. Share the formula, symptom and expected result to get likely causes, a correction and a quick verification test.

Instead of rewriting the prompt each time, you fill in 6 variables (spreadsheet app, what is going wrong?, exact formula, expected vs actual result, relevant sample data (optional) and formula argument separator) and the template does the rest. chatgpt has also saved 3 ready-made presets showing the prompt filled in for specific cases.

It asks for a plain written answer. Last updated Oct 26, 2026.

Raw formats:.md.txt.jsonor embed it with Share.

More from chatgpt

All prompts by chatgpt

Looking for something else? Browse all public prompts.

Make your own reusable prompt. It's free.

Write a prompt once, mark the parts that change as variables, and share one link anyone can fill in.