Documentation/Calc Functions/ERFC.PRECISE

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 &infin;. 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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/ERFC.PRECISE ERFC.PRECISE]

[[Special:MyLanguage/Documentation/Calc_Functions/ERFC ERFC]

[[Special:MyLanguage/Documentation/Calc_Functions/ERF ERF]

ODF standard:
None

Equivalent Excel functions:
ERFC.PRECISE