Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# Correct a #NUM! error

This error indicates that a formula or function contains invalid numeric values.

## Symptom

Microsoft Excel displays **#NUM!** in one or more cells on a worksheet.

## Causes

- The wrong data type might be supplied in a function that requires a numeric argument.
- The formula might use a worksheet function that iterates (iteration: Repeated calculation of a worksheet until a specific numeric condition is met.), such as
**IRR**or**RATE**, and that function cannot find a result. - The result of a formula might produce a number that is too large or too small to be represented in Excel.

## Resolution

- Optionally, if error checking is turned on in Excel, click the button that appears next to the cell that displays the error , click
**Show Calculation Steps**if it appears, and then click the resolution that is appropriate for your data.

** Tip ** Review the following resolutions to help determine which option to click.

- Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that are used in the function are numbers. For example, even if the value that you want to enter is
**$1,000**, enter**1000**in the formula. - Use a different starting value for the worksheet function.
- Change the number of times that Excel iterates formulas by doing the following:
- Click the
**File**tab, click**Options**, and then click the**Formulas**category. - Under
**Calculation options**, select the**Enable iterative calculation**check box. - To set the maximum number of times that Excel will recalculate, type the number of iterations in the
**Maximum Iterations**box. The higher the number of iterations, the more time Excel needs to calculate a worksheet. - To set the maximum amount of change that you will accept between calculation results, type the amount in the
**Maximum Change**box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet. - Change the formula so that its result is between -1*10
^{307}and 1*10^{307}.

Applies to:

Excel 2010