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.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
5263659098109442350
true
Search Help Center
true
true
true
true
true
35
false
false