The other solutions given will also work for conditions on different-but-same-size ranges (but without limit - not that I believe anyone would reach it)
The 'new functionality' provides a less geeky way of doing it, though using the array (or Boolean) method does allow you to construct more convoluted conditions (using '*' for 'AND', '+' for 'OR')
Similar techniques allow you to avoid tortuous 'nested IF' statements, but that's different topic for another time, eh Susan?