ERFC.PRECISE

ERFC.PRECISE(x)

Returns the complementary error function integrated between a limit and infinity.

x	The lower bound used in the integration.

REMARKS

* If "x" is not numeric, then #VALUE! is returned.
* If "x" < 0, the function returns a value which ERFC did not do.
* You can use the ERF function to return the value of the error function integrated between two limits.
* You can use the ERF.PRECISE function to return the value of the error function integrated between 0 and a limit.
* You can use the ERFC function to return the complementary error function integrated between a limit and infinity.
* This function was added in Excel 2010 to replace the ERFC function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ERFC.PRECISE(0) = 1.000
2	=ERFC.PRECISE(0.02) = 0.977
3	=ERFC.PRECISE(0.5) = 0.480
4	=ERFC.PRECISE(1) = 0.157
5	=ERFC.PRECISE(1.3) = 0.066
6	=ERFC.PRECISE(2) = 0.005
7	=ERFC.PRECISE(3) = 0.000
8	=ERFC.PRECISE(4) = 0.000
9	=ERFC.PRECISE(5) = 0.000
10	=ERFC.PRECISE(-1) = 1.843
11	=ERFC.PRECISE(-2) = 1.995
12	=ERFC.PRECISE("some text") = #VALUE!

1 - What is the complementary error function integrated between 0 and infinity.
2 - What is the complementary error function integrated between 0.02 and infinity.
3 - What is the complementary error function integrated between 0.5 and infinity.
4 - What is the complementary error function integrated between 1 and infinity.