Documentation/Calc Functions/ERFC

    From The Document Foundation Wiki
    Other languages:


    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

    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