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.

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Engineering

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.

Clear search

Close search

Google apps

Main menu