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.
657 guidesOpen section →How-to basics
Sorting, filtering, formatting, printing and shortcuts.
4,269 guidesOpen section →Charts & pivot tables
Build, format and fix charts and pivot tables.
866 guidesOpen section →Errors & fixes
What each error means and the change that clears it.
781 guidesOpen section →VBA & macros
Automate repeat work with short, commented macros.
955 guidesOpen section →All formula tools
Lookups, dates, loans, percentages, serials and columns.
7 toolsSee all tools →New guides
The latest additions across every section.
- Excel Pivot Table: Add a Calculated Column or Field
- Excel Pivot Table Average: Add a Column and Set It Up
- Excel VBA Range Hyperlinks: Insert, Edit, and Remove
- Print a VBA Dictionary: Immediate Window and Worksheet
- PowerPoint VBA: How to Loop Through Slides
- PowerPoint VBA InputBox Location and How to Position It
- Excel Dashboard Inspo: Ideas, Layouts, and Design Tips
- Pivot Table Refresh From VBA: Code and Common Fixes
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.