Find Error

[beckys]

I am looking for a formula that would return a specific value if it finds an error in the data in a separate spreadsheet. I'm thinking along the lines of something like this....


IF(Sheet1!A:A Contains "#N/A", "Error in Sheet1", "OK")

Any thoughts?

Thanks in advance for your help!

 

[wigi]

Hi there,

You could count the number of cells with an error:

=SUMPRODUCT(--ISERROR(A1:A6))

Change the cells.

Wigi