# 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