An Excel formula explainer turns a long, confusing formula into plain English. Paste any formula from a spreadsheet, and this Excel formula explainer takes it apart, working from the innermost function outwards. For each function, you see what it does and what each of its arguments is for. Cell references and operators are explained as well. It is a quick way of understanding a workbook that somebody else built, or of checking your own work before you rely on it.
How to use the Excel formula explainer
- Copy the formula from the formula bar in Excel or Google Sheets.
- Paste it into the box. It doesn't matter whether you include the equals sign.
- Press Explain formula.
- Read the steps in order. Excel works out the inner functions first, and so the explanation begins there.
The parts of an Excel formula
As Microsoft explains, a formula in Excel always begins with an equals sign. After that, it can contain any of the following parts:
- Functions, such as SUM or VLOOKUP, are built-in calculations.
- Arguments are the values a function works on, placed inside brackets and separated by commas.
- References, such as A2 or B2:B10, point to cells on the sheet.
- Operators, such as +, * and >, carry out arithmetic or comparisons.
- Constants are fixed numbers or text typed straight into the formula.
Excel formula explainer example
Take this formula: =IF(SUM(B2:B10)>100,"Over","OK"). Step one is SUM, which adds up the values in cells B2 to B10. Step two is IF, which checks whether that total is more than 100. If it is, the formula shows the word Over. If not, it shows OK. The explainer lists each of these parts separately, and names the condition, the result if true and the result if false.
Why formulas are explained from the inside out
Nested formulas are hard to read because one function sits inside another. Excel has to work out the inner calculation before it can use the result in the outer one. Reading in the same order makes the logic much easier to follow. If you find a formula with several layers of IF, for example, look at how each step passes its answer on to the next. Long formulas almost always turn out to be a series of small and simple steps.
Relative and absolute references
A reference such as A2 is relative, which means that it shifts when you copy the formula to another cell. Adding dollar signs fixes it in place. $A$2 always points to the same cell, $A2 fixes only the column, and A$2 fixes only the row. Understanding these is often the key to explaining why a copied formula has gone wrong. The explainer flags each reference in your formula and says whether any part of it is fixed.
Common functions you may run into
- SUMIFS and COUNTIFS add or count the rows that meet your conditions.
- VLOOKUP and XLOOKUP find a value in a table and bring back related information.
- INDEX with MATCH finds a position in a list, then returns the value at that position.
- IFERROR shows a backup value in place of an error message.
- TEXT formats a number or date as text.
What this tool doesn't do
The explainer reads the structure of a formula. It doesn't have access to your spreadsheet, so it can't calculate the result or tell you whether the formula is right for your data. A formula can be perfectly valid and still give the wrong answer if it refers to the wrong column. If a function isn't in our list, its arguments are still displayed, and you can look it up in Microsoft's function reference.
Tips for debugging a formula
- Check that brackets match. The explainer will tell you if they don't.
- Test the inner parts first. Copy a nested function into an empty cell and see what it returns.
- Use Evaluate Formula on Excel's Formulas tab to step through a real calculation.
- Look at the data types. Numbers stored as text are a common cause of wrong results.
Reading a formula someone else wrote
Inherited workbooks can be intimidating, particularly when a single cell holds a long chain of nested functions. Start by pasting the formula here and reading the first step, then look at the cells that it refers to. Work out what each column holds before you try to follow the logic. Once you can describe the formula in one plain sentence, write that sentence in a cell comment or a notes sheet, so that the next person doesn't have to work it all out again. If a formula is very long, consider splitting it across helper columns, which makes it much easier to check later.
Is my formula private?
Yes. The explanation is produced in your browser, and your formula is never uploaded. If it contains confidential names or figures, they stay on your device.
Related spreadsheet tools
Create new formulas with the Excel formula generator, combine workbooks with Excel merge files, and turn a sheet into a document with Excel to PDF.
What next
Use this often? Add Excel Formul to your Home screen.
Frequently asked questions
How does the Excel formula explainer work?
It reads your formula, finds each function from the innermost outwards, and explains what it does and what each argument means.
Does it work with Google Sheets formulas?
Yes. Most common functions share the same names and arguments in Google Sheets.
Does it calculate the result?
No. It can't see your spreadsheet, so it explains the structure rather than the result.
What does the $ sign mean in a formula?
It fixes the column or row, so that part of the reference doesn't change when the formula is copied.
Is my formula uploaded?
No. The explanation is created in your browser.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.