数字范围內判定为OK (10615)

D8:H8=IF((MAX(D2:D6)<=$B2)*(MIN(N(IF({1},D2:D6)))>=$B3),"OK","NG")

另解{=IF(AND((D2:D6<=$B2)*(D2:D6>=$B3)),"OK","NG")

另解{=IF(PRODUCT((D2:D6<=$B2)*(D2:D6>=$B3)),"ok","NG")