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.
2,224 guidesOpen section →How-to basics
Sorting, filtering, formatting, printing and shortcuts.
6,782 guidesOpen section →Charts & pivot tables
Build, format and fix charts and pivot tables.
1,649 guidesOpen section →Errors & fixes
What each error means and the change that clears it.
1,156 guidesOpen section →VBA & macros
Automate repeat work with short, commented macros.
1,447 guidesOpen section →All formula tools
Lookups, dates, loans, percentages, serials and columns.
7 toolsSee all tools →New guides
The latest additions across every section.
- Stacked Column Chart in Excel: Create and Read It
- Stacked Bar Pareto Chart in Excel: Build and Format
- Stacked Bar Chart in Excel: Build It from a Table
- Stacked Bar Chart Not Working in Excel? Fix It
- Stacked Bar Chart in Excel with 4 Variables: How-To
- Stacked Bar Chart in Excel With Two Variables
- Stacked Bar Chart Excel Template: Build and Customize One
- Stacked Bar Chart Excel Gantt: Build a Task Timeline
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.