{=(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]
