Excel 2002: How to identify error in a column ?

[Mr. Low]

Hi,

Lets consider the table below:

A B
8 <---- Test Result
11 OK OK
12 OK OK
13 OK ERROR
14 OK OK


Column A and B are the result of analysing the data. All the rows need to
have OK to pass the test. If any row has an "ERROR", it failed the test.

May I know what formula at Cell A8 and B8 to pick up "OK" and "ERROR" in
column A and B respectively ?

Thanks

Low

 

[Alvina Burch]

How do you set up a Break Even Analysis Work sheet

 

[phildy]

In cell A8 try =IF(COUNTIF(A11:A14,"ERROR")>=1,"ERROR","OK")
and in B8 =IF(COUNTIF(B11:B14,"ERROR")>=1,"ERROR","OK")

This just prints error if at least 1 error is detected otherwise prints OK.

This is fine unless EORROR is mistyped.

 

[Shane Devenshire]

Hi,

The following formula works for both columns:

=IF(COUNTIF(A11:A14,"ERROR"),"Error","OK")

You can simplify this down to

=IF(COUNTIF(A11:A14,"E*"),"Error","OK")

If this helps, please click the Yes button.

cheers,
Shane Devenshire