=IF(AND(G2="51",D2>=20000),"通过",IF(AND(G2="52",D2>=5000),"通过",IF(AND(G2="61",D2>=2000),"通过",IF(AND(G2="62",D2>=2000),"通过","不通过"))))
批发零售、住宿餐饮限额以上Excel语句
最新推荐文章于 2024-09-04 13:15:24 发布
=IF(AND(G2="51",D2>=20000),"通过",IF(AND(G2="52",D2>=5000),"通过",IF(AND(G2="61",D2>=2000),"通过",IF(AND(G2="62",D2>=2000),"通过","不通过"))))