[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ERFC ( lower-bound )
Description: Computes the complementary error function integrated between lower-bound and ∞.
Mathematical Formula:
Arguments:
Name |
Type |
Description |
lower-bound |
number |
The lower bound for integrating ERFC. |
Return Type and Value: number – The complementary error function integrated between lower-bound and ∞.
However, if lower-bound is negative
lower-bound or upper-bound is negative, #NUM! is returned.
[Example:
ERFC(1.234) results in 0.08096060
ERFC(0) results in 1.00000000
end example]