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

Troubleshooting

Avoiding the #NAME? Error Value

Q1:I just typed a formula that included a range name from my worksheet, but when I pressed Enter, the label #NAME? appeared in the cell. What did I do wrong?
A1: Ensure that you spelled the range name correctly. Although named ranges aren't case sensitive, you may have typed (or omitted) a punctuation mark that is part of the defined range name. Check the Name box to see whether the name you typed in the formula appears there. If it doesn't, it's possible that you deleted the range name or the cells that it once referenced. Create the named range again, and the #NAME? error message should disappear.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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