SheetSense

How to read an Excel formula someone else wrote

You have inherited a spreadsheet. One cell holds a formula three lines long, and the person who wrote it has left the company.

6 minute read. Published 15 November 2026.

Read from the inside out

Excel works out the innermost brackets first and passes each result outward. Reading in the same order turns one frightening formula into a few small ones.

Find the deepest pair of brackets. Work out what that piece returns. Replace it in your head with its result, then move one level out.

=IFERROR(INDEX(C2:C100,MATCH(F2,A2:A100,0)),"Not found")
  1. MATCH(F2,A2:A100,0)Find the row where column A equals F2. Returns a position, such as 14.
  2. INDEX(C2:C100, 14)Return the 14th value from column C.
  3. IFERROR( ... ,"Not found")If either step failed, show Not found.
The same formula, read one layer at a time.

Test the pieces

  1. Click the cell and look at the formula bar.
  2. Select one piece with the mouse, for example MATCH(F2,A2:A100,0).
  3. Press F9. Excel replaces the selected piece with its current value.
  4. Press Esc when you have finished looking. Pressing Enter would save the value in place of the formula.

Excel for Windows also has Evaluate Formula on the Formulas tab, which steps through the calculation one piece at a time.

What the usual errors mean

ErrorWhat it usually meansFirst thing to check
#N/AA lookup found no matchTrailing spaces, or text on one side and numbers on the other
#VALUE!Text where a number was expectedA number stored as text
#REF!The formula points at a cell that was deletedUndo, or rebuild the reference
#DIV/0!Division by zero or by an empty cellThe denominator cell
The four errors you will meet most often.

Get a plain-English explanation

When the formula is long, pasting it into SheetSense gives you the same inside-out walk in ordinary sentences, written for the formula you pasted. It also shows the equivalent in Google Sheets, SQL and pandas, which helps if the sheet is being moved somewhere else.

Check the explanation against the F9 test on one or two pieces. An explanation is a reading of the formula. The F9 result is what your data does.

You can try the translator without an account.

Leave it better than you found it

  • Add a note to the cell saying what the formula is for.
  • Name the ranges, so A2:A100 becomes CustomerID.
  • If it is nested more than three levels deep, split it across helper columns.

Paste the formula you are stuck on. Explain a formula