Documentation/Calc Functions/ERF.PRECISE
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ERF.PRECISE
Category:
Statistical Analysis
Summary:
Returns values of the Gaussian error function(integral), also called as error function, between 0 and the given limit.
Syntax:
ERF.PRECISE(LowerLimit)
Returns:
Returns a real number which is the Gaussian error function value for LowerLimit and it ranges from -1 to 1, i.e. (-1,1).
Arguments:
LowerLimit is the limit of the integral. The calculation takes place between 0 and this limit, any real number, or a reference to the cell containing that number. It can be negative under which case the function reverses the integral, i.e. calculates the integral value from 0 to this limit with a negative sign multiplied to it.
- If the LowerLimit is not a real number or the referenced cell doesn't contain a real number then the function returns a value(#VALUE!) error.
Additional details:
The formula for ERF.PRECISE is:
where L is the LowerLimit.
The figure below illustrates the function ERF.PRECISE:
For more details on ERF.PRECISE, visit Wikipedia.
Examples:
Formula | Description | Returns |
---|---|---|
=ERF.PRECISE(1) | The function calculates the Gaussian error integral value for LowerLimit as 1. | 0.842700792949715 |
=ERF.PRECISE(-1) | The function calculates the Gaussian error integral value for LowerLimit as -1. | -0.842700792949715 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
ERF.PRECISE