ERFC in Excel: Calculate Complementary Error-Function Tails Directly

• Introduced: documented by the official Excel 2010 change record, which lists improvements to this existing identity; its first release is not established.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official ERFC reference. Documentation and independent models; no native Excel execution or wider platform certification.

=ERFC(x)

X is required. Microsoft identifies it as the lower integration bound of the complementary function. This is a mathematical function, not a mechanism for catching worksheet errors.

The standard complement satisfies ERFC(x)=1−ERF(x) mathematically. The two quantities can have very different sizes even though they sum to one.

Use the current worksheet signature above. A VBA method’s argument listing or historical add-in guidance is a separate interface and is not a reason to add another parameter to a worksheet ERFC formula.

Enter 0, 0.5, 1, 1.5 and 2 in A2:A6. Use =ERFC(A2) in B2 and fill down.

These are independent mathematical expectations rounded to nine decimals. The tail decreases across these increasing positive endpoints.

Keep the unrounded B results for later differences. A display rounded to zero does not necessarily mean that the mathematical integral is zero.

For A4=1, compare:

=ERF(A4)+ERFC(A4)
=1-ERF(A4)

The independent target for the first is one. The second has target approximately 0.157299207, matching ERFC(1).

ERF supplies the cumulative value from zero. The relationship is a mathematical identity, not a claim that all implementations calculate the complement by literal subtraction.

For a moderate fixture, =ABS(ERF(A4)+B4-1)<1E-9 is an explicit reconciliation test. It is not a universal accuracy specification for every tail size.

For ordered endpoints a and b, subtract ERFC(b) from ERFC(a). In D2 enter 0.5 and in E2 enter one. Compare:

=ERFC(D2)-ERFC(E2)
=ERF(D2,E2)

The independently expected value is 0.322200915. The first tail contains the second tail plus the finite interval, so subtracting them isolates that interval.

For the next interval from one to 1.5, the target is approximately 0.123404354. Reversing the two tail terms would reverse the mathematical sign; the worked formulas deliberately use ordered nonnegative endpoints.

For endpoints 0, 0.5, 1, 1.5 and 2, calculate adjacent tail differences. Their independent interval targets are 0.520499878, 0.322200915, 0.123404354 and 0.029217119.

Add the four unrounded differences and the remaining ERFC(2) tail. The independent total is one. This makes the missing tail visible instead of incorrectly treating the finite interval zero to two as the entire normalized integral.

The four finite contributions sum to approximately 0.995322265, while the remainder is approximately 0.004677735. Display rounding can slightly alter a sum if the displayed values are copied rather than calculated values retained.

For endpoints four and six, independent high-precision mathematical values are approximately:

Use scientific notation when inspecting these values. A fixed nine-decimal display makes the second look like zero even though its mathematical value is positive.

In an independent binary floating-point model, rounding an ERF value extremely close to one can make 1-ERF(x) lose the small difference entirely. This is a numerical illustration, not a recorded Excel result. Calling ERFC expresses the desired tail directly without introducing that subtraction into the user’s formula; native extreme-tail accuracy remains untested.

ERFC.PRECISE has the same current mathematical description but a separately documented Excel 2010 introduction. The official 2010 change record lists existing ERFC among algorithm-improved functions and ERFC.PRECISE among new functions.

That history does not establish identical implementation callbacks, universal precision superiority or retirement of the older worksheet name. Both current dedicated references remain documented.

Microsoft assigns #VALUE! to nonnumeric x. The dedicated worksheet reference does not settle every text-number, Boolean, blank or competing-error case. Historical VBA negative-input restrictions are not imported into this current worksheet guide; all worked endpoints are nonnegative.

Its ERFC(1) example prints 0.15729921, matching independent mathematics at that precision. New outputs are independent models, not native Excel captures, and platform eligibility remains limited to the full documented list above.

• Microsoft ERFC reference.
• Editorial testing standards.

Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.