Related Functions:

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.


Argument Description
x The lower bound for integrating ERFC


  A B C
1 Formula Result Notes
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:

    \[ Erfc(x)= \frac{2}{\sqrt{\pi}} \int_x^{\infty} e^{-t^2}\ dt \]

Further information can be found on the Wikipedia Error Function page.