ERFC in WPS Spreadsheet: Calculate the Complementary Error Function
Evaluate WPS ERFC for small nonnegative inputs with independent integral values, complement interpretation and a documented nonnumeric-input error.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =ERFC(0.5) has independent expected value approximately 0.479500122187. ERFC is the complementary error function, corresponding to the normalized Gaussian integral from the argument to infinity.
Syntax and mathematical meaning
=ERFC(x)
The required numeric argument x is the lower integration limit. Mathematically,
erfc(x) = (2/sqrt(pi)) * integral from x to infinity of exp(-t^2) dt
For the small nonnegative inputs used here, erfc(x)=1−erf(x). This is a complement relationship between two distinct function results, not an alias or a reason to substitute one function name for the other without changing the calculation.
Complete worksheet example
Enter 0, 0.5, 1 and 2 as numeric values in A2:A5. Put =ERFC(A2) in B2 and copy the cell reference down.
| Input x | Independent expected value |
|---|---|
| 0 | 1 |
| 0.5 | 0.4795001221869535 |
| 1 | 0.1572992070502851 |
| 2 | 0.0046777349810473 |
The values decrease as the lower limit moves right and less of the nonnegative integrand remains. The output is a real number, not an error message or an estimated measurement error.
A literal control is =ERFC(0.5). Compare its numerical meaning with the value in the table, allowing for the application’s display precision. The listed digits come from an independent calculation and do not guarantee the accuracy or number of displayed digits of an untested WPS build.
The official walkthrough includes x=2 with a displayed result consistent with 0.004677735. That is historical documentary evidence; the table above is an original independently checked dataset.
Advanced use: relate the function to a normal tail
For a standard normal variable Z, the mathematical upper-tail relation is P(Z>z)=erfc(z/sqrt(2))/2. Choosing z=sqrt(2) makes the ERFC argument exactly 1, so the upper-tail probability is approximately 0.0786496035251426. The two-sided probability beyond ±sqrt(2) is approximately 0.1572992070502851.
This illustrates the normalization and factor of one-half. ERFC(x) itself is not automatically the one-sided normal-tail probability at x. The input transformation and scaling matter. Such a probability is conditional on a chosen mathematical distribution; it is not the probability that a hypothesis is true.
The complement identity can provide a hand check for modest inputs. For very small tails, subtracting a rounded ERF value from 1 can lose information. That numerical observation does not establish which algorithm WPS uses internally, and this guide does not certify extreme-tail precision.
Errors and scope boundaries
The lesson explicitly states #VALUE! for nonnumeric x. Thus =ERFC("bad") has that documentation-based error expectation. It has not been executed here.
Negative inputs, huge magnitudes, underflow, blank cells, logical-value coercion and numeric text are outside the bounded worked cases. The cited lesson does not provide a complete rule set for those situations, so no error code or coercion behavior is imported from another spreadsheet.
Keep the integration variable distinct from any domain-specific measurement. A model may first standardize or scale a quantity before using an error function; ERFC does not choose that model, estimate its parameters or validate its assumptions.
Evidence and version scope
The official WPS Academy ERFC lesson, published 2019-06-14, has the applicability scope recorded below. It was reviewed on October 18, 2026. Its applicability edition/platform field is blank; footer links do not establish a platform. The numeric build, introduction release and last supported version remain unknown. The source does not identify this function as deprecated or retired. Support in Linux, other editions and other platforms is not established by this lesson.
The worked examples are original mathematical expectations based on the official contract and formula illustration. They were not executed in WPS. Historical vendor demonstrations are documentation, not our application tests; no screenshot or runtime precision guarantee is supplied. English names and comma separators follow the lesson. Localized entry, workbook interchange and exact output formatting require verification in the intended client.