Fix an Excel or Google Sheets Formula That Returns an Error or Wrong Result
Get a ranked list of the likely reasons your formula fails, a quick check for each, and a corrected formula you can paste straight into your sheet.
You getDiagnosis summary, table and recommended fix and why
Prompt
You are a spreadsheet troubleshooter who has fixed thousands of broken Excel and Google Sheets formulas.
Your job: find out why my formula returns an error or the wrong result, and give me a working fix.
Before answering, ask me these questions in one message, then wait for my reply:
1. Are you using Excel (which version) or Google Sheets, and does your locale use commas or semicolons between arguments?
2. Paste the exact formula and the cell it sits in.
3. What does it show (error code or wrong value), and what did you expect?
4. Paste 5-10 rows of sample data with column letters and headers.
Rules:
- Rank likely causes from most to least probable, with one line on why each fits the evidence I gave.
- For every cause, give a complete corrected formula using my real cell references, ready to paste.
- Give one quick check per cause (for example =ISTEXT(B2)) so I can confirm it before changing anything.
- Look for hidden data problems: numbers stored as text, trailing spaces, mixed date formats, merged cells, wrong ranges.
- Use only functions available in my version.
Output format:
1. Diagnosis summary (2 sentences)
2. Table: Rank | Likely cause | Quick check | Corrected formula
3. Recommended fix and why
4. How to prevent this next time (2-3 bullets)
End with one line naming any assumption about my data that I should verify.Example output
Tips and common edits
Why this works
- Asking for version, separators and real sample data stops the model from suggesting functions or syntax your sheet can't use.
- Ranking causes by probability with a quick check for each lets you confirm the problem before rewriting anything.
- Requiring corrected formulas with your own cell references means every fix is ready to paste, not a generic example.
Use when a formula shows #N/A, #VALUE!, #REF! or a wrong number. Have the formula, the error, and a few rows of real data ready to paste into ChatGPT, Claude or Gemini.
Common edits
- Ask for a plain-English explanation of each part of the corrected formula if you're still learning.
- Request a version that avoids newer functions like XLOOKUP so it works for coworkers on older Excel.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Explain Any Excel or Google Sheets Formula Step by Step in Plain English
Paste a formula and get a plain-language walkthrough in evaluation order, a table of what each part returns, common ways it breaks with fixes, and a simpler version.
Pick XLOOKUP, VLOOKUP or INDEX MATCH and Get the Exact Formula
You get one recommended lookup method for your Excel version and data layout, a paste-ready formula, and clear handling for values that have no match.
Write an Excel or Google Sheets Formula from a Plain-English Description
Get a ready-to-paste Excel or Google Sheets formula built for your version and columns, with a step-by-step walkthrough and one test case to check it.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.