• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

#NAME?

You see the #NAME? error when Excel doesn't recognize a name you used in a formula, or when it interprets text within the formula as an undefined name. This means that the #NAME? error pops up in a wide variety of circumstances:

  • You spelled a range name incorrectly.

  • You used a range name that you haven't yet defined.

  • You spelled a function name incorrectly.

  • You used a function that is part of an uninstalled add-in.

  • You used a string value without surrounding it with quotation marks.

  • You entered a range reference and accidentally omitted the colon.

  • You entered a reference to a range on another worksheet and didn't enclose the sheet name in single quotation marks.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint