Explain Excel and Sheets formulas step by step.
Paste a formula. See what each function, range, and condition does.
Fix a broken formulaHow to explain a formula
01
Paste the formula
Copy the exact text from the formula bar, including the leading equals sign.
02
Choose Excel or Sheets
The same letters can mean different functions on each platform.
03
Read the parts
The explainer lists functions, ranges, and conditions in evaluation order.
04
Decide next
Keep the formula, simplify it, or switch to the generator if you need a rewrite.
What the explainer is for
Inherited workbooks often contain formulas nobody wants to rewrite from scratch. The explainer maps functions, ranges, and branches so you can decide whether to keep, simplify, or replace the logic. It is not a generator: it does not invent a new formula unless you switch to the Excel or Sheets generator.
How to get a useful explanation
- Paste the exact formula from the formula bar, including the leading equals sign.
- Say whether the file is Microsoft Excel or Google Sheets if the function set could differ.
- Name tables or structured references if the formula uses them.
- If the result is wrong, use the fixer and include the error and a sample row.
Formula explainer FAQ
When should I explain a formula instead of generating one?
Use the explainer when you already have a formula in a cell and need to know what it does. Use the generator when you need a new formula.
Does the explainer change my workbook?
No. It reads the text you paste and returns an explanation. It does not write into Excel or Google Sheets.
Can it explain nested IF and LOOKUP formulas?
Yes. Paste the full formula, including extra parentheses. Mention whether the file is Excel or Google Sheets if functions might differ.