Logical expressions using array operations

Hi guys, I have a question regarding logical operations (Picture is attached)

In cell F58 I entered: =OR(B58:B60>5,B58:B60<10) which outputs the correct logical answers.

In cell E58 I entered: =(B58:B60>5)*(B58:B60<10) which outputs the correct binary logical answers.

Now what I'm confused with is that if I enter =AND((B58:B60>5),(B58:B60<10)) in E58, it outputs FALSE, FALSE, FALSE in E58:E60. I am wondering why using the AND logical function does not work? (But using the OR function works?). The array multiplication equivalent of "AND" works though as shown in the picture.

Breaking down the "=AND((B58:B60>5),(B58:B60<10))" formula I am not sure why it doesn't work, I understand the first condition (B58:B60>5) should output the set {FALSE, TRUE, TRUE} and (B58:B60<10) should output the set {TRUE, TRUE, FALSE} so AND({FALSE, TRUE, TRUE} , {TRUE, TRUE, FALSE}) should output {FALSE, TRUE, FALSE} if you just pair up each element, however excel does not output this, why is that? Is there a way to get AND to work using array operations?

Also breaking down the "=OR(B58:B60>5,B58:B60<10)" formula, similarly, the first condition should generate {FALSE, TRUE, TRUE} and the second condition generates {TRUE, TRUE, FALSE}, so clearly if you match up each element then we get {TRUE, TRUE, TRUE} and excel does output that from F58:F60, how is it that AND doesn't work like this then?

Thanks!

it says returns true if all arguments =true or false if any argument is false
so its doing what it says on the tin by design
incidently
normaly entered
=AND(B1:B4>1,B1:B4<5) only actually uses b1 it ignores b2:b4
however array entered {=AND(B1:B4>1,B1:B4<5)} considers all values B1:B4
now OR
=OR(B1:B4>1,B1:B4<5) this must always be true for a range of numbers if a number is greater1 it will give true if a number is less than 5 it will give true, any number fits one of those 2 criteria
however
=OR(B1:B4="y",B1:B4="n") again only b1 is tested unless array entered {=OR(B1:B4="y",B1:B4="n")}

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.