Navigation:  Formula Reference > Spreadsheet Formula Functions >

ERF

Previous pageReturn to chapter overviewNext page

 

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:

where x is the limit argument.

If there upperlimit is supplied, the function calculates:

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

ERFC

STEYX