ERFC(x)

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

xThe lower bound for integrating ERF.

Remarks

* ERFC.PRECISE was added in Excel 2010 to replace this function.
* If "x" is not numeric, then #VALUE! is returned.
* If "x" < 0, then #NUM! is returned.
* In Excel 2010 the accuracy of this function was improved to accept negative arguments. Prior to Excel 2010, negative arguments returned #NUM!.
* In Excel 2007 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

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


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