Excel Formula Explainer
Understand any Excel formula with plain-English explanations
Excel Formula Explainer tool
The breakdown updates as you type. Nothing is uploaded — the formula is parsed entirely in your browser.
Excel Formula Explainer: key facts
- What it does
- Understand any Excel formula with plain-English explanations
- Category
- Workplace Tools
- Cost
- Free, with no account, sign-up, or install.
- Your data
- Runs entirely in your browser — the files and text you enter are never uploaded to a server.
- Last reviewed
- . Report an incorrect result.
About the Excel Formula Explainer
A formula like =INDEX(A2:A100,MATCH(1,(B2:B100=F1)*(C2:C100=F2),0)) is perfectly valid Excel, but reading it cold — especially when someone else wrote it — requires knowing what INDEX and MATCH each do, why they are nested together, why the multiplication is there, and what the trailing zero means. Paste it here and the formula is parsed into its real structure: a plain-English summary at the top, then a breakdown that expands every nested call, names every argument, and numbers the order the parts actually run in.
The reference behind it covers 231 functions across lookup, logic, text, maths, dates, finance, statistics, the newer dynamic-array family (FILTER, SORT, UNIQUE, SEQUENCE, LET, LAMBDA), and functions that exist only in Google Sheets (QUERY, ARRAYFORMULA, REGEXEXTRACT). Operators get the same treatment, including the idioms that make inherited formulas look like line noise — the double unary minus, and multiplying comparisons together to require several conditions at once. All parsing happens in your browser; no formula text is sent to any server.
How to use it
- Type or paste a formula. The breakdown updates as you type, with or without the leading "=" sign, and both comma and semicolon argument separators are detected automatically.
- Read the plain-English summary first — one sentence describing what the whole formula produces, composed from the parts rather than from a template.
- Expand the breakdown tree to walk into each nested call. Hovering a branch highlights exactly which characters of the formula it covers.
- Check the evaluation order to see which part runs first, and the "Things to check" list for approximate-match lookups, error handlers that hide more than intended, unanchored lookup tables, and volatile functions.
- Use Format to spread a long formula across indented lines, Single line to collapse it back, and Share to produce a link that reopens the same breakdown.
- Copy the result as plain text or Markdown, or download it as a .md file for a ticket or a workbook handover note.
Why use this version
- Real parsing, not pattern matching: the formula is tokenized and parsed into a syntax tree, so nesting of any depth is followed correctly, commas inside quoted text never split an argument, and $A$1, B:C, Sheet1!A1, 'Q3 Data'!A1:B9, [Book1.xlsx]Sheet1!A1, Table1[Amount] and spilled ranges like A2# are all recognised for what they are.
- Arguments matched to the right parameter: repeating groups are expanded properly, so the fifth argument of SUMIFS is labelled criteria_range2 rather than left unnamed, and LET's trailing calculation is not mistaken for another name-value pair.
- Mistakes surfaced before they cost you: a VLOOKUP asking for column 5 of a three-column table is flagged as a guaranteed #REF!, a missing fourth argument as a silent approximate match, and a number written in quotes as a comparison that can never be true.
- Modern replacements written out for you: where a better equivalent exists the rewritten formula is generated and ready to copy — VLOOKUP and INDEX/MATCH become XLOOKUP, a chain of nested IFs becomes IFS, CONCATENATE becomes the & operator.
- Syntax errors that point at the problem: an unbalanced parenthesis, an unterminated text value, or a curly quote pasted in from a web page is reported with a caret under the exact character rather than the tool silently doing nothing.
- Browser-only processing: your formula text never leaves the page. That matters when formulas carry sensitive data labels, business logic, or proprietary calculation methods.
Frequently Asked Questions
Does the explainer work for Google Sheets formulas?
Yes, and it tells you where the two applications differ. Shared functions such as VLOOKUP, INDEX, MATCH, SUMIFS, and TEXT behave identically in both. Sheets-only functions including QUERY, ARRAYFORMULA, IMPORTRANGE, SPLIT, and REGEXEXTRACT are covered and marked as unavailable in Excel, while Excel-only additions such as GROUPBY and PIVOTBY are marked the other way. Functions introduced in a specific release, such as XLOOKUP or TEXTSPLIT, note the version they need — which is usually the answer when a formula copied from the web returns #NAME?.
Can it explain array formulas and dynamic arrays?
Array constants written with braces, such as {1,2;3,4}, are parsed as rows and columns rather than as text. The dynamic-array functions are in the reference, and the spilled-range operator A2# is recognised and described as referring to the whole spilled result. The double unary minus and the technique of multiplying comparison results together are explained as the boolean-to-number idioms they are, rather than being read literally as arithmetic.
What does a formula being "volatile" mean, and why is it flagged?
A volatile function recalculates every time anything in the workbook changes, not only when its own inputs change. TODAY, NOW, RAND, RANDBETWEEN, OFFSET, INDIRECT, and CELL all behave this way. A handful is harmless; hundreds spread through a large model is a common reason a workbook feels sluggish. INDIRECT and OFFSET get a second flag because they build their reference while the formula runs, which means Trace Precedents cannot follow them and inserting or deleting rows will not update them.
Why would VLOOKUP and INDEX/MATCH give different results?
VLOOKUP always searches the leftmost column of the lookup range and returns a column to its right, so it cannot look left, and it counts the return column by position — inserting a column inside the table silently changes what it returns. INDEX/MATCH has neither constraint. VLOOKUP also defaults to an approximate match, which quietly requires sorted data, while a typical INDEX/MATCH passes 0 to MATCH and asks for an exact one. The explainer flags both differences when it sees them and offers the XLOOKUP rewrite that removes the problem entirely.
