How to Use ERF function in Google Sheets in 2020?

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.