Answers and Solutions

Answer

*  Name error occurs when excel didn't recognise a text in Formula

Answer

#Name error occurs when excel didn't recognise a text in Formula

Answer

Answer

When excel forward not recognizes a formula

Answer

#Name error occurs when excel didn't recognise a text in Formula.

Answer

#Name error occurs when excel didn't recognise a text in Formula.

Answer

Answer

#Name error occurs when excel didn't recognise a text in Formula.

Answer

Answer

This error occurs when Microsoft Excel does not recognize text in a formula.

Answer

It gives when you give wrong function name or parameters to function

Answer

#Name error occurs when excel didn't recognise a text in Formula.

Example If you have written Averge() instead of Average(), it will give you #Name error

Answer

You get name error when you write a word in Excel which is not recognised by Excel. For example if aplying vlookup in Excel if I will misspell and write =Vlukup then I will get #Name Error.

Answer

Possible causes and solutions

1. Referring to a defined name that does not exist. On the Insert menu, point to Name, and then click Define.

If the name is not listed, add the name by using the Define command. If the name is misspelled, add the correct name by using the Paste command.

2. Using label in a formula but labels are not allowed in your settings. On the Tools menu, click Options, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box.

3. Misspelling a name of a function in a cell. To avoid misspelling use the function option in the Insert menu. Or the function icon in the toolbar.

4. Entering text in a formula without enclosing the text in double quotation marks. Make sure quotation marks are added and they are balanced from left and right.

5. Omitting a colon (:) in a range reference. E.g. COUNT(A1A10) should be COUNT(A1:A10)

6. Referencing another worksheet, but the worksheet name is not enclosed in single quotation marks. If you have a formula referring to another worksheet and the name of that worksheet has a space, then the name should be enclosed within quotation marks. E.g. this formula is correct: =’Monthly budget’!$A$1, but this one will give a “#NAME” error: =Monthly budget!$A$1