Array formula which compares values, ignores blanks, and results in a single accept/reject

I have rows of a range of values to compare to a fixed maximum (G10) and minimum (G9) value and return a 'reject' if any value is outside the specified range or an "OK" if values are accpetable. Occasionally a cell or three will be blank in each row.

Please Login or Register  to view this content.

The first test (A14) ensures there is supposed to be values in the row to compare.

Results are either "OK" or "FALSE", but not consistent with inputs. There are true accepts, false accepts (values are bad, but result says 'OK'), no false rejects (bad values result in either "OK" or "False"), and no true rejects (bad values do not result with 'Get help').

Is this the correct approach or is there a better method?

Help?

Which is why periodically the engineer must be shot to start production. Always making things complicated.

It works. Exactly what I needed. Thank you.

Any idea why the original formula would not work and results varied?

I used the 'evaluate formula' tool. It came up with the correct answer about half-way through the evaluation, then lost it in the remaining IF statements. It showed the entire array being evaluated three times with the correct answers for each evaluation, but couldn't resolve to a single correct answer.