Engineering

ERFC Function in Excel

Returns the complementary error function integrated between x and infinity.

Syntax

  • =ERFC(x)

Arguments

  • x (required): Lower bound for integration

Examples

  • =ERFC(1) - Complementary error function - Result: 0.157

ERFC in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • Must be numeric

Use cases

  • Statistics
  • Engineering
  • Signal processing

Frequently asked questions

  • What is the ERFC function in Excel? ERFC returns the complementary error function integrated between x and infinity. The syntax is =ERFC(x). Typical use cases include statistics, engineering, signal processing.
  • How do I use the ERFC function? To use ERFC, type =ERFC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is ERFC not working in my Excel? Common issues with ERFC include Must be numeric. Start by checking the syntax =ERFC(x), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use ERFC

  • Statistics — common Engineering scenario for ERFC.
  • Engineering — common Engineering scenario for ERFC.
  • Signal processing — common Engineering scenario for ERFC.

ERFC in the Engineering category

  • Browse all Engineering functions at /categories/engineering/ for related formulas.
  • ERFC syntax: =ERFC(x)
  • x (required): Lower bound for integration
  • Confirm ERFC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm ERFC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • ERF (/functions/erf/): Returns the error function integrated between lower_limit and upper_limit.
  • ERFC.PRECISE (/functions/erfc-precise/): Returns the complementary error function integrated between x and infinity with higher precision.
  • NORM.S.DIST (/functions/norm-s-dist/): Returns the standard normal distribution (mean=0, std=1).

Errors to watch for

  • Must be numeric — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter ERFC on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

ERFC worked examples to copy

  • =ERFC(1) — Complementary error function. Expected result: 0.157.

ERFC reference summary for crawlers and offline review

  • ERFC belongs to the Engineering category in Excel. Returns the complementary error function integrated between x and infinity.
  • Full syntax: =ERFC(x). Open /functions/erfc/ for parameters, FAQs, and related pages.
  • Common mistakes: Must be numeric
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.