=min(if

[Mel13]

The following formula is giving me an answer of zero:

=MIN(IF(H3:H8762="<=0.2",J3:J8762))

I need to find the minimum value from all the numbers in column J where the values in column H are less than or equal to 0.2

I am also using CTRL+SHIFT+ENTER

Can anyone help me please? Thank you

 

[Aladin Akyurek]

Try...

Control+shift+enter, not just enter:

=MIN(IF(H3:H8762<=0.2,J3:J8762))

 

[Mel13]

Yes, I am using that, it still doesnt work

 

[Aladin Akyurek]

Yes, I am using that, it still doesnt work

You are using:

="<=0.2"

while it should be just:

<=0.2

 

[Mel13]

That works now! Thank you so much

Now, I need to do the same thing, but use an inbetween criteria, where the value must be: >0.2 and <=0.3 and it's not working

This is what I entered:
=MIN(IF(MetData!H4:H8763>0.2,<=0.3,MetData!J4:J8763))

 

[Aladin Akyurek]

That works now! Thank you so much

You are welcome.

Now, I need to do the same thing, but use an inbetween criteria, where the value must be: >0.2 and <=0.3 and it's not working

This is what I entered:
=MIN(IF(MetData!H4:H8763>0.2,<=0.3,MetData!J4:J8763))

You can use two IF's... Still to be confirmed with control+shift+enter:

=MIN(
   IF(MetData!H4:H8763>0.2,
     IF(MetData!H4:H8763<=0.3,
       MetData!J4:J8763)))