The ERFC.PRECISE function accepts
- This function was introduced in Excel 2010 and so is not available in earlier versions. However, it is similar to the ERFC function, which is available in earlier versions of Excel.
|x||The lower bound for integrating ERFC.PRECISE|
|2||=ERFC.PRECISE(1)||0.15729921||Complementary ERF function of 1|
|3||=ERFC.PRECISE(-1)||1.84270079||Complementary ERF function 0f -1|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if the supplied argument x is non-numeric|
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.