ERF functionThe 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
Related functions
ERFC: The ERFC function returns the complementary Gauss error function of a value.
NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.