ISERR(list)

The ISERR function checks the list and returns a count of the number of cells that contain #CIRC, #FUNC, #DIV0, #VALUE or #REF error indicators (see Cell error indicators). The list can be cell addresses, ranges, and cell names.

You can combine the IF function (see IF(x, true, false)) and the ISERR function to check for errors and return an error message if something is incorrect. For example, in a spreadsheet that runs from A1 to E20, you might use the following:

IF(ISERR(A1..E20), "A problem", "No problem")

See also:

Other information functions