ERFC.PRECISE

ERFC.PRECISE(x)

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

xThe 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
* You can use the ERF.PRECISE function to
* You can use the ERFC function to
* 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.

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