When using ERFC, the most common questions are about formula entry, unexpected results, and function behavior; this FAQ covers 3 common questions.
FAQ
What should I do if the ERFC function shows an error?
- Check whether the formula starts with
=. - Confirm that the function name is spelled
ERFCand that the parentheses are complete. - Check whether the number of arguments and the argument format are correct.
- If the formula references other cells, confirm that those cells contain values that can be used in numeric calculation.
How can I view the parameter prompt for ERFC?
- Select the target cell or click the formula bar.
- Type
=ERFC(. - Review the syntax prompt shown in the interface.
- Complete the argument based on the prompt and finish the formula.
How can I troubleshoot an ERFC result that does not look right?
- Check whether the cells used in the formula are stored as numeric values.
- Confirm that there are no invalid references, blank values, or text values in the calculation path.
- If ERFC is nested with other functions, test the formula in smaller parts.
- After changing source data, confirm that the result updates as expected.
Glossary
| Term | Definition |
|---|---|
| ERFC | The complementary error function, used in a spreadsheet formula to return a calculated result for a given value. |
| Formula bar | The area used to enter and edit formulas, especially helpful for longer expressions. |
| Nested calculation | A formula structure that uses other functions or expressions inside the same formula. |