Understand Complex Excel Formulas with a Plain-English Breakdown

A nested IF over a VLOOKUP comparison

The classic 'looks scary, isn't' formula. The breakdown puts IF at the top, then its three labelled arguments: a greater-than test whose left side is the VLOOKUP, and the two text outcomes.

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

Breakdown:
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"

Operator precedence laid out as a tree

Plain arithmetic still benefits — the tree shows exactly how Excel groups * and / above + and -, which is the source of countless 'why is this number wrong' bugs.

Paste:
=A1+B1*2-C1/4

Breakdown:
subtraction (-)
  left:  addition (+)
    left:  cell reference A1
    right: multiplication (*)
      left:  cell reference B1
      right: number 2
  right: division (/)
    left:  cell reference C1
    right: number 4

Concatenation chain

The & operator left-associates, so a three-part join nests as two concatenations. The tree makes the order obvious.

Paste:
=A1&" "&B1

Breakdown:
string concatenation (&)
  left:  string concatenation (&)
    left:  cell reference A1
    right: text " "
  right: cell reference B1

A function the list doesn't describe

SUMPRODUCT is a real, valid Excel function but it is not one of the 65 with a description, so it renders as a generic Excel function. You still get the full structure — the array math inside is parsed normally.

Paste:
=SUMPRODUCT((A:A="x")*B:B)

Breakdown:
SUMPRODUCT() — Excel function
  arg 1: multiplication (*)
    left:  equality test (=)
      left:  cell range A:A
      right: text "x"
    right: cell range B:B

Pasting without the leading equals sign

You can omit the =; the tool prepends it before parsing. The Formula: echo line shows you exactly what was parsed.

Paste:
ROUND(AVERAGE(A1:A10),2)

Report:
Formula: =ROUND(AVERAGE(A1:A10),2)
────────────────────────────────────────────────────────────
Step-by-step breakdown:

ROUND() — Rounds a number to a specified number of decimal places
  number: AVERAGE() — Calculates the arithmetic mean of a range
    arg 1: cell range A1:A10
  decimal places: number 2

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.

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.

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 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.

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.

Excel table syntax is not fully tokenised. Table1[Amount] keeps Table1 as a plain cell reference but drops the [Amount] column part. A reference that starts with a bracket, like [@Price], starts with an unrecognised character, so it and the rest of the formula dump as one raw line. Replace structured references with the equivalent A1 ranges before pasting if you need them in the tree.

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.

A formula missing its closing parenthesis, e.g. =IF(A1>0, does not crash the tool — it parses and explains the part it understood and stops. Use this to your advantage: paste a half-finished formula to sanity-check the structure so far, then complete it in Excel.