Excel / 4 min read

How to Fix #NAME? Error in Excel

Fix misspelled function names, missing quotes, unsupported functions, and broken named ranges that trigger #NAME? in Excel.

Error text: #NAME?

A #NAME? error means Excel does not recognize part of the formula text. Most often that is a misspelled function, an undefined named range, or plain text missing quotes.

Check this first

Recheck the function spelling character by character.
Wrap literal text values in quotes.
Confirm that any named range still exists.
Check whether the formula uses a function unavailable in your Excel version.

Working examples

Text must be quoted

=IF(A2="Paid", "Done", "Open")

Where #NAME? comes from

Excel reads formula text literally. If it sees a word that is neither a function nor a valid named range, it stops with #NAME? because it does not know what that token refers to.

This often happens when copying formulas from articles that use newer functions, or when someone forgets quotes around a text comparison.

Most common repairs

Start by checking text values, since missing quotes are easy to miss. Then move on to function names and named ranges, especially in older files that have been edited by several people.

Add quotes around text like "Yes" or "Closed".
Replace unsupported functions with older alternatives if needed.
Open Name Manager to verify named ranges.

Version mismatch is common

If a formula uses XLOOKUP, LET, TEXTSPLIT, or another newer function, older Excel versions may not understand it. In those cases the formula is not wrong in general, but wrong for that environment.