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
Fill in the blanks
- 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.
| Variable | Type | Required | Default | Options | About |
|---|---|---|---|---|---|
spreadsheet_app | Dropdown | Required | Excel for Windows/Mac | Excel for Windows/Mac, Excel for the web, Google Sheets, LibreOffice Calc, Other / unsure | Choose the application where the formula fails. |
failure_modeWhat is going wrong? | Dropdown | Required | None | Formula parse/syntax error, Error code, Formula displayed as text, Wrong result, Does not recalculate, Breaks when copied/filled down, Other / unsure | Choose the symptom closest to what you see. |
formulaExact formula | Text | Required | None | Any value | Paste the exact formula as shown in the formula bar. |
expected_vs_actualExpected vs actual result | Text | Required | None | Any value | Include the exact error message if one appears. |
sample_dataRelevant sample data (optional) | Text | Optional | Not provided | Any value | Remove confidential or personal data. |
argument_separatorFormula argument separator | Dropdown | Optional | Not sure — default | Comma (,), Semicolon (;), Not sure — default | Only 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.
- Formula Breaks When Filled DownSpreadsheet app: Excel for Windows/MacWhat is going wrong?: Breaks when copied/filled…Exact formula: =B2*F1You are a careful spreadsheet formula debugger. Identify why an existing formula is failing, explain the likely cause, and provide a safe, testable…
- Google Sheets Parse ErrorSpreadsheet app: Google SheetsWhat is going wrong?: Formula parse/syntax errorExact formula: =IF(A2>10,"High","Low"You are a careful spreadsheet formula debugger. Identify why an existing formula is failing, explain the likely cause, and provide a safe, testable…
- Formula Shows as TextSpreadsheet app: Excel for Windows/MacWhat is going wrong?: Formula displayed as textExact formula: =SUM(B2:B10)You are a careful spreadsheet formula debugger. Identify why an existing formula is failing, explain the likely cause, and provide a safe, testable…
How to use this prompt
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.
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.
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.
More from chatgpt
All prompts by chatgpt- Missed Connecting Flight Claim Builder — Compensation & ExpensesMissed a connecting flight because of a delay? Organize your booking, final arrival delay, rebooking, expenses and…
- Resignation Letter Requesting Early Release — Notice Period & BuyoutWork out a resignation timeline and draft an early-release request based on your actual notice terms, desired last…
- Rental Application Letter for First-Time Renters With No Rental HistoryCreate a truthful rental application when you have no rental history by explaining the gap and organizing legitimate…
- Chargeback Response Generator — Evidence Analyzer & RebuttalAnalyze a merchant chargeback, map each dispute claim to actual evidence, identify missing proof, and draft a…
- How to Respond to a Negative Google Review — Reply CoachWrite a professional, tailored reply to a negative Google review. Check privacy and reputation risks, handle disputed…
- Washing Machine Won't Drain? Safe TroubleshooterTroubleshoot a washing machine that won't drain using your symptoms, error code, and checks already performed. Get…
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.