software

Does anyone know how to nest an AND function into an array. Suppose
I'm trying to find the highest column B value that coresponds to a
column A value between 92.05 and 92.25

A B
922.89
92.017.03
92.024.67
92.062.76
92.115.11
92.133.25
92.215.58
92.277.47
92.297.5
92.37.04

I've tried this array formula
{=MAX(IF(AND($A$1:$A$10gt;=92.05,$A$1:$A$10lt;92.25),( $B$1:$B$10)))}
but it returns a 0. If I take out the AND function and only compare
column A values above or below one threshold it works. How do I make
this search work?

ThanksYou cannot use Boolean function in an array function but you can use Boolean
operators: AND is *, OR is
SO you could use this (entered, of course, with CTRL SHIFT ENTER
=MAX(IF(($A$1:$A$10gt;=92.05)*($A$1:$A$10lt;92.25),($B $1:$B$10)))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Vincequot; gt; wrote in message ups.com...
gt; Does anyone know how to nest an AND function into an array. Suppose
gt; I'm trying to find the highest column B value that coresponds to a
gt; column A value between 92.05 and 92.25
gt;
gt; A B
gt; 92 2.89
gt; 92.01 7.03
gt; 92.02 4.67
gt; 92.06 2.76
gt; 92.11 5.11
gt; 92.13 3.25
gt; 92.21 5.58
gt; 92.27 7.47
gt; 92.29 7.5
gt; 92.3 7.04
gt;
gt; I've tried this array formula
gt; {=MAX(IF(AND($A$1:$A$10gt;=92.05,$A$1:$A$10lt;92.25),( $B$1:$B$10)))}
gt; but it returns a 0. If I take out the AND function and only compare
gt; column A values above or below one threshold it works. How do I make
gt; this search work?
gt;
gt; Thanks
gt;
Thanks, that was painfully simple.