Counting Errors in a Range in Excel
If you need to ensure that a range has no errors you can count the errors and compare the result to zero to ensure the range is error free.
The formula in cell C1 which counts errors in a range is
If you want to display TRUE for no errors and FALSE for error(s) you can use
You can also use an IF function to display the text Error if any errors are found.