IF(MIN) Formula glitch

[dmad81]

I'm not sure why I'm getting opposite status indications for the formula below in two columns of data (see attached-hopefully I attached correctly). The cells are formatted as "Numbers". An observation is that column E doesn't have any numbers in it, only text.

Is there a better formula to prevent this?

=IF(MIN(H23:H38)>=$C45,"Pass","Fail")

Thanks!

[daddylonglegs]

=MIN(H23:H38) should return 4 (as long as those are actual numbers) and MIN(E23:E38) will return zero (MIN returns zero when there are no numbers in the range), so clearly the two formulas might give you different results - what's in C45, what results do you want to get and why?

[dmad81]

C45 is a numeric value (1.2). I want "Fail" if cell values are < 1.2, and "Pass" if >= 1.2. The "ND" text did not seem to adversely affect the formula when I first used it. But, when entering test data for a trial run, this problem occurred.

[daddylonglegs]

Well, as I said, MIN returns zero when there are no numbers in the range and 0<1.2 so you get "fail", if you expect "pass" when there are no numbers try this version

=IF(OR(COUNT(E23:E38)=0,MIN(E23:E38)>=$C45),"Pass","Fail")

[dmad81]

Here is what I'm getting when I use formula; =IF(OR(COUNT(H23:H38)=0,MIN(E23:E38)>=$C45),"Pass","Fail"). The 1.0 value should cause "Fail".

And, to clarify, the data that will be entered into the cells will be either a numeric value, "ND" or "1st Peak".

Column E
RRT 0.76
ND
ND
ND
ND
ND
ND
ND
ND
ND
ND
1.0
ND
1st peak
ND
ND
ND
Pass

[dmad81]

Disregard my last post. I forgot to change the COUNT range. Now it works! Thanks!