NAME?
How to correct a #NAME? error
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the spider 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 #Name? error appears in the formula is because at that place is a typo in the formula name. Look at the post-obit case:
Important:The #NAME? error signifies that something needs to be corrected in the syntax, and so when you run into the mistake in your formula, resolve information technology. Practice not use any error-handling functions such as IFERROR to mask the error.
To avoid typos in formula names, use the Formula Wizard in Excel. When you offset typing a formula proper name in a jail cell or the Formula Bar, a list of formulas matching to the words y'all have entered displays in a dropdown. Once you enter the formula name and the opening parentheses, the Formula Wizard displays the syntax equally hover text.
You tin also utilise the Function Wizard to avoid the syntactical errors. Select the cell with the formula, and on the Formula tab, press Insert Function.
Excel will automatically load the Wizard for you.
As you click each argument, Excel will requite you the advisable data for each one.
Given below are other causes of the #NAME? fault.
When your formula has a reference to a name that is not defined in Excel, you will run across the #NAME? error.
See the following example of a SUM function referring to Profit, which is an undefined name in the workbook.
Solution: Define a proper name in Proper name Manager, and and then add the name to the formula. Follow these steps to do that:
-
If yous already take the information in the spreadsheet, and want to assign a name to specific cells or a jail cell range, starting time select the cells in the spreadsheet. If you desire to create a new range, you lot can skip this step.
-
On the Formulas tab, in the Divers Names group, click Define Name, and and then click Ascertain Name.
-
Enter a unique proper noun.
-
For the Scope, select if you desire the proper name to exist available within the sheet only, or the entire workbook.
-
Enter an optional comment.
-
Click OK.
The next part is to add together the name in the formula.
-
Continue the cursor in the formula syntax at the signal where yous desire to add the name yous but created.
-
Go to the Formulas tab, in Defined Names group, click Apply in Formula, and then select the defined name you want to add together.
For more than information on using defined names, encounter Define and use names in formulas.
If the syntax incorrectly refers to a defined name, y'all will see the #NAME? mistake.
Continuing with the previous example, a defined name for Profit was created in the spreadsheet. In the following example, the proper name is non spelled correctly, and so the role 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 do that, go to the Formulas tab, in Defined Names grouping, click Use in Formula, and so select the defined name you want to add together. Excel will add together the proper name to the formula.
When you include text references in formulas, you demand to enclose the text in quotation marks, fifty-fifty if you're but using a space. If the syntax omits double quotation marks "" for a text value, you will see the #Proper name mistake. See the following instance.
The syntax in this example is missing double quotation marks for has; that's why the error.
Solution: Go back to your syntax and manually inspect to make sure that any text values accept quotation marks around them.
If you lot miss a colon in a range reference, the formula will display a #NAME? error.
In the following example, the INDEX formula throws the #Proper 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.
There are some Excel functions that piece of work but when certain add-ins are enabled. Using these functions otherwise will produce a #NAME? error. For instance, to use the EUROCONVERT function, the Euro Currency Tools add-in has to exist enabled. If you use custom functions or macros that require the Analysis ToolPak, make sure that the Analysis ToolPak add together-in is enabled.
To enable add-ins in Excel:
-
Click File > Options.
-
Click Add-ins.
-
In the Manage list box, pick Excel Add-ins and click Go.
-
Check the relevant box and click OK.
Demand more assistance?
You tin can ever enquire an expert in the Excel Tech Community or get back up in the Answers community.
See As well
Overview of formulas in Excel
How to avoid cleaved formulas
Detect 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