When using ISERR, the most common questions involve formula entry, result interpretation, and batch use; this FAQ includes 3 common questions and a short glossary.
FAQ
Why does ISERR not return the result I expected?
- Check whether the formula starts with an equal sign (
=). - Check whether the parentheses are complete and the argument is entered correctly.
- Make sure the tested content actually returns an error value instead of plain text or a number.
How is ISERR different from functions that check blank cells or text?
- ISERR checks whether a result is an error value.
- If a cell only contains a blank, text, or a normal number, ISERR does not treat it as an error.
- When you need to separate error checks, blank checks, and logical tests, use the appropriate functions together.
How can I use ISERR across multiple cells?
- Enter the ISERR formula in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag down or across, or copy and paste the formula into other cells.
Glossary
| Term | Definition |
|---|---|
| ISERR | A function that tests whether an expression returns an error value other than #N/A. |
| Argument | The input inside a function's parentheses that determines how the function calculates. |
| Formula Bar | The input area above the worksheet where you can view and edit formulas directly. |