Excel formula explainer

New
ResultCalculating…

Inside the formula

  • ↗

Example data

How the formula explainer works

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

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

The top row above is the whole formula. Open any argument that holds a calculation of its own to see the values it used. Excel works out those inner parts first, because the function around them needs their results. Edit a cell in the grid to see every value update.

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