Bidirectional engine · 14 real cases · Nov 2026

Any Excel formula,
in plain English.

Paste a formula and get an instant plain-language explanation, a step-by-step argument map and equivalent ways to write it — or describe what you want and let the builder write the formula for you.

Definition · Formula to natural language

Formula to natural language is the practice of translating a spreadsheet formula into plain English that says what it does, step by step, without jargon. For example, =SUMIFS(D2:D100,A2:A100,"West") becomes "add the values in column D where the region in column A is West." This matters because Excel and Google Sheets express logic in a compact symbolic syntax that most people cannot read at a glance. A good translation names the function, identifies each argument or range, explains the conditions, and states the result in one sentence. It also surfaces equivalents — SUMIFS can be rewritten with SUMPRODUCT, VLOOKUP with INDEX-MATCH or XLOOKUP — so you can pick the clearest form. Our bidirectional engine explains any common formula and builds one from your intent. Paste a formula above to see its plain-English reading, argument map and data-flow diagram instantly.

fx
ƒx
=SUMIFS(D2:D100, A2:A100, "West", C2:C100, ">=1000")
14
Real translation cases
2
Directions: explain & build
9
Formula patterns parsed
0
External dependencies
// 01 — Forward direction

Formula → plain English

Type or paste any common Excel formula. A lightweight rule-based parser — running entirely in your browser — reads the function, maps every argument to a human phrase, and offers equivalent forms. The same formula always gets the same explanation.

Your formula

Leading "=" optional. Updates as you type.

Patterns this engine understands
ΣSUM, SUMIF, SUMIFS, AVERAGEIFS
VVLOOKUP, HLOOKUP, XLOOKUP, IFERROR
IINDEX + MATCH, COUNTIF(S), nested IF
$Ranges, absolute references, & concatenation
ƒx
Enter a formula to see its plain-English explanation.
DATA FLOW Input → processing → output
① Input data
Ranges & criteria
→
② Function processing
Evaluates row by row
→
③ Output
One result
// 02 — Reverse direction

Intent → formula

Don't know which function to use? Describe what you want to happen. The builder shows the best formulas for the job, each with a ready-to-copy template and honest pros and cons.

What do you want to do?

// 03 — The moat

Formula → words matrix

A structured, citable reference of 14 real formulas and their plain-English readings. Filter by category, search any term, copy a formula, or send it straight to the Explainer. This dataset is what people and AI answer engines quote.

Excel formulaCategoryPlain-English meaningAction
// 04 — FAQ

Common questions