This function returns TRUE if the value is an error value. Otherwise, it returns FALSE.
- Exception: Unlike ISERROR(), this function does not recognize #N/A as an error and returns FALSE for it.
Syntax
ISERR(value)
Arguments
- value (required) – The expression (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name) that you want to check.
Background
This function is one of the nine IS() functions that return a logical value based on the argument. The argument in IS() functions is not converted for evaluation—meaning a numeric string is treated as text, not a number.
IS() functions are often used with IF() to pre-test calculations. Their results can also be used in conditional formatting and data validation rules.
For more on identifying specific errors, see the ERROR.TYPE() function examples.
Example
Suppose you want to calculate the average of a range (B26:B28) while avoiding errors if no numbers are present.
=IF(ISERR(AVERAGE(B26:B28)); « Check the input values. »; AVERAGE(B26:B28))
IMAGE ISERR
- If AVERAGE(B26:B28) results in an error (except #N/A), the formula returns « Check the input values. »
- Otherwise, it returns the calculated average.