View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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