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

Resolution

  • Optionally, if error checking is turned on in Excel, click the button that appears next to the cell that displays the error Button image, 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.

 
 
Applies to:
Excel 2010