Skip to content
en
Practical GuidesAll tools

Categories

Developer ToolsEncoding & DecodingJSON & DataExcel ToolsHash & ChecksumText ToolsDate & TimeNetwork ToolsFile ToolsMarkdown & Diagrams

Excel Formula Explainer

Paste a formula you inherited or copied from the web and see what every function, reference and operator does, in nested order.

Processed locally in your browser

Paste a formula with or without the leading "=". English, French and Spanish function names and both "," and ";" separators are understood. The formula is only read, never calculated.0 chars · 0 lines
The result will appear here.

What is Excel Formula Explainer?

Long formulas such as =IFERROR(VLOOKUP(A2,Sheet2!A:C,3,FALSE),"Not found") are hard to read because functions sit inside functions. This tool reads the formula with a real parser, colours each part, and writes an indented outline that explains each function with the arguments you actually used.

Below the outline, a table lists every function, cell, range, name and constant that was detected, and a warnings list points out typical problems: unbalanced parentheses or quotes with their position, wrong argument counts, VLOOKUP without an exact-match flag, volatile TODAY or NOW, IFERROR hiding real errors, whole-column references, numbers stored as text and deeply nested IFs. English, French and Spanish function names are recognised, and both "," and ";" separators work. The formula is only read as text and never calculated.

How does it work?

  1. Paste the formula, with or without the leading "=", in the box.
  2. Read the highlighted formula and the indented outline: each function is explained first, then its arguments one level deeper.
  3. Check the Detected table to see every function, range, cell and constant in one list.
  4. Open the warnings to fix syntax problems or risky patterns, then copy the corrected formula back into Excel.

Common use cases

  • Understanding a formula in a workbook you inherited before you change anything in it.
  • Learning how nested functions such as IF inside IFERROR or INDEX with MATCH fit together.
  • Checking a formula copied from a forum for missing parentheses, wrong argument counts or unsafe defaults.
  • Translating a French or Spanish formula (RECHERCHEV, SOMME.SI.ENS, BUSCARV) into its English meaning for a colleague.

Examples

Try this input in the tool above:

Input
=IFERROR(VLOOKUP(A2,Sheet2!A:C,3,FALSE),"Not found")
Output
IFERROR — Evaluates VLOOKUP(A2,Sheet2!A:C,3,FALSE); if that produces an error (#N/A, #DIV/0!, #VALUE!…) it returns "Not found" instead, otherwise the normal result.
  value: VLOOKUP — Looks for A2 in the first column of Sheet2!A:C and returns the value from column 3 of the matching row (exact match).
    lookup_value: cell A2
    table_array: whole columns A to C on sheet "Sheet2"
    col_index_num: number 3
    range_lookup: FALSE (logical value)
  value_if_error: text "Not found"

Privacy

Excel Formula Explainer runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.

Limitations

The tool explains structure and meaning but does not calculate results or look at your data, so it cannot tell whether a range is correct. Functions outside its dictionary are flagged as not explained, and dynamic-array behaviour, LET and LAMBDA are only partly covered.

Related guides

  • Compare Excel Files with Reordered Rows

    A useful spreadsheet diff depends on matching the right records. Compare by cell position when row order is stable; choose a key column when records have moved.

Frequently asked questions

Does it run or calculate my formula?

No. The text is tokenized and parsed in your browser and nothing is evaluated, so no cell values are needed and nothing leaves your device. That also means it cannot show the result of the formula.

Which functions and languages are supported?

IF, IFS, AND, OR, NOT, SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS, AVERAGE, MIN, MAX, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, IFERROR, IFNA, text and date functions and a few more. French and Spanish names such as SI, RECHERCHEV or BUSCARV are mapped to the English function, and unknown names are reported.

Why does it warn about VLOOKUP without FALSE?

When the last argument is missing or TRUE, VLOOKUP does an approximate match and expects the first column sorted ascending. On unsorted data it can return a wrong row without any error, so the tool suggests FALSE or 0 for an exact match.

Related tools

More tools in Excel Tools →