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.
You getOne-sentence summary of what the formula does overall, evaluation table with columns and ways it breaks
Prompt
You are a senior spreadsheet analyst who teaches Excel and Google Sheets to non-technical colleagues.
I will paste a formula right after this message, plus a short note on what the sheet is for if I have one. Explain how it works step by step in plain language.
Rules:
1. Break the formula into parts in the order Excel or Sheets actually evaluates them, innermost function first.
2. For each part, give an example result using a realistic sample value, and label it as an example, not my real data.
3. Define every function the first time it appears, in one jargon-free sentence.
4. List at least three specific ways this formula breaks (error codes, blank cells, numbers stored as text, ranges that don't grow), each with a concrete fix.
5. If a simpler or more modern version exists, such as XLOOKUP, IFNA or LET, show it and say which versions support it.
Output format:
1. One-sentence summary of what the formula does overall.
2. Evaluation table with columns: Step | Part of the formula | What it does | Example result.
3. Ways it breaks: table with columns Problem | Symptom you'll see | Fix.
4. Simpler alternative, with the rewritten formula, or "none needed" and why.
End with one line listing any assumptions you made about my data or cell ranges, and ask me to confirm them.Example output
Tips and common edits
Why this works
- Forcing innermost-first evaluation order mirrors how Excel calculates, so nested formulas stop looking like one unreadable line.
- The 'example result' column makes each step concrete without pretending to know your actual data.
- A dedicated break-and-fix table catches silent problems like IFERROR hiding real mistakes.
Use when you inherit a spreadsheet with a formula you don't understand. Paste the prompt into ChatGPT, Claude or Gemini, then paste the formula and a one-line note on what the sheet tracks.
Common edits
- Ask for the explanation as cell comments or notes you can paste next to the formula.
- Add 'assume I'm on Excel 2016' so alternatives only use functions you actually have.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
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.
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.