Excel #NAME? error: unknown function or name

Usually a typo or a formula in the wrong language. Here's how to fix #NAME? quickly.

The message you see
#NAME?
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Open free SheetFix tools →

Why this happens

How to fix it

  1. 1Retype the function and pick it from the autocomplete list.
  2. 2Translate the function name to your Excel language.
  3. 3Put text values in quotes: =IF(A1="yes",1,0).
  4. 4Use an older alternative (INDEX/MATCH) if the function is missing.

Related guides

Still stuck? Ask SheetFix Support