The ERF function returns the integral of the Gauss error function over an interval of values.
Parts of an ERF formula
ERF(lower_bound, [upper_bound])
Part | Description | Notes |
lower_bound |
If this parameter is the only parameter, the integral is taken between 0 and this value. If z2 is provided, it refers to the lower boundary for the integral. | |
upper_bound |
The upper boundary of the integral. | Upper boundaries are optional. |
Sample formulas
ERF(-2.3, -0.7)
ERF(1)
Notes
If the lower or upper boundaries are non-numeric, ERF returns "#VALUE!."
Examples
A | B | |
1 | Formula | Result |
2 | ERF(-2.3, -0.7) | 0.3210556296 |
3 | ERF(1) | 0.8427007929 |