NAME
How to right a #Proper noun? error
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2022 for Mac Excel 2019 Excel 2022 for Mac Excel 2016 Excel 2022 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 #NAME? error appears in the formula is considering there is a typo in the formula proper name. Expect at the following case:
Important:The #NAME? error signifies that something needs to be corrected in the syntax, and then when you run into the mistake in your formula, resolve it. Practise not use any error-handling functions such as IFERROR to mask the fault.
To avoid typos in formula names, utilise the Formula Magician in Excel. When yous outset typing a formula proper name in a prison cell or the Formula Bar, a list of formulas matching to the words y'all accept entered displays in a dropdown. In one case yous enter the formula proper name and the opening parentheses, the Formula Wizard displays the syntax every bit hover text.
You can also utilize the Function Wizard to avoid the syntactical errors. Select the prison cell with the formula, and on the Formula tab, press Insert Function.
Excel will automatically load the Magician for you.
As y'all click each argument, Excel volition give you the appropriate information for each one.
Given beneath are other causes of the #Proper noun? mistake.
When your formula has a reference to a proper name that is non divers in Excel, you will encounter the #Name? error.
Run into the following case of a SUM function referring to Profit, which is an undefined name in the workbook.
Solution: Define a name in Proper name Manager, and so add together the proper name to the formula. Follow these steps to practise that:
-
If y'all already take the information in the spreadsheet, and desire to assign a name to specific cells or a cell range, beginning select the cells in the spreadsheet. If you want to create a new range, yous can skip this step.
-
On the Formulas tab, in the Defined Names group, click Define Proper noun, and then click Define Proper noun.
-
Enter a unique name.
-
For the Scope, select if yous want the name to be available within the sheet merely, or the entire workbook.
-
Enter an optional comment.
-
Click OK.
The side by side part is to add the proper noun in the formula.
-
Go on the cursor in the formula syntax at the indicate where you want to add the name you just created.
-
Go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined proper name yous want to add.
For more information on using defined names, see Define and use names in formulas.
If the syntax incorrectly refers to a defined name, y'all volition see the #NAME? error.
Standing with the previous example, a defined name for Profit was created in the spreadsheet. In the following case, the proper noun is non spelled correctly, and so the part nonetheless 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 can have Excel do it automatically for y'all. To do that, go to the Formulas tab, in Defined Names grouping, click Use in Formula, and then select the defined name yous want to add. Excel will add the proper name to the formula.
When you lot include text references in formulas, yous need to enclose the text in quotation marks, even if you're only using a space. If the syntax omits double quotation marks "" for a text value, you will see the #NAME error. See the following example.
The syntax in this example is missing double quotation marks for has; that's why the fault.
Solution: Go back to your syntax and manually audit to make sure that any text values have quotation marks effectually them.
If you miss a colon in a range reference, the formula volition display a #NAME? mistake.
In the post-obit instance, the INDEX formula throws the #NAME? error because the B2 to B12 range is missing a colon.
Solution: Check your syntax to make sure all range references include the colon.
In that location are some Excel functions that work only when sure add-ins are enabled. Using these functions otherwise will produce a #NAME? error. For example, to use the EUROCONVERT function, the Euro Currency Tools add together-in has to be enabled. If you employ custom functions or macros that crave the Analysis ToolPak, make certain that the Analysis ToolPak add-in is enabled.
To enable add together-ins in Excel:
-
Click File > Options.
-
Click Add-ins.
-
In the Manage list box, choice Excel Add together-ins and click Go.
-
Check the relevant box and click OK.
Demand more help?
Yous tin e'er ask an expert in the Excel Tech Customs or go support in the Answers community.
Run across Also
Overview of formulas in Excel
How to avoid cleaved formulas
Observe errors in formulas
Excel functions (alphabetical)
Excel functions (past 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