Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction.ErfC Method

Office 2007
Returns the complementary ERF function integrated between the specified parameter and infinity.

Syntax

expression.ErfC(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantThe first argument.
Arg2OptionalVariantThe second argument.

Return Value
Double

Remarks

If this function is not available, and returns the #NAME? error, you need to install and load the Analysis ToolPak add-in.

If the parameter is nonnumeric, ERFC returns the #VALUE! error value.

If the parameter is negative, ERFC returns the #NUM! error value.

Example

The following example displays the complementary ERF function of 1 (0.1573).

Visual Basic for Applications
=ERFC(1)



Community Additions

Show: