Spread.Sheets Documentation
ERF
Spread.Sheets Documentation > Formula Reference > Formula Functions > ERF

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

See Also