On 9/20/05, Niklas Nebel <[EMAIL PROTECTED]> wrote:
> > I have a squared array with the following elements: 1,2,3,8. When I
> > apply the formula
> >
> > {=IF(AND(A1:B2>2;A1:B2<4);"yes";"no")}
> >
> > I get a second squared array filled only with "no", which is wrong, as
> > the element 3 satisfies the AND condition.
> >
> > Do you confirm this as a bug?
>
> AND isn't calculated separately for the array elements, but operates on
> the whole array, returning a single value. This is similar to
> {=SUM(A1:B2)}, which doesn't return a 4-member array, but the single
> number 14.
Correct, I understand it now. Thanks, Niklas.
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
