V3格请放入以下函数就可以了:




=IF(B3="NA","NA",
IF(AND(B3="RQ",L3>=6),"NA",
IF(AND(B3="RQ",L3<6),"RQ",
IF(AND(ISNUMBER(B3),B3>L3),B3-L3,
IF(AND(ISNUMBER(B3),B3<=L3),"RQ",
"所有条件不成立,请检查数据")))))
              

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.

---