判断三尺寸全符合範圍 (14820)

F5{=IF(OR(ROW(INDIRECT(SUBSTITUTE(B5,"-",":")))=B$2)*OR(ROW(INDIRECT(SUBSTITUTE(C5,"-",":")))=C$2)*OR(ROW(INDIRECT(SUBSTITUTE(D5,"-",":")))=D$2),"符合","不符合")

另解=IF(SUMPRODUCT((B$2:D$2>=TEXT(1%,SUBSTITUTE(B5:D5,"-",";"))*1)*(B$2:D$2<=TEXT(-1%,SUBSTITUTE(B5:D5,"-",";"))*1))=3,"符合","不符合")

另解=IF(AND(MMULT({1,1},SIGN(B$2:D$2-TEXT({1;-1}%,SUBSTITUTE(B5:D5,"-",";"))))^2<4),"符合","不符合")