Spread.NET 18 Formula Reference
Formula Functions / Functions D to G / ERF
In This Topic
    ERF
    In This Topic

    This function calculates the error function integrated between a lower and an upper limit.

    Syntax

    ERF(limit,upperlimit)

    Arguments

    This function has these arguments:

    Argument Description
    limit Either this is the lower limit, if the upper limit is supplied, or it is the upper limit (with 0 as the lower limit) if the second argument is not supplied
    upperlimit [Optional] Upper limit for integrating the function

    Remarks

    If upperlimit is supplied, the function is integrated from limit to upperlimit. If not supplied, the function is integrated from 0 to limit.

    If there upperlimit is not supplied, the function calculates:

    ERF Equation (low limit is zero)

    where x is the limit argument.

    If there upperlimit is supplied, the function calculates:

    ERF Equation (hi-lo limits)

    where lo is the limit argument and hi is the upperlimit argument.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    ERF(K16)

    ERF(R16C11,R16,C12)

    ERF(0.49) gives the result 0.51166826

    ERF(0.25,0.85) gives the result 0.494341544

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ERFC | STEYX | Engineering Functions