You receive a "#NUM!" error when you enter a numeric value of 27.3345 or larger or a negative value in the ERF or ERFC functions in Excel 2003

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
When you enter a negative number in the ERF function or in the ERFC function, you receive a "#NUM!" error in the Microsoft Excel worksheet. The "#NUM!" error occurs when you enter a negative number as the lower_limit value or as the upper_limit value.

Additionally, if you enter a numeric value of 27.3345 or larger in the lower_limit value or the upper_limit value in the ERF or ERFC functions, you may receive a #NUM! error in the Excel worksheet.

For example, if you type =erf(27.3346) in a cell, and then you type =erfc(27.3346) in the next cell, you will receive a #NUM! error.

If you type =erf(-1) in a cell, and then you type =erfc(-1) in the next cell, you will receive a #NUM! error
CAUSE
This problem occurs because Microsoft Office Excel 2003 and earlier versions are not designed to correctly process negative input values and input values that are larger than 27.3345. This is true even though negative input values and input values that are larger than 27.3345 are both mathematically correct.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
ERF ERFC
Properties

Article ID: 893351 - Last Review: 01/16/2015 15:30:42 - Revision: 2.2

  • Microsoft Office Excel 2003
  • kbnosurvey kbarchive kbtshoot kbprb KB893351
Feedback