Related Functions:

The ERF function returns the error function integrated between two supplied limits.

Syntax

=ERF(lower_limit,[upper_limit])

Note: In Excel 2007 or earlier, if you input a negative value for the lower_limit or [upper_limit], the function would return an error. However, in Excel 2010, the function algorithm has been improved, so that it can now calculate the function for both positive and negative ranges.

Arguments

Argument Description
lower_limit The lower bound for integrating ERF
[upper_limit] Optional. The upper bound for integrating ERF. If omitted, ERF integrates between zero and lower_limit

Examples

  A B C
1 Formula Result Notes
2 =ERF(o.745) 0.70792892 Error function integrated between 0 and 0.74500
3 =ERF(1,2) 0.15262153 Error function integrated between 1 and 2

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs in Excel 2007 or earlier if either of the supplied arguments are negative
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The Error function is given by the equation:

    \[Erf(x)=\frac{2}{\sqrt{\pi}}\int e^{-t^2}dt\]

Further information on error function can be found on the Wikipedia Error Function page