The ERFC function returns the complementary ERF function integrated between x and infinity.
Note: In Excel 2007 or earlier, if you input a negative value for the argument x, the function would return an error. However, in Excel 2010, the function algorithm has been improved so that it can now calculate the function for both positive and negative x values.
|x||The lower bound for integrating ERFC|
|2||=ERFC(1)||0.15729921||Complementary ERF function of 1|
|3||=ERFC(2)||0.004677735||Complementary ERF function of 2|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if the supplied value of x is nonnumeric|
|#NUM!||Occurs in Excel 2007 or earlier, if the supplied value of x is negative|
|#NAME?||Occurs when Analysis ToolPak add-in is not enabled|
The Complementary Error Function is equal to 1 – ERF, i.e. (1 – Error Function), and is given by the equation:
Further information can be found on the Wikipedia Error Function page.