Occurs when Microsoft Excel doesn't recognize text in a formula.
- Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.
- Review the possible causes and solutions.
Possible causes and solutions
Using a function that is part of the Analysis Toolpak add-in, without the add-in being loaded
Install and load the Analysis Toolpak add-in (address: The path to an object, document, file, page, or other destination. An address can be a URL (Web address) or a UNC path (network address), and can include a specific location within a file, such as a Word bookmark or an Excel cell range.).
- On the Tools menu, click Add-Ins.
- In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
- If necessary, follow the instructions in the setup program.
Using a name that does not exist
Misspelling the name
Using a label in a formula, without labels being allowed
Allow labels to be used. On the Tools menu, click Options, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box.
Misspelling the name of a function
Correct the spelling. Insert the correct function name into the formula by clicking Function on the Insert menu.
Entering text in a formula without enclosing the text in double quotation marks
(Excel tries to interpret your entry as a name even though you intended it to be used as text.)
Enclose text in the formula in double quotation marks. For example, the following formula joins the piece of text "The total amount is " with the value in cell B50:
="The total amount is "&B50
Omitting a colon (:) in a range reference
Make sure all range references in the formula use a colon (:); for example, SUM(A1:C10).
Referencing another sheet not enclosed in single quotation marks
If the formula refers to values or cells on other worksheets or workbooks and the name of the other workbook or worksheet contains a nonalphabetical character or a space, you must enclose its name within single quotation marks ( ' ).