Jump to content

Documentation/Calc Functions/ERFC

From The Document Foundation Wiki


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.

Plot for ERFC function
Plot for ERFC 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:

ERF

ERF.PRECISE

ERFC.PRECISE

ODF standard:

Section 6.16.28, part 2

Related (or similar) Excel functions:

ERFC