EXCEL ERFC FUNCTION

The Excel ERFC function computes the Complementary Error Function, which is integrated between a lower limit specified and infinity.

Syntax :

=ERFC( x )

Parameters :

  • The integral’s lower limit is given by x.

Step By Step Guide of ERFC Function

Example :

The Excel Erfc function is used in the following spreadsheet to calculate the Complementary Error Function integral for three distinct lower bounds.

  • #NUM! – This error occurs in previous versions of Excel (Excel 2007 or before) when the given value of x is negative.
  • #VALUE! – Occurs if the value of x provided is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now