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 |
|---|
|
See Also