What the Formula Explainer does
The Formula Explainer reads an Excel formula and turns it into a numbered list of steps written in plain English. Each step shows one piece of the formula, such as a function call, a comparison, or a range reference, and describes what that piece contributes. Nested pieces are indented, so you can see which calculation runs first and which result feeds the next one.
Use it when you open a workbook someone else built and a cell contains a formula you do not recognise, when you copy a formula from a forum and want to understand it before trusting it, or when you are reviewing your own work and want to check that the logic matches what you intended. The parser runs in your browser. The formula is not sent to a server and no AI model is involved.
How to use it
- Copy the formula from the Excel formula bar. Including the leading equals sign is optional.
- Paste it into the box on this page. The limit is 2,000 characters.
- Select Explain this formula. The breakdown appears below the box.
- Read the steps from the most indented row upward: the innermost calculations are evaluated first.
- Use the function links next to each step to read the reference page for a function you have not used before.
- If the formula cannot be parsed, check the message, fix unbalanced brackets or quotes, and try again.
Worked examples
A simple condition
Input: =IF(A2>100,"High","Low")
Result: If A2 contains 150, the cell shows "High". If A2 contains 80, it shows "Low".
Why: IF tests the comparison A2>100. When the test is TRUE it returns the second argument, otherwise the third. The explainer lists the comparison as its own step so you can see exactly what is being tested.
A lookup with a fallback
Input: =IFERROR(VLOOKUP(B2,$E$2:$F$50,2,FALSE),"Not found")
Result: If the value in B2 exists in E2:E50, the matching value from column F is returned. If it does not exist, the cell shows "Not found" instead of #N/A.
Why: VLOOKUP runs first because it is nested inside IFERROR. FALSE requests an exact match. The dollar signs keep the lookup range fixed when the formula is filled down. IFERROR only acts when VLOOKUP returns an error.
Arithmetic around a function
Input: =ROUND(AVERAGE(A1:A4)*1.2,2)
Result: With 10, 20, 30 and 41 in A1:A4, the result is 30.3.
Why: AVERAGE returns 25.25, multiplying by 1.2 gives 30.3, and ROUND to two decimal places leaves 30.3. The explainer shows AVERAGE as the deepest step, then the multiplication, then ROUND.
Common parsing problems
- Unbalanced brackets
- Every opening bracket needs a closing one. A missing bracket usually appears at the end of a long nested formula.
- Curly or smart quotes
- Quotes copied from a document or web page can be typographic quotes. Excel and the parser both need straight double quotes.
- Semicolon separators
- Some regional versions of Excel separate arguments with semicolons. Replace them with commas before pasting.
- Very new syntax
- LAMBDA bodies and complex structured references may receive a generic description rather than a detailed one.
Frequently asked questions
Is my formula uploaded anywhere?
No. The parser is part of the page and runs in your browser. The formula is not sent to a server.
Does it calculate the result of my formula?
No. It explains the structure and what each part does. It does not have access to your workbook values, so it cannot calculate the final result.
Why does the order of steps matter?
Excel evaluates the innermost function first and passes its result outward. Reading the steps in that order shows how the final value is produced.
Can I paste a formula without the equals sign?
Yes. The leading equals sign is optional.