Guide
Understanding and translating Excel formulas, one function at a time
Formulas are the hidden logic of a workbook. When you inherit a spreadsheet, a long formula like =IFERROR(VLOOKUP(A2,Prices!$A:$C,3,FALSE),“Not found”) can be hard to read, and a formula copied from a German or French tutorial will not even run in an English Excel. This tool breaks a formula down, explains every part, warns about common traps and translates it between Excel languages.
Paste and choose the language
Paste a formula, with or without the leading equals sign, and pick the language it is written in. English Excel separates arguments with commas; German, French, Spanish, Italian, Portuguese and Dutch Excel use semicolons, because the comma is their decimal separator. If you use the wrong separator for the chosen language, the tool tells you so.
The tree
The formula is shown as a tree: each function with a plain-English description, and below it each argument labelled with its role, such as lookup_value, table_array or value_if_false. References are marked as single cells, ranges or table columns; text, numbers and logical values are labelled too. Operators are explained in words, so B2>=90 reads as “is at least”. Arguments left empty, as in IF(A1,,B1), are shown with a note that the default is used.
Formatted view
The formatted view rewrites long formulas with one argument per line, indented by nesting. It is the easiest way to see where each parenthesis closes, and you can copy it into documentation or a code review.
Common traps
Below the explanation, warnings point out frequent mistakes. A VLOOKUP or HLOOKUP without FALSE does an approximate match. MATCH without a match type assumes sorted data. NOW, TODAY, RAND, OFFSET and INDIRECT are volatile and recalculate on every change, which slows large workbooks. Three or more nested IFs are a sign that IFS or a lookup table would be clearer, and references to entire columns are convenient but slow in big lookups.
Translating
Choose a target language to translate function names, TRUE and FALSE, argument separators and decimal commas. =SUMIF(A:A,“x”,B:B)*0.5 in English becomes =SUMMEWENN(A:A;“x”;B:B)*0,5 in German. Sheet names and text in quotes stay as they are. Functions without a known translation are listed rather than guessed, and array constants are flagged because their separators differ between languages.
What it does not do
The tool explains and translates; it does not calculate results, which depend on the values in your workbook. Paste the formula back into Excel to see its value.
Errors in the formula
Missing parentheses, unclosed quotes and misplaced separators are reported with the position where reading stopped, which often points straight at the typo.
Examples to start from
The example menu loads typical formulas: a lookup with a fallback, nested IF grades, a SUMIFS with two conditions and a German formula. Load one, change it, and watch the tree and the explanations update as you type.
Learning functions
Teachers and learners can use the tree to see how a formula is evaluated from the inside out: the innermost functions produce values that the outer ones use. Rewriting a nested formula step by step, and checking each step here, is a reliable way to understand it.
Related tools
Try formulas live in the Online Spreadsheet. For patterns inside SEARCH or REGEX functions, the Regex Tester helps. Summarize data without formulas using the CSV Pivot Table.
Checked against the current version of the Excel Formula Explainer on .