Checks if the value given as argument is any type of error. Returns TRUE if it is an error, FALSE if it isn’t.
Iserror syntax
=ISERROR(Value)
| Argument | Argument description | |
|---|---|---|
| 1 | Value | The value that is checked to be an error. |
Returns: TRUE if Value is an error, FALSE if it is not.
Example – Try it for yourself
Explanation
Calculating the ratio between two things requires dividing the two things. In this case, dividing the number of chairs by the number of people to get the chairs per person ratio. If we have 0 people, we end up dividing by 0. Dividing by 0 is not allowed in mathematics, so Excel shows an error.
Then, we use ISERROR to see if we received an error message. If we did, it gives back the value TRUE. Otherwise, it returns FALSE.
Questions
No, there is not. However, you could create a formula that works that way by using the ISERROR and the NOT function like this: =NOT(ISERROR(A1)).
#DIV/0, #N/A, #REF, #VALUE, #NUM, #NAME and #NULL.