[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ERF

Syntax:

ERF ( lower-bound [ , upper-bound ] )

Description: Computes the error function integrated between lower-bound and upper-bound.

Mathematical Formula:

If upper-bound is omitted:

If upper-bound is present:

Arguments:

Name

Type

Description

lower-bound

number

The lower bound for integrating ERF.

upper-bound

number

The upper bound for integrating ERF. If omitted, the value of the upper bound is lower-bound, and the lower bound becomes zero.

 

Return Type and Value: number – The error function integrated between lower-bound and upper-bound.

However, if

lower-bound is negative, #NUM! is returned.

upper-bound is negative, #NUM! is returned.

[Example:

ERF(1.234,4.5432) results in 0.08096060
ERF(0,1.345) results in 0.94284416
ERF(0,1.345) results in 0.94284416

end example]