I want to test whether any of my array elements are less than a value and
have entered the following formula. If they are the result returns TRUE.

This is what I am working with so far;

{=A1:A3<B1}

Basically this is intended to return true if any of A1, A2 or A3 is less
than B1.

This works for combinations where A1 is less than B1

Eg. A1<B1, A2B1, A3B1 or A1<B1, A2B1, A3<B1

but it returns false if A1B1

Eg. A1B1, A2<B1, A3<B1

I want if to return true for any permutation of A* < B1

Any help appreciated

Bruce