Checks if a value is any error type and returns TRUE or FALSE.
Синтаксис
ISERROR(value)Аргументы
valueобязательно
The value or expression you want to test for an error.
The ISERROR function identifies if a cell or expression results in any error, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. It is commonly used in conjunction with the IF function to handle potential errors gracefully in your calculations.
=ISERROR(10/0)→TRUESince dividing by zero results in a #DIV/0! error, the function returns TRUE.
=ISERROR(10/2)→FALSESince the calculation is valid, the function returns FALSE.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISERROR( followed by the cell reference or expression you want to check, then close the parenthesis.
ISERROR checks for all error types, whereas ISERR checks for all errors except #N/A.