For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=TOOLS.A3

Formula explainer

Paste any formula and we'll break down the functions it uses in plain English — no sign-up, runs entirely in your browser.

Try one:

What it does

Paste a formula and it is broken into its nested parts, each one labelled with what that function does and which arguments it received. A formula five levels deep becomes a readable outline instead of one long line.

Why this is hard to do by eye

Excel's formula bar shows one line of text. A formula like=IFERROR(INDEX(B:B,MATCH(1,(C:C=F2)*(D:D=G2),0)),"") has four functions, three ranges, two comparisons, and a multiplication acting as AND logic — and the brackets that tell you which belongs to which are exactly what the eye slides over.

The usual alternative is selecting a fragment in the formula bar and pressing F9 to see what it evaluates to. That works, and it is worth knowing, but it is destructive if you press Enter instead of Escape, and it shows values rather than structure.

What to use it for

What to check afterwards

Understanding a formula is not the same as verifying it. The two things that most often turn out to be wrong are the ranges — a formula that stops at row 500 because that is where the data ended when it was written — and the edge cases: what happens on a blank, a zero, or a text value in a numeric column. Theformula audit checklistcovers both.

Privacy

The parsing runs in your browser. Formulas you paste are not uploaded or logged. If you want to build a formula rather than read one, theformula builder works the other way round, and the function reference has the full argument list for each function.