How do you set up a Break Even Analysis Work sheet
"Mr. Low" wrote:

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

--
A36B58K641