# ERF function

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

## 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.
Was this helpful?
How can we improve it?

Search
Clear search
Close search
Google apps
Main menu