Here's my formula challenge . .

I'm using this formula which gives me an undesired "Fail" indication if only one value is less than 10:
=IF(AND(COUNT(D27:D38)>=1,MIN(D27:D38)>=$F$48,MAX(D27:D38)<=$G$48),"Pass","Fail")

Here's what I need . . .

If all of the values are less than 10, I need a “Fail” indication.

If only one of the values in the range is >= 10 AND <=30, I want a “Pass” indication, OR if all of the values in the range are>= 10 AND <=30, I want a “Pass” indication.

Also, if any one value exceeds 30, then I want a “Fail” indication.

D
15.0
17.9
17.9
15.7
11.1
10.4
10.4
20.9
20.9
20.9
20.9
20.9


46 F G
47 NLT NMT
48 10 30