[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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]