How do I use ISERROR in Excel?
Use ISERROR when you want to check whether a result is an error. Enter Value in that order, then add optional arguments when needed.
Excel Function
ISERROR
Checks whether value is any error.
ISERROR(value)Arguments
value
RequiredEnter an expression such as comparison or calculation.
Practice Preview
Use ISERROR to check whether VLOOKUP("Not found",B2:D8,3,FALSE) results in an error.
Example Table
| # | AValue 1 | BValue 2 | CValue 3 | DResult |
|---|---|---|---|---|
| 2 | 120 | Text | ||
| 3 | 98.5 | 100 | ||
| 4 | 0 | N/A | ||
| 5 | 45 | Test | ||
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ISERROR(VLOOKUP("Not found",B2:D8,3,FALSE))Result
TRUE
Practice This Function
ISERROR FAQ
Where can I practice ISERROR?
Use the "Start Function Practice" button to jump straight into ISERROR drills.
What arguments does ISERROR use?
The main arguments are Value. Enter them in order.