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.
-
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
Make sure the name exists. 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.
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
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 ( ' ).