Documentation/Calc Functions/ERFC.PRECISE
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ERFC.PRECISE
Category:
Statistical Analysis
Summary:
Returns complementary values of the Gaussian error function(integral), also called as error function, between a lower limit and infinity. This is a complementary error function.
Syntax:
ERFC.PRECISE(LowerLimit)
Returns:
Returns a real number which is the complementary error function value for LowerLimit and it ranges from 0 to 2, i.e. (0,2).
Arguments:
LowerLimit is the lower limit of the integral. The calculation takes place between this limit and ∞. Here limit can be any real number or a reference to the cell containing that number.
- 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 ERFC.PRECISE is:
where L is the LowerLimit.
The figure below illustrates the function ERFC.PRECISE:
- ERFC.PRECISE(L) = 1 - ERF.PRECISE(L)
- For more details on ERFC.PRECISE, visit Wikipedia.
Examples:
Formula | Description | Returns |
---|---|---|
=ERFC.PRECISE(1) | The function calculates the complementary error function value for LowerLimit as 1. | 0.157299207050285 |
=ERFC.PRECISE(-1) | The function calculates the complementary error function value for LowerLimit as -1. | 1.84270079294972 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
ERFC.PRECISE