Checks if a value is any error type and returns TRUE or FALSE.
Cú pháp
ISERROR(value)Đối số
valuebắt buộc
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.