Practice free

ERFC function

ERFC returns the complementary error function, which is 1 minus ERF. It stays accurate for large values, where subtracting ERF from 1 would lose precision, and it accepts negative values.

Example

Read it as a sentence: find the complementary error function value for 1, which gives 0.157299207050285.

Practice this in the app

Syntax

ERFC(x)

x (required)
The lower limit of integration (upper is infinity).

Returns: The complementary error function, 1 minus ERF(x).

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ERFC(0.5) 0.479500122 0.5
=ERFC(0) 1 0
=ERFC(-0.5) 1.520499878 Negative
=ERFC(10) 2.08849E-45 Large
=ERFC("0.5") 0.479500122 Text number
=ERFC({0.5,1}) 0.479500122 Spill
=ERFC("a") #VALUE! Text
=ERFC(TRUE) #VALUE! TRUE

Watch out for

  • Negative x is allowed.

Where it works

Excel
ERFC is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .