ERFC.PRECISE(x)

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

xThe lower bound used in the integration.

Remarks

* Added in Excel 2010.
* This function replaces the ERFC function.
* If "x" is not numeric, then #VALUE! is returned.
* For the Microsoft documentation refer to support.office.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("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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top