SheetSense

Explain an Excel formula

Most confusing spreadsheet formulas are not hard, they are just nested. The Formula Translator reads a formula from the inside out and writes each step as a numbered sentence, so you can see what is being compared, what is being returned, and where it can fail.

Paste the whole formula including the equals sign, sheet names, and dollar signs. Those details change the meaning, and the explanation refers to them.

Worked example: a two-column lookup

Rates sheet: column A is Region, column B is Product, column C is Unit price. F2 and G2 hold the region and product to find.

Formula to explain
=INDEX($C$2:$C$500,MATCH(1,($A$2:$A$500=F2)*($B$2:$B$500=G2),0))

Read from the inside: each comparison returns a list of TRUE and FALSE values, and multiplying them gives 1 only on rows where region and product both match. MATCH finds the first 1, and INDEX returns the unit price from that row. The formula needs Excel 365 or Ctrl+Shift+Enter in older versions, and ARRAYFORMULA in Google Sheets.

How it works

  1. 01Paste the formula into the Formula Translator.
  2. 02Read the numbered explanation, one step per part of the formula.
  3. 03Check the listed edge cases, such as text stored as numbers or duplicate keys.
  4. 04Copy the Excel, Sheets, SQL, or pandas version if you need to move the logic elsewhere.

Common questions

Does it explain Excel and Google Sheets formulas?
Yes. Paste either. Formulas that use semicolons as separators, common in European Excel, can be pasted as they are.
What if my formula has an error?
The explanation describes what the formula does as written, so a wrong range or a missing argument shows up in the steps. Common errors such as #N/A and #VALUE! are covered in the formula library.
Is there a limit?
The free translator allows 5 formulas a day without an account. Pro removes the daily cap.

Try it on your own formula

The Formula Translator is free for 5 formulas a day, with no account.