# Documentation/Calc Functions/ERFC.PRECISE

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.

The formula for ERFC.PRECISE is:

where L is the LowerLimit.

The figure below illustrates the function ERFC.PRECISE:

ERFC.PRECISE function
• 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

None

ERFC.PRECISE