Using MIN on range with upper and lower bounds

**MWMike** · 12-13-2011, 12:51 PM

Hi all,
I have two named ranges, "Frequency" and "Power". I'm trying to find the minimum power level within a certain bandwidth (between two frequencies). Here is my formula:

{=MIN(IF(AND(Frequency>1215,Frequency<1400),Power,""))}

With this formula I get #Value!, and the error says "A value used in the formula is of the wrong data type."

However, when I take out the AND statement and only have the lower bound, as in the formula below, it works fine.

{=MIN(IF((Frequency>1215),Power,""))}

Any ideas as to what is going on here? I've attached my workbook to play around with.

Thanks!

**NBVC** · 12-13-2011, 01:14 PM

Try:

=MIN(IF((Frequency>1215)*(Frequency<1400),Power,""))

**MWMike** · 12-13-2011, 02:09 PM

Hey thanks, that was fast! Not totally sure why my previous formula doesn't work correctly, but yours works great. This will open up a lot of possibilities here. Much appreciated.