ERFC

The ERFC function returns the complementary ERF function integrated between a given lower bound and infinity.

ERFC(lower)

lower: A number value representing the lower limit or bound.

Examples
=ERFC(-1) returns 1.84270079294971. =ERFC(1) returns 0.157299207050285. =ERFC(12) returns 1.3562611692059E-64. Note: To see the value of ERFC(12) in this format, select the cell, click the Cell tab at the top of the sidebar on the right, then click the Data Format pop-up menu and choose Scientific.

Examples

=ERFC(-1) returns 1.84270079294971.

=ERFC(1) returns 0.157299207050285.

=ERFC(12) returns 1.3562611692059E-64.

Note: To see the value of ERFC(12) in this format, select the cell, click the Cell tab at the top of the sidebar on the right, then click the Data Format pop-up menu and choose Scientific.