On 9/21/05, Paul Smith <[EMAIL PROTECTED]> wrote:
> > {=(A1:B2>2)*(A1:B2<4)}
>
> I thank David and Dan. Actually, the solution should be
>
> {=IF((A1:B2>2)*(A1:B2<4)>0;"yes";"no")}
>
> but it is only an insignificant detail.It is curious that TRUE and FALSE are not represented, respectively, by 1 and 0 in Excel as they are in Calc. Therefore, David's solution fails in Excel. Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
