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.
* This function is similar to the ERF.PRECISE.
* In Excel 2010 the accuracy of this function was improved to accept negative arguments. Prior to Excel 2010, any negative arguments returned #NUM!.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.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.

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