I have 2 sets of values (2 columns [column A & B] of values having different mechanical definitions), they need to meet 2 sets of specific criteria. for example, cells A2 and B2 need to meet 2 different mechanical criteria, if they both could meet one or more of the conditions, they could be considered in the next step......
and so do other cells in the same row(Ai and Bi....or Aj and Bj)

A little more detail about how to judge if the conditions are met or not......let the values in column A and B subtract the conditions....if they are not negative they are possible(for any values in column A and B,they will get at least 1 positive condition)

I am thinking to convert the result from 'negative or positive' to '0 or 1' (or 'false or true'). Certainly, they are in array (matrix form). Multiply 2 sets.......only outcomes are 1 will be pick up for further operations....

So here comes to the question, which function could do what i describe...... I know I can do it by if-condition function......somehow I think there must some function(s) could make it easier....they are too many miseries in EXCEL. I have not dig all them out....

Please help me to dig deeply....


Thanks.