[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ERFC

Syntax:

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]