Array with multiple criteria problem

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

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.
Click to expand...
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.
 
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.
 
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
Click to expand...
the "*" evaluates to in that expression? Is it a proxy
for "AND" or does it actually execute some type of
multiplication?
 
Back
Top