Understand any Excel formula
Paste a formula and see what each part does, or let a tool write the formula for your own cells.
2 functions, 2 levels deep
This formula uses 2 functions (IFERROR, VLOOKUP), nested 2 levels deep, and reads A2, Prices!$A$2:$C$50.
VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE)VLOOKUP finds a value in the first column of a table and returns a value from the same row.
Expects: value, table, column number, match type (FALSE means exact)
- Argument 1: cell A2
- Argument 2: the range $A$2:$C$50 on sheet Prices (the $ keeps it fixed when copied)
- Argument 3: the number 3
- Argument 4: FALSE
IFERROR(VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE),"Not found")IFERROR returns a fallback when the first argument gives any error.
Expects: value, fallback
- Argument 1: the result of VLOOKUP
- Argument 2: the text "Not found"
Read from the innermost function outward: Excel works out the inner results first.
- 7 free formula tools
- 137 functions the explainer knows
- 0 uploads: tools run in your browser
Browse by topic
Guides grouped the way you search for them.
Formulas & functions
How each function works, with examples you can paste.
3,236 guidesOpen section →How-to basics
Sorting, filtering, formatting, printing and shortcuts.
8,727 guidesOpen section →Charts & pivot tables
Build, format and fix charts and pivot tables.
2,008 guidesOpen section →Errors & fixes
What each error means and the change that clears it.
1,297 guidesOpen section →VBA & macros
Automate repeat work with short, commented macros.
1,989 guidesOpen section →All formula tools
Lookups, dates, loans, percentages, serials and columns.
7 toolsSee all tools →New guides
The latest additions across every section.
- What Is an Enum in a Database? Definition & Use
- Shortcuts in a Computer? Explained Simply
- Battery Life Calculations: How to Estimate Runtime
- All Mac Shortcuts: The Complete List
- Update Method in Dictionary: Python & More
- Dictionary Add or Update in C#: Best Way
- COUNTIF Within a Range: How to Count Cells That Meet a Condition
- SUBTOTAL with SUMIF: Combine & Use in Excel
How the tools work
Short version: your numbers stay on your device, and every formula we print is one you can paste into Excel.
Runs in your browser
Calculations happen on this page. Nothing you type is sent to us or stored.
Checked against worked examples
Each calculation is compared with known answers, and the generated formulas are run in the open-source HyperFormula engine. Function behaviour follows Microsoft's function reference. Method & sources
Corrections are public
Found a mistake? Tell us, and fixes are listed on the corrections page.