关于excel中IF、AND和OR套用的问题
发布网友
发布时间：2022-05-02 10:17
共1个回答
热心网友
时间：2022-06-19 05:55
小于等于号不能写成≤,而要写成 <=
=IF(AND(C3="广东",E3<=3),6,IF(AND(OR(C3={"广西","江西","海南","湖南","福建","上海","江苏","浙江","湖北","安徽","贵州","云南","山东","山西","河北","河南","四川","陕西","重庆","北京","天津"}),E3<=3),7,IF(AND(OR(C3={"内蒙古","吉林","宁夏","甘肃","青海","黑龙江","辽宁"}),E3<=3),9,IF(AND(C3="*",E3<=3),12,))))
