The Complementary Error Function is equal to 1 - ERF (i.e. 1 - Error Function), and is given by the equation:
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:
where x is the lower limit of the complementary error function integral.
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:
|
||||||||||||
Results:
|
Further examples of the Excel Erfc.Precise function are provided on the Microsoft Office website.
If you get an error from the Excel Erfc.Precise function this is likely to be the #VALUE! error:
#VALUE! | - | Occurs if the supplied value of x is non-numeric. |