sunnypeaceisland.com

[Excel] Sammy Wu's Question

首先,在 I2 输入以下函数


                          =IF((COUNTIF(A2:H2,79)+
              COUNTIF(A2:H2,80)+
              COUNTIF(A2:H2,81)+
              COUNTIF(A2:H2,82)+
              COUNTIF(A2:H2,83)+
              COUNTIF(A2:H2,84)+
              COUNTIF(A2:H2,85))>0,"OK","NG")

完成

Source: ---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.