Get a Plain-English Formula Explanation Instead of Excel's Evaluate Formula Tool

A formula Evaluate Formula would walk in five clicks

Evaluate Formula would replace the inner VLOOKUP with a value, then the comparison with TRUE/FALSE, then IF with a text — five clicks. The Explainer shows the entire logic in one view.

Paste:
=IF(VLOOKUP(A1,B:C,2,FALSE)>100,"High","Low")

Breakdown (all at once):
IF() — Tests a condition; returns one value if true, another if false
  condition: greater-than test (>)
    left:  VLOOKUP() — Searches for a value in the first column of a range and returns a value from another column
      lookup value: cell reference A1
      table range: cell range B:C
      column index: number 2
      exact-match flag: boolean FALSE
  value if true: text "High"
  value if false: text "Low"

Explaining a formula whose references were deleted

Evaluate Formula stops at the error step. The Explainer never evaluates, so the outer function still parses — but note a parsing limit: the # of a literal #REF! token is an unrecognised character, so it and everything after it are absorbed into one raw argument. You still see the function and its first arguments. To read a clean tree, replace the #REF! with a placeholder cell before pasting.

Paste (the range was deleted, so Excel shows #REF!):
=SUM(#REF!,B2:B10)

Breakdown:
SUM() — Adds all numeric values in a range
  arg 1: #REF!,B2:B10)

(The '#' stops tokenising, so the rest is one raw chunk. Swap the
#REF! for a placeholder like Z1 to get =SUM(Z1,B2:B10) and a clean tree.)

No workbook needed — paste from an email

A colleague emails you a formula in plain text. Evaluate Formula needs it in a live cell; this tool just takes the text.

Paste:
=ROUND(SUMIF(A:A,">0",B:B)/COUNTIF(A:A,">0"),2)

Breakdown:
ROUND() — Rounds a number to a specified number of decimal places
  number: division (/)
    left:  SUMIF() — Adds values in a range that meet a condition
      range: cell range A:A
      criterion: text ">0"
      sum range: cell range B:B
    right: COUNTIF() — Counts cells that meet a condition
      range: cell range A:A
      criterion: text ">0"
  decimal places: number 2

Where Evaluate Formula wins — and this doesn't

If two branches of an IF look identical structurally but one produces the wrong number, only Evaluate Formula (or live calculation) can tell you which. The Explainer shows both branches but not their values.

Paste:
=IF(A1>0,B1*1.2,B1*0.8)

Breakdown:
IF() — Tests a condition; returns one value if true, another if false
  condition: greater-than test (>)
    left:  cell reference A1
    right: number 0
  value if true: multiplication (*)
    left:  cell reference B1
    right: number 1.2
  value if false: multiplication (*)
    left:  cell reference B1
    right: number 0.8

(To see WHICH branch fires for your A1, use Excel's
Evaluate Formula — this tool shows structure, not value.)

A deep nest, read in one pass

The Explainer's whole-tree view shines on deep nests where Evaluate Formula's step-by-step gets tedious.

Paste:
=IFERROR(INDEX(B:B,MATCH(D1,A:A,0)),0)

Breakdown:
IFERROR() — Returns a value if a formula produces an error; otherwise returns the formula result
  expression: INDEX() — Returns the value at a given position in a range
    range: cell range B:B
    row number: MATCH() — Returns the position of a value within a range
      lookup value: cell reference D1
      lookup range: cell range A:A
      match type: number 0
  fallback if error: number 0

This tool never shows the computed value of any sub-expression — that is exactly what Excel's Evaluate Formula is for. If your goal is to find which step produces a wrong number, use Evaluate Formula (or just calculate in Excel). Use this tool to understand the formula's meaning and structure, not its arithmetic.

The Explainer is gated to Pro and above. On Free it returns Formula Explainer requires Pro tier. with no partial output. There is no smaller free preview — the whole tool is behind the gate. Upgrade to Pro (or higher) to use it.

A formula whose VLOOKUP/MATCH would return #N/A for your data still explains perfectly — the formula text is normal, and the tool never runs it, so you see the full structure regardless. This is an advantage over Evaluate Formula, which stops at the failing step. Note the separate case below: a literal error token like #REF! written into the text is a parsing limit, not this case.

If Excel has replaced a deleted reference with a literal #REF! (or you paste text containing #N/A), the # is an unrecognised character: it and everything after it collapse into one raw argument, dropping later arguments from the tree. The outer function still shows. Replace the #REF! with a placeholder cell (e.g. Z1) before pasting to get a clean breakdown.

The Explainer is static analysis: it never evaluates the formula and never reads cell values, so it cannot tell you what =VLOOKUP(...) returns for your data — only what each part does and how the parts nest. To see a value, run the formula in Excel; to understand it, use this. For tracing which cells feed a result with real values, use the dependency map.

Any function that is not one of the 65 named ones — a valid-but-unlisted Excel function like SUMPRODUCT, OFFSET, or INDIRECT, a Google Sheets-only function like QUERY or ARRAYFORMULA, or a custom workbook UDF like MyMacro — renders as NAME() — Excel function (uppercased) with generic arg N labels. It is never mislabelled User-defined function and never throws; you still see the full nesting structure and every argument, just without a prose description of that one function.

The breakdown comes from a deterministic recursive-descent parser, not a language model, so an identical formula always produces an identical tree. There is no temperature, no sampling, and no chance of an AI confidently inventing a function or mis-describing an argument — the descriptions are fixed text keyed to each function name.

A reference like 'Sales 2026'!A1 uses an apostrophe, which the tokeniser does not recognise. From that apostrophe onward the rest of the formula is absorbed as one raw chunk: if the quoted ref is at the very start, the whole formula dumps as a single raw line; if it sits inside an argument, the surrounding functions parse but that argument swallows everything after the apostrophe — so any later arguments are dropped from the tree. Workaround: rename the sheet so it has no spaces (then Sales2026!A1 parses), or strip the '…'! qualifier before pasting if you only need the function structure.

A postfix percent such as 5% is read as the binary modulo operator, so you see modulo (%) with an empty right operand instead of 5 percent. Excel itself treats % as a postfix scale-by-1/100; the Explainer's grammar treats % as binary. The tree is still readable — just mentally translate that node back to a percentage.

If the formula box is empty or only whitespace, the tool returns No formula provided. rather than an empty tree. Paste the real formula text. A leading = is optional — it is added automatically if you leave it off.