ERF (LowerBound, UpperBound?) ERF (LowerBound; UpperBound?)
LowerBound
Number Number
The lower bound.
UpperBound
Number Number (optional)
The upper bound. If omitted, the function returns the error function integrated from 0 to LowerBound .
Returns
Number Number
The Gauss error function.
Returns the Gauss error function integrated from 0 to a lower bound, or between a lower bound and an upper bound.
The error function is closely related to the normal distribution. NORM.S.DIST (Number, TRUE) NORM.S.DIST (Number; TRUE) returns the same value as (1 + ERF (Number / SQRT (2))) / 2(1 + ERF (Number / SQRT (2))) / 2.
Examples
ERF (0.5)
ERF (0,5)
Returns roughly 0.52.
ERF (0, 0.5)
ERF (0; 0,5)
Returns roughly 0.52.
ERF (0.5, 1.5)
ERF (0,5; 1,5)
Returns roughly 0.45.