How to correct a #NAME error in Excel

How to correct a #NAME error in Excel Picture 1

In this article, Dexterity Software will introduce readers on how to fix a #NAME? Error . in Excel.

Error #NAME? in Excel

Error #NAME? An error when Excel cannot recognize what it is, it can be a function or an argument. Common causes of #NAME errors ? either because the function name is misspelled, or one of the following is caused:

  1. The syntax is missing quotes "" for text values;
  2. The reference area is incorrectly typed or missing a colon:;
  3. The function you are using is not supported in Excel .

To fix the # NAME error ? In Excel, you must know why, since there may be correct handling.

Error #NAME? by typing the wrong function name

The first cause when encountering #NAME error ? You should check that the function name is correct. For example, the correct function name is SUM (E11: E21) but you misspell it to SUN (E11: E21).

How to correct a #NAME error in Excel Picture 2

So to fix the #NAME? Error ? You only need to correct the name of the function.

To avoid the function name being incorrectly typed or mistakenly named, you should use the Function Wizard to avoid syntax errors. Select the cell to enter the formula (1) ; In the Formula bar , click the Insert Function icon (2) .

How to correct a #NAME error in Excel Picture 3

Excel will display a list of available functions for users to choose, select the function to use (1) and click the OK button (2) .

How to correct a #NAME error in Excel Picture 4

Excel will then ask you to provide information matching each argument.

Error #NAME? due to missing quotes

For text format arguments, force the user to use double quotes for the beginning and end of the argument. If not, an error will occur.

For example, you use the LEN function to count the length of a text string: CHUOI. What if the LEN (CHUOI) function syntax returns the #NAME error value ? .

How to correct a #NAME error in Excel Picture 5

Modifying the formula with: LEN ("chuoi") will result in 5 characters.

How to correct a #NAME error in Excel Picture 6

Error #NAME? by typing the wrong reference area

For example, instead of typing the correct reference region as D4: D7, type DD: D7. Excel will not recognize the reference region and the #NAME error message ? .

How to correct a #NAME error in Excel Picture 7

Or because you lacked a trailing sign: in the reference area, for example D4 D7, the result will also issue the #NAME? Error .

How to correct a #NAME error in Excel Picture 8

In case of incorrect typing, you can only correct the forearms correctly. To limit errors, instead of entering them manually you should use the mouse to select the argument as a reference region. For example, to enter the formula = SUM (D4: D7); Type = SUM ( , press + hold the left mouse button in cell D4 and move the mouse to cell D7 , release the mouse button to finish selecting the reference region, type) and press Enter to end the formula.

Above Software Tips has just taught you some ways to fix errors #NAME? . In addition, if you have any questions about Excel File errors or questions, you can leave your comments in the comment section below the article. Good luck!

4.5 ★ | 2 Vote

May be interested

  • How to fix the error can not save Excel filePhoto of How to fix the error can not save Excel file
    how to fix the error can not save excel file. in some cases, you can open a spreadsheet directly on outlook, or open a file as read only; you can edit the file, but when saving the file, excel will alert you with the following content:
  • How to fix non-unhide error in ExcelPhoto of How to fix non-unhide error in Excel
    when working on an excel spreadsheet, there are times when you clearly see that there are hidden lines (hide) that you cannot open offline (unhide). why is that happening? let's have a look at dexterity software through the article below.
  • How to fix date auto-jump error in ExcelPhoto of How to fix date auto-jump error in Excel
    due to the convention of the date format of different regions; for example, the americas region is usually the month / day / year format; for some asian countries and vietnam usually use the day / month / year. because of the difference, users sometimes encounter the error of writing the wrong date, the date you see jump is not as desired.
  • Top 5 best PDF file joining software and how to use itPhoto of Top 5 best PDF file joining software and how to use it
    if you have to work with pdf documents and documents, pairing pdf files will save you time and make it easier to manage. tipsmake.com provides readers with pdf file joining software to help us manipulate on pdf files more conveniently.
  • How to install Canon 2900 printer on Windows 10Photo of How to install Canon 2900 printer on Windows 10
    how to install the canon 2900 printer on windows 10. for office work, printers play an important role when you want to print documents. how to install the printer is not complicated, but not everyone knows. bi write this please
  • Beautiful and professional PowerPoint backgroundsPhoto of Beautiful and professional PowerPoint backgrounds
    beautiful and professional powerpoint backgrounds. in order for our powerpoint presentation to be impressive, the preparation and selection of background images to suit and fit the content to present is quite important. choosing a good background image and matching the context of the presentation will help your presentation attract attention