How to Use the ERFC Function in WPS on Windows

Last updated:July 20, 2026

This how-to guide includes 4 operation topics, all available without membership; use the index below to enter the function, fill arguments, add references, and check results.

How-to Index

No.TopicMembership Requirement
11. Enter the ERFC functionFree
22. Fill in the argument with promptsFree
33. Use cell or cross-sheet referencesFree
44. Check the result and recalculateFree

How-to Guide

1. Enter the ERFC function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and go to the worksheet where you want the result.
  2. Select the cell that should display the result.
  3. Type = in the cell or in the formula bar.
  4. Type ERFC( to begin the function.

Success Criteria

  • Interface result: The selected cell enters formula editing mode.
  • What you can do next: You can continue entering the argument and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.

2. Fill in the argument with prompts

Entry point: Select the target cell and type the formula directly

  1. After ERFC(, enter the number to calculate, or select a cell that contains the number.
  2. Check the syntax prompt shown in the interface.
  3. Type the closing parenthesis ) to complete the formula.
  4. Press Enter to confirm.

Success Criteria

  • Interface result: The cell displays a calculated result.
  • What you can do next: When you select the cell again, you can view the full formula in the formula bar.

Tips While Using

  • Common mistake: An unclosed parenthesis or an invalid argument format can cause a formula error.

3. Use cell or cross-sheet references

Entry point: Formula bar

  1. Enter a cell reference in the formula, for example =ERFC(A2).
  2. If you need a cross-sheet reference, switch to the target worksheet and select the needed cell.
  3. Confirm that the reference address is inserted into the formula.
  4. Press Enter to complete the calculation.

Success Criteria

  • Interface result: The result cell returns a calculated value.
  • What you can do next: When the referenced cell changes, the result can update accordingly.

Tips While Using

  • Common mistake: If the reference points to text content or the wrong cell, the result may not be as expected.

4. Check the result and recalculate

Entry point: Result cell / formula bar

  1. Select the result cell and check whether the formula is written as expected.
  2. Change the argument value or the referenced cell content.
  3. Watch whether the result updates at the same time.
  4. If the result looks incorrect, check the argument, parentheses, and reference position again.

Success Criteria

  • Interface result: The result changes when the input value changes.
  • What you can do next: You can copy the formula or extend it to other cells.

Tips While Using

  • Common mistake: If the argument is not a valid number, the function may not return a normal result.