Documentation/Calc Functions/ERF

Function name:
ERF

Category:
Add-in

Summary:
Calculates values of the error function, also known as the Gauss error function, between specified limits.

Syntax:
ERF(LowerLimit[; UpperLimit])

Returns:
Returns a real number in the range -1 < x < 1, which is the value of the error function between the specified limits.

Arguments:
LowerLimit is a real number, or a reference to a cell containing that number, which in the two argument version of the function is the lower limit of the integral that defines the error function. In the single argument version of the function, the integral is performed between 0 and LowerLimit.

UpperLimit is a real number, or a reference to a cell containing that number, which in the two argument version of the function is the upper limit of the integral that defines the error function.


 * If either LowerLimit or UpperLimit is non-numeric, then ERF reports a #VALUE! error.
 * ERF takes account of reversing the limits of the integral, for example if UpperLimit < LowerLimit.

Additional details:
The formula for the single argument version of ERF is:

The following figure shows a plot of this formula.

The two argument version of the function uses the relation:
 * ERF(a; b) = ERF(b) - ERF(a)

More information can be found at Wikipedia’s Error function page.

Related LibreOffice functions:
ERFC

ERF.PRECISE

ERFC.PRECISE

ODF standard:
Section 6.16.27, part 2

Equivalent Excel functions:
ERF