ERF

ERF(lower_limit [,upper_limit])

Returns the value of the error function integrated between two limits.

lower_limitThe lower bound.
upper_limit(Optional) The upper bound.

REMARKS
* Also known as the Gaussian Error Integral.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "lower_limit" > "upper_limit", then #N/A is returned.
* If "lower_limit" is left blank, then #N/A is returned.
* If "upper_limit" is left blank, then 0 is used.
* You can use the ERF.PRECISE function to return the value of the error function integrated between 0 and a limit.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=ERF(0.2) = 0.223
2=ERF(0.745) = 0.708
3=ERF(-0.745) = -0.708
4=ERF(0, 1) = 0.843
5=ERF(1) = 0.843
6=ERF(1, ) = #N/A
7=ERF(1, 1) = 0
8=ERF(1, 5) = 0.157
9=ERF(1, 6) = 0.157
10=ERF(1, 7) = 0.157
11=ERF(2, 2) = 0.000
12=ERF(2, 4) = 0.005
13=ERF(2, 6) = 0.005
14=ERF(1, 0) = -0.843
15=ERF(1, 1) = 0.000
16=ERF(, 2) = #N/A
17=ERF(1, -5) = -1.843
18=ERF(-1, 5) = 1.843
19=ERF("some text", 5) = #VALUE!

1 - What is the error function integrated between 0 and 0.2.

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