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:
- The syntax is missing quotes "" for text values;
- The reference area is incorrectly typed or missing a colon:;
- 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!
You should read it
- How to correct a #REF! Error in Excel
- How to fix the SUM function doesn't add up in Excel
- What is ### error in Excel? how to fix ### error in Excel
- Instructions on how to fix reverse dates in Excel
- How to use the FIND function in Excel?
- how to fix error cannot copy data in Excel files
- How to fix the date #VALUE error in Excel
- How to fix date format errors in Excel
May be interested
- How to fix the error can not save Excel filehow 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 Excelwhen 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 Exceldue 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 itif 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 10how 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 backgroundsbeautiful 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