So the answer to the question is no, it is not a bug. It just took some
thinking to come up with the correct array function. In this case,
multiplication of the arrays gives the same results as the AND
function.
Dan
On Wednesday 21 September 2005 10:53 am, David Chapman wrote:
> {=(A1:B2>2)*(A1:B2<4)}
>
> On 9/21/05, Dan Lewis <[EMAIL PROTECTED]> wrote:
> > 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]
>
> --
> My OpenOffice Calc Website
> http://www.openofficetips.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
