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

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

At a glanceHow the formula evaluates, step by stepExample: SKU BX-104, quantity 120
  1. MATCH finds the Price column3Locates the column headed "Price"
  2. VLOOKUP gets the unit price24.50Exact match on the SKU in A2
  3. IF sets the discount factor0.910% off when quantity is 100 or more
  4. Price times discount factor22.05Multiplies step 2 by step 3
  5. IFERROR returns the result22.05Shows "Check SKU" if any error occurs

Example for: an order sheet that looks up unit prices by SKU and applies a 10% bulk discount.

Formula: =IFERROR(VLOOKUP(A2,Products!$A$2:$D$500,MATCH("Price",Products!$A$1:$D$1,0),FALSE)*IF(C2>=100,0.9,1),"Check SKU")

1. Summary

It finds the price of the SKU in A2 on the Products sheet, takes 10% off if the quantity in C2 is 100 or more, and shows "Check SKU" if anything goes wrong.

2. Evaluation table
StepPart of the formulaWhat it doesExample result
1MATCH("Price",Products!$A$1:$D$1,0)MATCH finds the position of a value in a row or column. Here it finds which column is headed "Price".3
2VLOOKUP(A2,Products!$A$2:$D$500,3,FALSE)VLOOKUP searches the first column of a table for A2 and returns a value from another column. FALSE means exact match only.24.50 (for SKU "BX-104")
3IF(C2>=100,0.9,1)IF checks a condition and returns one of two values. 0.9 means 10% off.0.9 (C2 = 120)
4Step 2 × Step 3Multiplies price by the discount factor.22.05
5IFERROR(..., "Check SKU")IFERROR returns the result unless any error occurs, then shows the backup text.22.05
3. Ways it breaks
ProblemSymptom you'll seeFix
SKU stored as a number in one sheet and text in the other"Check SKU" on rows that look correctMake both columns the same type, e.g. use TEXT(A2,"0") or Data > Text to Columns
Someone renames the "Price" header to "Unit Price"Every row shows "Check SKU"Update the text in MATCH or reference the header cell instead
Product list grows past row 500New SKUs show "Check SKU"Use whole columns $A:$D or convert the range to a Table
IFERROR hides typos in the formula itselfWrong results with no error shownUse IFNA, which only catches "not found"
4. Simpler alternative

=IFNA(XLOOKUP(A2,Products!$A:$A,Products!$C:$C)*IF(C2>=100,0.9,1),"Check SKU")
Works in Excel 365, Excel 2021 and later, and Google Sheets. Not available in Excel 2019 or earlier.

Assumptions: SKUs are in column A of both sheets and prices are in column C of Products. Please confirm.

Written by AI from this prompt. Your results will vary.

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 in Excel & Spreadsheets