公式如下:
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 ('温州支行','苏州分行','无锡支行','台州分行')") ) )
这BUG还是怎么回事? |