How to correct a #NAME error in Excel

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).

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) .

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

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 ? .

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

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 ? .

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

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!