Check If A Cell Has An Error In Excel

No matter how much we hate errors they seem to be inevitable.Sometimes dynamically we are required to check the cells if they have an error. ISERROR  function in excel comes to our rescue in these scenarios.

Let’s see how to find out if a cell has an error in excel.

ISERROR (Value) takes the cell reference as input and returns true or false depending on whether the cell has error or not respectively.

Suppose we want to check the values in the column B has error or not.




Capture

Enter the ISERROR formula in the column C.

Capture

Below you could see the result of the ISERROR formula

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply