This error indicates that a formula or function contains invalid numeric values.
Microsoft Excel displays #NUM! in one or more cells on a worksheet.
- 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.
Change the formula so that its result is between -1*10307 and 1*10307.
- 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.