全大於或全小於 判斷 (13641)

日期：

E2=IF(MOD((A2>B2)+(C2>D2),2),"NO","OK")

另解=IF((A2-B2)*(C2-D2)>0,"OK","NO")

另解=IF((A2>B2)+(C2>D2)<>1,"OK","NO")



留言

張貼留言