Understand any Excel formula, one layer at a time

Paste any Excel formula and see what each part works out to, one step at a time, on a live spreadsheet you can edit.

How Excel works this out

Inner to outer

Add up numbers in a range with Excel's SUM function.

Runs this calculation on the values.

Round a number to a set number of decimal places with the ROUND function.

Formula sample data

How the formula explainer works

Start with the example or enter your own formula. The explainer finds each complete function call and calculates it against the editable spreadsheet.

The rows above are ordered from the innermost calculation to the final result. Excel has to finish an inner function before the function around it can use that value. Edit a cell in the grid to see that dependency chain update for real.

Try your own formula and data

The sample spreadsheet is fully editable. Change the formula or any cell it references. The intermediate values recalculate in your browser.

More formula walkthroughs

INDEX MATCH explained step by step

=INDEX(C2:C8,MATCH("Alice",A2:A8,0))

See how MATCH finds Alice's row and INDEX returns her salary, with both results calculated live.

See the steps

INDEX MATCH with multiple criteria

=INDEX(C2:C8,MATCH(1,(A2:A8="Widget")*(B2:B8="West"),0))

See product and region tests become Boolean arrays, combine into one mask, and resolve to a price.

See the steps

SUMPRODUCT with conditions explained

=SUMPRODUCT((A2:A8="West")*C2:C8)

Watch a West-region Boolean mask multiply sales row by row before SUMPRODUCT adds the surviving values.

See the steps

Why VLOOKUP returns #N/A

=VLOOKUP(A2,D2:E7,2,FALSE)

See why an exact-match VLOOKUP returns #N/A when the requested product ID is missing.

See the steps

Nested IF tiers explained

=IF(B2>=90,"Excellent",IF(B2>=80,"Good",IF(B2>=70,"Fine","Needs work")))

Follow a score through Excellent, Good, Fine, and Needs work tiers one IF at a time.

See the steps

IF with AND explained

=IF(AND(A2>100,B2="Yes"),"Approve","Reject")

See two approval conditions resolve to TRUE or FALSE before IF chooses Approve or Reject.

See the steps

SUMIFS with multiple criteria

=SUMIFS(C2:C8,A2:A8,"West",B2:B8,">"&DATE(2026,1,1))

See which West-region sales occurred after January 1, 2026 and how their values form the total.

See the steps

Extract text between characters with MID and FIND

=MID(A2,FIND("-",A2)+1,FIND("-",A2,FIND("-",A2)+1)-FIND("-",A2)-1)

Watch FIND locate both hyphens, calculate the slice boundaries, and let MID extract a SKU code.

See the steps

IFERROR with VLOOKUP explained

=IFERROR(VLOOKUP(A2,D2:E7,2,FALSE),"Not found")

See VLOOKUP return #N/A and IFERROR replace it with a friendly Not found message.

See the steps

FILTER with multiple criteria

=FILTER(A2:C8,(B2:B8="West")*(C2:C8>100))

See region and price conditions combine into a Boolean mask and return every matching product row.

See the steps

Practice with an exercise

Here is an exercise to get you started. Type the formula into a real spreadsheet and we will check your answer as you go.

Round prices to the nearest cent with ROUND

Beginner

Use ROUND to clean up invoice totals so each price shows exactly two decimal places.

Open exercise