NAME
How to correct a #NAME? error
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel Web App Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less
The top reason why the #Proper noun? error appears in the formula is because at that place is a typo in the formula name. Look at the following example:
Important:The #Proper noun? error signifies that something needs to exist corrected in the syntax, so when y'all come across the error in your formula, resolve it. Do non use any error-handling functions such equally IFERROR to mask the mistake.
To avoid typos in formula names, use the Formula Wizard in Excel. When you first typing a formula name in a cell or the Formula Bar, a list of formulas matching to the words you have entered displays in a dropdown. Once y'all enter the formula name and the opening parentheses, the Formula Magician displays the syntax as hover text.
You can also use the Role Wizard to avoid the syntactical errors. Select the prison cell with the formula, and on the Formula tab, press Insert Function.
Excel volition automatically load the Wizard for you.
Every bit you click each statement, Excel will requite y'all the appropriate information for each one.
Given below are other causes of the #Proper name? error.
When your formula has a reference to a name that is not defined in Excel, you will see the #Name? mistake.
See the following example of a SUM office referring to Turn a profit, which is an undefined name in the workbook.
Solution: Ascertain a name in Name Managing director, and and so add the name to the formula. Follow these steps to do that:
-
If you already have the information in the spreadsheet, and want to assign a name to specific cells or a cell range, kickoff select the cells in the spreadsheet. If yous want to create a new range, y'all tin can skip this step.
-
On the Formulas tab, in the Defined Names group, click Define Name, and then click Ascertain Name.
-
Enter a unique proper noun.
-
For the Scope, select if you want the name to be available within the sheet only, or the entire workbook.
-
Enter an optional annotate.
-
Click OK.
The next role is to add the proper name in the formula.
-
Go along the cursor in the formula syntax at the point where yous want to add the name you just created.
-
Go to the Formulas tab, in Defined Names grouping, click Use in Formula, and so select the defined proper noun yous desire to add.
For more information on using defined names, come across Ascertain and use names in formulas.
If the syntax incorrectly refers to a defined proper name, you will see the #NAME? fault.
Standing with the previous example, a defined name for Profit was created in the spreadsheet. In the following example, the name is not spelled correctly, so the office still throws the #NAME? error.
Solution: Correct the typo in the syntax and retry the formula.
Tip:Instead of manually entering defined names in formulas, you tin can have Excel practice it automatically for you. To practice that, become to the Formulas tab, in Defined Names group, click Use in Formula, and and then select the defined name you lot want to add. Excel will add the name to the formula.
When you include text references in formulas, you demand to enclose the text in quotation marks, even if you're only using a infinite. If the syntax omits double quotation marks "" for a text value, you volition meet the #NAME mistake. Encounter the following example.
The syntax in this example is missing double quotation marks for has; that'southward why the error.
Solution: Go back to your syntax and manually inspect to make sure that any text values have quotation marks around them.
If y'all miss a colon in a range reference, the formula will display a #NAME? error.
In the following example, the INDEX formula throws the #Proper noun? error considering the B2 to B12 range is missing a colon.
Solution: Cheque your syntax to make sure all range references include the colon.
In that location are some Excel functions that work merely when certain add-ins are enabled. Using these functions otherwise will produce a #Proper name? error. For case, to utilize the EUROCONVERT function, the Euro Currency Tools add-in has to exist enabled. If you use custom functions or macros that crave the Analysis ToolPak, make certain that the Assay ToolPak add-in is enabled.
To enable add-ins in Excel:
-
Click File > Options.
-
Click Add-ins.
-
In the Manage listing box, selection Excel Add-ins and click Go.
-
Bank check the relevant box and click OK.
Need more help?
You lot can ever ask an proficient in the Excel Tech Community or get support in the Answers customs.
Meet Too
Overview of formulas in Excel
How to avoid broken formulas
Detect errors in formulas
Excel functions (alphabetical)
Excel functions (by category)
Source: https://support.microsoft.com/en-us/office/how-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7b4286
0 Response to "NAME"
Post a Comment