Excel #NAME? Error: What It Means and How to Fix It

The Excel #NAME? error means Excel cannot recognize something written in a formula, such as a function name, a text value, or a named range. Check the formula for misspellings and missing quotation marks first; then confirm that any name it uses is actually defined in the workbook.

What the #NAME? error means

Excel formulas combine functions, cell references, names, operators, and sometimes text. When Excel encounters a word or reference it cannot interpret as one of those valid items, it may return #NAME? instead of a calculated result. The question mark is part of the displayed error name.

This is different from Excel failing to calculate a valid formula. For example, dividing a number by zero normally produces #DIV/0!, while referring to a cell that no longer exists may produce #REF!. With #NAME?, the issue is usually that Excel does not understand a piece of the formula as written.

The error can appear directly in a cell, or be passed along by another formula that uses the affected cell. It does not necessarily mean the workbook is damaged. Often, correcting one word, adding quotation marks, or defining a missing name is enough to resolve it.

Common causes of #NAME?

Several distinct mistakes can lead to the same error. Inspect the formula bar and look for the specific word or expression Excel cannot identify. Common causes include:

A misspelled function: Excel does not recognize a function name typed incorrectly. A missing letter in a familiar function can be enough.
Text without quotation marks: Formula text values need straight double quotation marks. Without them, Excel may treat a word as a defined name.
An undefined name: A formula may use a label such as Sales as a named range even though that name was never created, or has been deleted.
A misspelled named range: Names are not the same as ordinary cell labels. A small spelling difference can make Excel treat the name as unknown.
A missing colon in a range: A range written as A1A10 is not a valid reference to cells A1 through A10. The intended range notation uses a colon.
An unsupported function: A workbook may contain a function that the installed Excel version does not support. This is especially relevant when a file moves between newer and older releases.
Incorrectly typed unquoted sheet or name text: Sheet references with spaces need the appropriate apostrophes around the sheet name. A malformed reference may be interpreted incorrectly.

Not every formula problem produces #NAME?. A broken cell reference, for instance, more commonly produces #REF!. The exact result depends on what Excel can and cannot parse, so use the displayed error as a clue rather than assuming every bad formula has the same cause.

How to find the problem in a formula

Start by selecting the cell with the error and reading the formula bar. Look for words that are not cell addresses, operators, or recognizable functions. If the formula is long, inspect it in sections, beginning with any recently edited part. Excel may also display an error indicator next to the cell; select it to see available checking options, though the suggestions are not a substitute for checking the formula itself.

Check function spelling. Compare the function name with Excel’s spelling, including any required letters. Use the function autocomplete list while typing when available.
Check text constants. Put literal text inside straight double quotation marks. Curly quotation marks copied from a word processor are not a safe substitute in formulas.
Check every name. Compare names in the formula with their definitions in Formulas > Defined Names > Name Manager. Check spelling and scope.
Check punctuation. Confirm that parentheses are paired and that range references contain the intended colon. A missing or misplaced character can change how Excel reads the formula.
Consider the recipient’s Excel version. If the file came from someone using a newer release, identify whether the formula includes functions unavailable in the recipient’s version.

In Microsoft 365 for Windows, selecting a cell and pressing F2 lets you edit its formula in place. On a Mac, the equivalent may be Control+U, depending on the keyboard and Excel settings; pressing the cell’s formula bar is another option. Avoid replacing a formula just to remove the visible error until you know what result it should produce.

Fixing a misspelled function or unquoted text

A function-name typo is one of the quickest fixes. For example, with sales figures in B2:B6, the formula =SUMM(B2:B6) returns #NAME? because SUMM is not the Excel function name. Correcting it to =SUM(B2:B6) calculates the total of those five cells. If the values are 10, 20, 5, 15, and 10, the result is 60.

Text in a condition also needs correct syntax. With payment status in A2, the formula =IF(A2=Paid,1,0) treats Paid as a name rather than as literal text if no such name exists. The corrected formula is =IF(A2="Paid",1,0). It returns 1 when A2 contains the text Paid and 0 otherwise. This example assumes the status is in A2 and the formula is entered in another cell.

Use straight quotation marks around text values, and do not add quotation marks around function names or cell references. For example, putting quotes around A2 would turn a cell reference into text rather than make Excel read the value in A2. Formula punctuation matters: quotation marks, commas, parentheses, and operators each have a specific role.

Fixing a missing or incorrect defined name

A defined name is a readable label that refers to a cell, range, constant, or formula. For instance, a workbook might define the name TaxRate to refer to cell B1. A formula using TaxRate can then be easier to understand than one using a bare cell address. But if the name is absent, misspelled, or unavailable at the formula’s scope, Excel may return #NAME?.

In Excel for Microsoft 365 on Windows, open Formulas > Defined Names > Name Manager to review names and their references. Check whether the name exists, whether its spelling matches the formula, and whether it is scoped to the workbook or only to a particular worksheet. A worksheet-scoped name is not necessarily available to formulas on other sheets in the same way as a workbook-scoped name.

If the name is intended but missing, create it using Formulas > Defined Names > Define Name, then provide the intended name and cell or range reference. Do not create a name just to silence an error: verify what cells it should refer to first. Also check that the name does not look like a cell address and does not contain spaces, since Excel’s naming rules restrict those forms.

Alternatively, if the formula was meant to refer directly to cells, replace the unknown name with the correct reference. This is often appropriate when a workbook has been reorganized and a named range was removed. Before changing it, check other formulas and workbook documentation so the replacement preserves the original calculation.

When Excel does not support the function

Excel’s available functions vary by version. Functions such as XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365. Functions including TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, and LAMBDA require Microsoft 365 or Excel 2024. A workbook opened in an older version may not calculate a newer function normally.

When a formula works on one computer but not another, compare the Excel versions and update the older installation if possible. Some unsupported formulas may display a prefix such as _xlfn. or produce a compatibility-related error; the exact display can depend on the version and the function. Do not assume every #NAME? is a version issue: first check spelling, text quotes, and defined names.

Excel for the web and Excel for Mac can differ from Windows in available features or interface details, and support changes over time. If a workbook is shared across platforms, use functions available to all intended recipients or provide an alternative calculation. For a one-off check, opening the workbook in a current Microsoft 365 version can help determine whether an older application is the limitation.

How #NAME? differs from other Excel errors

Knowing the neighboring error types helps narrow down the cause. #VALUE! generally indicates that a formula received an unsuitable value or argument. #REF! indicates an invalid reference. #DIV/0! indicates division by zero or an empty divisor. #N/A commonly means a lookup or other operation has no available result. These errors have different causes even when they appear in similar-looking formulas.

Excel also has #NUM! for certain numeric problems, #NULL! for an invalid range intersection, and newer errors such as #SPILL! when a dynamic-array formula cannot place its results. The error label is useful because it points toward a category of problem. It does not always identify the exact character or cell that needs correcting, so inspect the formula and its inputs.

A separate misconception is that the word after a hash sign is always a formula name. In this case, #NAME? is the error value Excel displays; it is not a function you can call in a formula to repair the cell. Fix the formula or name that caused the error instead.

Preventing recurring #NAME? errors

Careful formula entry and workbook design reduce these errors, especially in shared files. Use Excel’s function suggestions, and check the formula bar after editing complex formulas. When a formula includes text, type the quotation marks directly in Excel rather than copying typographic quotes from formatted documents.

Use consistent, clearly documented names, and review them in Name Manager before deleting or renaming them.
When sharing a workbook, tell recipients which Excel version is required if formulas use newer functions.
Test formulas with ordinary inputs and with blank or unexpected inputs, since fixing one error can reveal a separate issue.
Keep a copy of a workbook before making broad changes to formulas or defined names.
When copying formulas between workbooks, check whether their named ranges and supporting sheets were copied too.

These habits matter most in workbooks that use many named ranges, imported formulas, or functions introduced in recent versions. A formula that works in its original file may rely on a name or feature that is not present in a copied workbook. Checking those dependencies before distributing the file can prevent confusing errors for other users.

Frequently Asked Questions

What does #NAME? mean in Excel?
It means Excel cannot recognize part of a formula. Common reasons include a misspelled function, text without quotation marks, an undefined or misspelled name, or a function unsupported by that Excel version.

How do I get rid of #NAME? in Excel?
Select the cell, inspect its formula, and correct the unrecognized item. Check function spelling, add quotation marks around literal text, confirm named ranges in Name Manager, and check version support when the workbook uses newer functions.

Why does my Excel formula say #NAME? when I use a word?
Excel may interpret an unquoted word as a defined name. If the word is meant to be literal text, surround it with straight double quotation marks. If it is meant to be a range name, make sure that name exists and is spelled correctly.

Can an old Excel version cause #NAME?
Yes. A function introduced in a newer Excel release may not be recognized by an older version. Check the function’s version requirements and, if possible, open the workbook in a compatible current version.

Is #NAME? the same as #VALUE! or #REF!?
No. #NAME? points to an unrecognized item in a formula; #VALUE! usually concerns an unsuitable value, and #REF! indicates an invalid cell reference. The different labels suggest different troubleshooting steps.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.