ISERROR Function

ISERROR() is an information function that returns TRUE / FALSE on whether the expression is an error value or not. The error value may be like "#N/A, #NUM!, #REF!, #VALUE!, #NAME?, #DIV/0!, #NULL!".

Formula:


=ISERROR(Value)
In above syntax, "value" refers to the value, which you like to test.

Video Tutorial:


Let us view how the ISERROR() returns TRUE/FALSE on checking the values, with the help of below video.

Learn MS Excel


Ask Questions

Ask Question