Free ebook
Free ebook: Excel Formulas Cheat Sheet
A printable cheat sheet with the formulas you actually use — syntax, gotchas, and worked examples. Read online or grab the PDF.
Get the ebookCourse path
Turn formulas into a learning path
Our Excel Formulas & Functions course path strings public YouTube lessons into a structured route — preview, learn, repeat.
View course pathFormula explainer
Paste any formula and we'll break down the functions it uses in plain English — no sign-up, runs entirely in your browser.
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
- Inherited workbooks. Understanding somebody else's model is slow work, and the formulas are where the assumptions hide.
- Finding the bracket you missed. An unbalanced formula shows up immediately once it is laid out by level.
- Checking argument order.
SUMIFandSUMIFStake their ranges in a different order, which is one of the most common silent errors in Excel.
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.



