Correct a #NUM! error

Occurs with invalid numeric values in a formula or function.

  1. Click the cell that displays the error, click the button that appears Button image, and then click Trace Error if it appears.
  2. Review the possible causes and solutions.

Possible causes and solutions

ShowUsing an unacceptable argument in a function that requires a numeric argument

ShowUsing a worksheet function that iterates, such as IRR or RATE, and the function cannot find a result

Use a different starting value for the worksheet function.

Change the number of times Microsoft Excel iterates formulas.

ShowHow?

  1. On the Tools menu, click Options, and then click the Calculation tab.
  2. Select the Iteration check box.
  3. To set the maximum number of times Microsoft 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.
  4. To set the maximum amount of change 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 Excel needs to calculate a worksheet.

ShowEntering a formula that produces a number that is too large or too small to be represented in Microsoft Excel

Change the formula so that its result is between minus one times ten to the 307th and one times ten to the 307th.

 
 
Applies to:
Excel 2003