Share via


WorksheetFunction.ErfC Method

Excel Developer Reference

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

Name Required/Optional Data Type Description
Arg1 Required Variant The first argument.
Arg2 Optional Variant The 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)

See Also