Expand Minimize

WorksheetFunction.ErfC Method (Excel)

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

Important note Important

This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. This function is still available for compatibility with earlier versions of Excel. However, if backward compatibility is not required, you should consider using the new functions from now on, because they more accurately describe their functionality.

For more information about the new function, see the ErfC_Precise method.

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

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.

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

=ERFC(1)
Show:
© 2014 Microsoft