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.
Syntax: ERFC.PRECISE( x )
where x is the lower limit of the complementary error function integral.
Erfc.Precise Function Examples
The spreadsheets below show the Excel Erfc.Precise function used to calculate the Complementary Error Function between various supplied lower limits and infinity. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the function results.
Erfc.Precise Function Common Error
If you get an error from the Excel Erfc.Precise function this is likely to be the #VALUE! error :
|#VALUE!||–||Occurs the supplied argument, x, is non-numeric|