Excel Formula Explainer

Paste an Excel or Google Sheets formula and get a plain-English, step-by-step breakdown of every function, reference and operator — including nested IFs, lookups and ranges.

How to use

1Paste a formula (with or without the leading =).
2Read the summary and the indented step-by-step breakdown.

How it's calculated

The formula is tokenized into functions, cell references, ranges, text, numbers and operators; nesting is shown by indentation. Descriptions cover about 110 common Excel/Sheets functions.

Frequently asked questions

What do the $ signs mean?

They make a reference absolute: $A$1 doesn't change when you copy the formula; A$1 locks only the row, $A1 only the column.

Does it calculate the result?

No — it explains what the formula does. Paste it into your spreadsheet to calculate.

Does it work for Google Sheets?

Yes — Sheets uses the same formula syntax for almost all common functions.