The Excel ERFC.PRECISE Function

Complementary Error Function

The Complementary Error Function is equal to 1 - ERF (i.e. 1 - Error Function), and is given by the equation:

Complementary Error Function Equation
For further details, see the Wikipedia Error Function page
Related Functions:
ERFC
ERF.PRECISE

Function Description

The Excel Erfc.Precise function calculates the Complementary Error Function, integrated between a supplied lower limit and infinity.

The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, it is similar to the Erfc function, which is available in earlier versions of Excel.

The syntax of the Erfc.Precise function is:

ERFC.PRECISE( x )

where x is the lower limit of the complementary error function integral.


Erfc.Precise Function Examples

In the following spreadsheet, the Excel Erfc.Precise function is used to calculate the Complementary Error Function, integrated between different supplied lower limits and infinity.

 Formulas:
  A B
1 =ERFC.PRECISE( 0 )  - integral between 0 and ∞  
2 =ERFC.PRECISE( 0.5 )  - integral between 0.5 and ∞  
3 =ERFC.PRECISE( -1 )  - integral between -1 and ∞  
 Results:
  A B
1 1  - integral between 0 and ∞  
2 0.479500122  - integral between 0.5 and ∞  
3 1.842700793  - integral between -1 and ∞  

Further examples of the Excel Erfc.Precise function are provided on the Microsoft Office website.


Erfc.Precise Function Error

If you get an error from the Excel Erfc.Precise function this is likely to be the #VALUE! error:

Common Error
#VALUE! - Occurs if the supplied value of x is non-numeric.