Checks if a value is any error type except #N/A.
Söz dizimi
ISERR(value)Bağımsız değişkenler
valuezorunlu
The value or expression you want to test for an error.
The ISERR function returns TRUE if the provided value is an error such as #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. Unlike the ISERROR function, ISERR specifically excludes the #N/A error from its TRUE result.
=ISERR(1/0)→TRUEReturns TRUE because 1/0 results in the #DIV/0! error.
=ISERR(NA())→FALSEReturns FALSE because ISERR ignores the #N/A error.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISERR(A1) and press Enter to check if cell A1 contains an error.
ISERR returns FALSE for #N/A errors, while ISERROR returns TRUE for all error types including #N/A.