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:

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