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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
