Array with multiple criteria problem

[Frank Kabel]

Hi
not tested but try
{=STDEV(IF(($A$2:$A$23>$C2)*(A2:A23<=C20),$B$2:$B$23))}

-----Original Message-----
I have been unable to use the AND function in an array.

I am able to get the following array to work: {=STDEV(IF
($A$2:$A$23>$C2,$B$2:$B$23))} but this will not work:
{=STDEV(IF(AND($A$2:$A$23>$C2,A2:A23<=C20),$B$2:$B$23))}.
Any suggestions as to why the AND function in the array is
not working are greatly appreciated.

 

[Guest]

Thanks -- that has yielded a value. Can you tell me what the "*" evaluates to in that expression? Is it a proxy for "AND" or does it actually execute some type of multiplication

Thanks.

 

[Frank Kabel]

Hi
the '*' multiplies the boolean values. TRUE=1, FALSE=0.
result only TRUE*TRUE will result in 1 (which represents
TRUE)

-----Original Message-----
Thanks -- that has yielded a value. Can you tell me what

the "*" evaluates to in that expression? Is it a proxy
for "AND" or does it actually execute some type of
multiplication?