Permutations of an array element < to a value
Bruce
If the following is true
A1B1, A2<B1, A3<B1
The formula
{=A1:A3<B1} will return
{FALSE;TRUE;FALSE}
but as indicated will display the first element
If you wish to know if one or more TRUE conditions are returned
{=OR(A1:A3<B1)} will do
the other option is to first return the smallest value from the range and
then do one comparison.
This removes the need for an Array Formula
eg. =Min(A1:A3)<B1
Dav's formula worked by retuning the max of {0;1;0} which is in a way
mimicking the built in OR function
hth RES
|