Paul Smith 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.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
