Documentation/Calc Functions/ERFC
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ERFC
Category:
Add-in
Summary:
Calculates the value of the complementary error function for a specified limit. This is equivalent to the value of the error function calculated between the specified limit and infinity.
Syntax:
ERFC(Limit)
Returns:
Returns a real number in the range 0 < x < 2, which is the value of the complementary error function for the specified limit.
Arguments:
Limit is a real number, or a reference to a cell containing that number, which is the value for which the complementary error function is to be calculated.
- If Limit is non-numeric, then ERFC reports a #VALUE! error.
Additional details:
The formula for ERFC is:
- ERFC(x) = 1 - ERF(x)
The following figure shows a plot of this function.
More information can be found at Wikipedia’s Error function page.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =ERFC(−1.1) | Here the function calculates the value of the complementary error function for a limit of -1.1, returning the value 1.88021 (to five decimal places). | 1.88021 |
| =ERFC(D1) where cell D1 contains the value 0. | Here the function calculates the value of the complementary error function for a limit of 0, returning the value 1. | 1 |
| =ERFC(1.1) | Here the function calculates the value of the complementary error function for a limit of 1.1, returning the value 0.11979 (to five decimal places). | 0.11979 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ERFC