On Tuesday 20 September 2005 02:12 pm, David Chapman wrote:
> FWIW, Excel has same output.
>
> Dave
>
> On 9/20/05, Paul Smith <[EMAIL PROTECTED]> wrote:
> > Dear All
> >
> > 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?
> >
> > Thanks in advance,
> >
> > Paul
Here is how you can solve this problem:
A1:B2 contain 1,2,3,8.
In A3 enter this array formula: {=IF(A1:B2>2;"YES";"NO")}
In A5 enter this array formula: {=IF(A1:B2<4;"YES";"NO")}
In A7 enter this array formula: {=IF(A3:B4=A5:B6;"YES";"NO")}
The array in A7:B8 contains NO,NO,YES,NO which is what you want. I
do not know if the first two array formulas can be combined into a
single array or not.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
