Excel Formula Explainer

Paste an Excel formula to see what each part does, find the mistake (#N/A, #VALUE!, parentheses, VLOOKUP without FALSE) and translate it to Spanish or English

Paste your formula

Examples:

Check

Tip IFERROR hides every error, including those from a mistyped range. If you only expect "not found", IFNA is safer.

What it does, part by part

=IFERROR(
  VLOOKUP(A2,Customers!A:D,4,FALSE),
  "No record"
)

IFERROR(VLOOKUP(A2,Customers!A:D,4,FALSE),"No record")
IFERROR · Returns a formula’s result or, if it returns any error, the value you choose.
- valueVLOOKUP(A2,Customers!A:D,4,FALSE)
  VLOOKUP · Looks up a value in a table’s first column and returns data from another column on that row.
  - lookup_valueA2
    Cell A2 · relative: it moves when the formula is copied
  - table_arrayCustomers!A:D
    On sheet Customers: Whole columns · The whole column, however many rows it has.
  - col_index_num4
    Number
  - range_lookupFALSE
    Logical value
- value_if_error"No record"
  Text

The same formula in another Excel

English=IFERROR(VLOOKUP(A2,Customers!A:D,4,FALSE),"No record")
Spanish with ,=SI.ERROR(BUSCARV(A2,Customers!A:D,4,FALSO),"No record")
Spanish with ;=SI.ERROR(BUSCARV(A2;Customers!A:D;4;FALSO);"No record")

Which error do you see in the cell?

Practice these functions: IFERROR, VLOOKUP · All exercises

Share this tool

If it helped, send it to someone who needs it too.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Free Online Excel Formula Explainer

When you inherit a workbook or copy a formula from a forum, figuring out what it does can take longer than rewriting it. Paste it here and see it taken apart: every function with what it does, every argument with its name, and every cell or range with what happens when you copy it. Common mistakes are checked at the same time, and if the cell shows #N/A, #VALUE! or another error, you get where it usually comes from and how to fix it. You do not need to upload your file: everything runs in your browser.

Why use Excel Formula Explainer

Explains every function and argument with its Excel name
Flags unclosed parentheses or quotes and misspelled functions, with a suggestion
Spots VLOOKUP and MATCH without exact match, ranges of different sizes and ">=F2" inside quotes
Suggests anchoring lookup ranges with $ before copying
Causes and fixes for #N/A, #VALUE!, #NAME?, #REF! and more
Breaks long formulas into one line per argument
Translates the formula to Spanish or English with the right separator
Works with 160+ functions, including XLOOKUP, FILTER, LET and GROUPBY

How to use it in 3 steps

1
Copy the formula
In Excel select the cell, copy the text from the formula bar and paste it in the box.
2
Pick your Excel
Say whether your Excel is in English or in Spanish with commas or semicolons.
3
Read the check
Errors and warnings come first; below is the formula taken apart piece by piece.
4
If you see an error, pick it
Press the error the cell shows (#N/A, #VALUE!…) to see its causes and how to fix it.

Questions about Excel Formula Explainer

Why does my VLOOKUP return the wrong value without an error?

Almost always the fourth argument is missing. Without FALSE (or 0), VLOOKUP does an approximate match: if it cannot find the exact value it returns the closest previous row instead of #N/A. The explainer flags it as a warning.

What does the $ sign mean in a formula?

It anchors the reference when copying. $A$2 never changes, A$2 keeps the row and $A2 keeps the column. In the breakdown of your formula you will see, for each cell, what happens when you copy it.

Do I need to upload my Excel file?

No. You only paste the formula text and everything is analyzed in your browser; nothing is sent to a server.

Can it tell me the formula's result?

Without your sheet's data the result cannot be calculated, but it can explain what the formula does and find common typing and logic mistakes. To practice with sample data, use the Excel exercises.

Is Excel Formula Explainer free?

Yes, Excel Formula Explainer from WebHerramientas is 100% free. No registration or subscription required. You can use it as many times as you need at no cost.

Is it safe to use Excel Formula Explainer online?

Yes, all information is processed directly in your browser. We do not store or send your data to any external server.

Does Excel Formula Explainer work on mobile?

Yes, the tool is fully responsive and works on any device: phone, tablet or computer with a modern browser.