ExcelFlux

ERFC function

the complementary error function.

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Find the complementary error function. Compare it with one minus ERF.

A worked example from the workbook

RowA
6Input
70
80.5
91
Record 1
=ERFC(A7)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ERFC(A7)
Turkish Excel · tr-TR
=TÜMHATAİŞLEV(A7)

Worked examples

Find the complementary error function. Compare it with one minus ERF.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 0
8 0.5
9 1
Case Formula Expected result
Record 1 =ERFC(A7) 1
Record 2 =ERFC(A8) 0.4795001222
Record 3 =ERFC(A9) 0.1572992071
Microsoft Excel reference