判断对错 (9331)

日期：


J2{=IF(OR(COUNTIFS(B2:F2,G2:I2,B2:F2,"<>0")),"对","错")


另解=IF(SUMPRODUCT(COUNTIFS(B2:F2,G2:I2,B2:F2,"<>0")),"对","错")


另解{=IF(COUNT(MATCH(B2:F2,G2:I2,)),"对","错")


留言

張貼留言