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.
Returns a real number which is the complementary error function value for LowerLimit and it ranges from 0 to 2, i.e. (0,2).
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.
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.
|=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:
Equivalent Excel functions: