# Explain a complicated Excel formula in plain English

Breaks down a long or nested Excel formula step by step, says what it actually returns, and points out hidden risks.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Data & Analytics, Explain & Teach, Code, Fill-in Template, Step-by-step
- Source: https://www.thinkwithprompt.com/prompts/explain-a-complicated-excel-formula-in-plain-english

## Prompt

```text
Explain this Excel formula to me in plain English.

**Formula:** [PASTE the full formula exactly as it appears in the cell]
**Where it sits:** [sheet name, cell, and what the column or row is supposed to show]
**What the referenced cells or ranges contain:** [e.g. "A2 = order date, Rates!B:C = currency rates table" - paste a few sample values if you can]
**My comfort level:** [beginner / comfortable with SUM and IF / advanced]

Return:
1. **One-sentence summary:** what the formula calculates, in business terms.
2. **Step-by-step breakdown:** work from the innermost function outward. For each piece, say what it does and what it returns using my sample values.
3. **Worked example:** run one real row through it so I can check the result against the cell.
4. **Hidden behavior and risks:** what happens with blanks, text in number cells, errors, missing lookup matches, whole-column references, absolute vs. relative references ($) when copied, and anything hard-coded inside the formula (rates, dates, thresholds).
5. **Simpler version** if one exists in my Excel version (e.g. XLOOKUP instead of nested INDEX/MATCH, IFS instead of nested IF, LET to name parts), with the exact replacement formula.
6. **A comment I can add to the cell** explaining it for the next person, in under 25 words.

If part of the formula depends on something you cannot see (a named range, another sheet, a macro), say so and tell me what to check rather than guessing.
```

## What to fill in

- PASTE the full formula exactly as it appears in the cell
- beginner / comfortable with SUM and IF / advanced

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.