Coding for comparing sections of columns for greater than/less than conditions

Anyone know how to program the following

I need to see if any of the values in C are greater than any of the values of B and any of the values of C are less than any of the values of A.

Example

A B C
3 3 8
4 5 6
2 6 7
1 7 4

As long as all the values in C dont exceed any value in B and dont fall below any value of A the condition is true. If there was a 9 in any of the B's, this would be false. If there was a 0 in any of the A's this would be false.

I think you might have gotten the conditions the other way round.

If so, you could a formula something along the lines of...

Please Login or Register  to view this content.

Thanks for the help. I had tried that but I was looking for a condition that makes sure none of the values in C are greater than any of the values in B or less than any of the values in A. If I'm reading what you put below correctly, that covers just the conditions of single cells.

Originally Posted by quekbc

I think you might have gotten the conditions the other way round.

If so, you could a formula something along the lines of...

Please Login or Register  to view this content.