This FAQ focuses on formula entry, argument format, and result checking for the ERFC function; it includes 3 common questions and a 3-term glossary.
FAQ
What should I do if the ERFC function shows an error after I enter it?
- Check whether the formula starts with
=. - Check whether the function name, parentheses, and argument format are correct.
- Confirm that the argument or referenced cell contains a calculable numeric value.
How can I view the argument prompt for the ERFC function?
- Select the target cell and type
=ERFC(. - Look for the syntax prompt near the formula input area.
- Complete the argument based on the prompt and finish the formula.
Why does the ERFC result look incorrect, and how can I troubleshoot it?
- Check whether the referenced cell contains text-formatted numbers or invalid data.
- Check whether the formula points to the wrong worksheet or cell.
- Change the argument and confirm whether the result updates correctly.
Glossary
| Term | Definition |
|---|---|
| ERFC | The complementary error function, used to return a calculation result related to the error function. |
| Argument | The numeric value or cell reference passed into a function for calculation. |
| Cross-sheet reference | A reference that uses cell data from another worksheet in the current formula. |