公式如下:
OR( AND(LEN(SQL("gz","SELECT 1 FROM BANK_CASE WHERE ISNULL(cas_file_no,'')='" + A2 + "' AND ISNULL(cas_area_3,'') IN ('温州支行','苏州分行','无锡支行','台州分行')",1))>0,K2=="华东包干区"), AND(LEN(SQL("gz","SELECT 1 FROM BANK_CASE WHERE ISNULL(cas_file_no,'')='" + A2 + "' AND ISNULL(cas_area_3,'') IN ('温州支行','苏州分行','无锡支行','台州分行')",1))<=0,K2==SQL("gz","SELECT cas_area_3 FROM BANK_CASE WHERE ISNULL(cas_file_no,'')='" + A2 + "' AND ISNULL(cas_area_3,'') not IN ('温州支行','苏州分行','无锡支行','台州分行')") ) )
![](https://hwobs-sq.fanruan.com/shequ_forum/image/dd06fdef678d9301b2c522701f7b8566.png)
![](https://hwobs-sq.fanruan.com/shequ_forum/image/5f9dc571ea915e6daa0c9a88080c0322.png)
这BUG还是怎么回事? |